APPS.ARP_TMP_PKG dependencies on FND_API

Line 46: x_return_status := fnd_api.G_RET_STS_SUCCESS;

42: x_party_site_number VARCHAR2(30);
43: l_exist VARCHAR2(10);
44: -- x_cust_acct_site_id NUMBER;
45: BEGIN
46: x_return_status := fnd_api.G_RET_STS_SUCCESS;
47:
48: IF p_location_id IS NOT NULL THEN
49:
50: OPEN c_loc_1;

Line 53: x_return_status := fnd_api.g_ret_sts_error;

49:
50: OPEN c_loc_1;
51: FETCH c_loc_1 INTO l_exist;
52: IF c_loc_1%NOTFOUND THEN
53: x_return_status := fnd_api.g_ret_sts_error;
54: END IF;
55: CLOSE c_loc_1;
56:
57: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 57: IF x_return_status = fnd_api.g_ret_sts_error THEN

53: x_return_status := fnd_api.g_ret_sts_error;
54: END IF;
55: CLOSE c_loc_1;
56:
57: IF x_return_status = fnd_api.g_ret_sts_error THEN
58: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
59: FND_MESSAGE.SET_TOKEN('TEXT','Location with the location_id:'||p_location_id||' does not exist');
60: FND_MSG_PUB.ADD;
61: RAISE FND_API.G_EXC_ERROR;

Line 61: RAISE FND_API.G_EXC_ERROR;

57: IF x_return_status = fnd_api.g_ret_sts_error THEN
58: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
59: FND_MESSAGE.SET_TOKEN('TEXT','Location with the location_id:'||p_location_id||' does not exist');
60: FND_MSG_PUB.ADD;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
64: l_loc_id := p_location_id;
65:

Line 68: x_return_status := fnd_api.g_ret_sts_error;

64: l_loc_id := p_location_id;
65:
66: ELSIF p_country IS NULL THEN
67:
68: x_return_status := fnd_api.g_ret_sts_error;
69:
70: IF x_return_status = fnd_api.g_ret_sts_error THEN
71: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
72: FND_MESSAGE.SET_TOKEN('TEXT','Country is a mandatory field if you do not pass the location_id');

Line 70: IF x_return_status = fnd_api.g_ret_sts_error THEN

66: ELSIF p_country IS NULL THEN
67:
68: x_return_status := fnd_api.g_ret_sts_error;
69:
70: IF x_return_status = fnd_api.g_ret_sts_error THEN
71: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
72: FND_MESSAGE.SET_TOKEN('TEXT','Country is a mandatory field if you do not pass the location_id');
73: FND_MSG_PUB.ADD;
74: RAISE FND_API.G_EXC_ERROR;

Line 74: RAISE FND_API.G_EXC_ERROR;

70: IF x_return_status = fnd_api.g_ret_sts_error THEN
71: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
72: FND_MESSAGE.SET_TOKEN('TEXT','Country is a mandatory field if you do not pass the location_id');
73: FND_MSG_PUB.ADD;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76:
77: ELSIF (p_ADDRESS1 IS NULL AND
78: p_CITY IS NULL AND

Line 84: x_return_status := fnd_api.g_ret_sts_error;

80: p_STATE IS NULL AND
81: p_PROVINCE IS NULL AND
82: p_COUNTY IS NULL )
83: THEN
84: x_return_status := fnd_api.g_ret_sts_error;
85:
86: IF x_return_status = fnd_api.g_ret_sts_error THEN
87: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
88: FND_MESSAGE.SET_TOKEN('TEXT',

Line 86: IF x_return_status = fnd_api.g_ret_sts_error THEN

82: p_COUNTY IS NULL )
83: THEN
84: x_return_status := fnd_api.g_ret_sts_error;
85:
86: IF x_return_status = fnd_api.g_ret_sts_error THEN
87: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
88: FND_MESSAGE.SET_TOKEN('TEXT',
89: 'Please enter either a p_location_id or address elements like address1 ...');
90: FND_MSG_PUB.ADD;

Line 92: p_encoded => fnd_api.g_false,

88: FND_MESSAGE.SET_TOKEN('TEXT',
89: 'Please enter either a p_location_id or address elements like address1 ...');
90: FND_MSG_PUB.ADD;
91: fnd_msg_pub.count_and_get(
92: p_encoded => fnd_api.g_false,
93: p_count => x_msg_count,
94: p_data => x_msg_data);
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;

Line 95: RAISE FND_API.G_EXC_ERROR;

91: fnd_msg_pub.count_and_get(
92: p_encoded => fnd_api.g_false,
93: p_count => x_msg_count,
94: p_data => x_msg_data);
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: ELSE
99: OPEN c_loc_2;

Line 105: x_return_status := fnd_api.g_ret_sts_error;

101: CLOSE c_loc_2;
102:
103: IF l_loc_id_tab.COUNT = 0 THEN
104:
105: x_return_status := fnd_api.g_ret_sts_error;
106:
107: IF x_return_status = fnd_api.g_ret_sts_error THEN
108: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
109: FND_MESSAGE.SET_TOKEN('TEXT',

Line 107: IF x_return_status = fnd_api.g_ret_sts_error THEN

103: IF l_loc_id_tab.COUNT = 0 THEN
104:
105: x_return_status := fnd_api.g_ret_sts_error;
106:
107: IF x_return_status = fnd_api.g_ret_sts_error THEN
108: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
109: FND_MESSAGE.SET_TOKEN('TEXT',
110: 'The combination of address elements you have provided does not correspond to any location in the DB');
111: FND_MSG_PUB.ADD;

Line 113: p_encoded => fnd_api.g_false,

109: FND_MESSAGE.SET_TOKEN('TEXT',
110: 'The combination of address elements you have provided does not correspond to any location in the DB');
111: FND_MSG_PUB.ADD;
112: fnd_msg_pub.count_and_get(
113: p_encoded => fnd_api.g_false,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;

Line 116: RAISE FND_API.G_EXC_ERROR;

112: fnd_msg_pub.count_and_get(
113: p_encoded => fnd_api.g_false,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: ELSIF l_loc_id_tab.COUNT > 1 THEN
120:

Line 121: x_return_status := fnd_api.g_ret_sts_error;

117: END IF;
118:
119: ELSIF l_loc_id_tab.COUNT > 1 THEN
120:
121: x_return_status := fnd_api.g_ret_sts_error;
122:
123: IF x_return_status = fnd_api.g_ret_sts_error THEN
124: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
125: FND_MESSAGE.SET_TOKEN('TEXT',

Line 123: IF x_return_status = fnd_api.g_ret_sts_error THEN

119: ELSIF l_loc_id_tab.COUNT > 1 THEN
120:
121: x_return_status := fnd_api.g_ret_sts_error;
122:
123: IF x_return_status = fnd_api.g_ret_sts_error THEN
124: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_API_ERROR');
125: FND_MESSAGE.SET_TOKEN('TEXT',
126: 'The combination of address elements you have provided correspond to more than one location in the DB');
127: FND_MSG_PUB.ADD;

Line 129: p_encoded => fnd_api.g_false,

125: FND_MESSAGE.SET_TOKEN('TEXT',
126: 'The combination of address elements you have provided correspond to more than one location in the DB');
127: FND_MSG_PUB.ADD;
128: fnd_msg_pub.count_and_get(
129: p_encoded => fnd_api.g_false,
130: p_count => x_msg_count,
131: p_data => x_msg_data);
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;

Line 132: RAISE FND_API.G_EXC_ERROR;

128: fnd_msg_pub.count_and_get(
129: p_encoded => fnd_api.g_false,
130: p_count => x_msg_count,
131: p_data => x_msg_data);
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: ELSE
136: l_loc_id := l_loc_id_tab(1);

Line 157: IF x_return_status <> fnd_api.g_ret_sts_success THEN

153: x_return_status => x_return_status,
154: x_msg_count => x_msg_count,
155: x_msg_data => x_msg_data );
156:
157: IF x_return_status <> fnd_api.g_ret_sts_success THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161:

Line 158: RAISE FND_API.G_EXC_ERROR;

154: x_msg_count => x_msg_count,
155: x_msg_data => x_msg_data );
156:
157: IF x_return_status <> fnd_api.g_ret_sts_success THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161:
162: -- Create account site

Line 177: IF x_return_status <> fnd_api.g_ret_sts_success THEN

173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data );
176:
177: IF x_return_status <> fnd_api.g_ret_sts_success THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: EXCEPTION

Line 178: RAISE FND_API.G_EXC_ERROR;

174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data );
176:
177: IF x_return_status <> fnd_api.g_ret_sts_success THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: EXCEPTION
182:

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: END IF;
180:
181: EXCEPTION
182:
183: WHEN FND_API.G_EXC_ERROR THEN
184: x_return_status := fnd_api.g_ret_sts_error;
185: WHEN OTHERS THEN
186: RAISE;
187:

Line 184: x_return_status := fnd_api.g_ret_sts_error;

180:
181: EXCEPTION
182:
183: WHEN FND_API.G_EXC_ERROR THEN
184: x_return_status := fnd_api.g_ret_sts_error;
185: WHEN OTHERS THEN
186: RAISE;
187:
188: END;