eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SALESREPS_PUB dependencies on FND_API

Line 23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

19: based on input values passed by calling routines. */
20:
21: PROCEDURE create_salesrep
22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,

Line 24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

20:
21: PROCEDURE create_salesrep
22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,

Line 31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

Line 72: x_return_status := fnd_api.g_ret_sts_success;

68: BEGIN
69:
70: SAVEPOINT create_salesreps_pub;
71:
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;

Line 74: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

70: SAVEPOINT create_salesreps_pub;
71:
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 75: RAISE fnd_api.g_exc_unexpected_error;

71:
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78: IF fnd_api.to_boolean(p_init_msg_list) THEN
79: fnd_msg_pub.initialize;

Line 78: IF fnd_api.to_boolean(p_init_msg_list) THEN

74: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78: IF fnd_api.to_boolean(p_init_msg_list) THEN
79: fnd_msg_pub.initialize;
80: END IF;
81:
82:

Line 94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

90: -- added for NOCOPY
91: l_resource_id := l_resource_id_out;
92:
93:
94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

91: l_resource_id := l_resource_id_out;
92:
93:
94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;

Line 96: RAISE FND_API.G_EXC_ERROR;

92:
93:
94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: END IF;

Line 97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

93:
94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: END IF;
101:

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
95: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: END IF;
101:
102:

Line 110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

106: p_sales_credit_type_id => l_sales_credit_type_id,
107: x_return_status => x_return_status
108: );
109:
110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

107: x_return_status => x_return_status
108: );
109:
110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;

Line 112: RAISE FND_API.G_EXC_ERROR;

108: );
109:
110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: END IF;

Line 113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

109:
110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: END IF;
117:

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: END IF;
117:
118: /* Validate start date */

Line 121: x_return_status := fnd_api.g_ret_sts_unexp_error;

117:
118: /* Validate start date */
119: /*
120: IF l_start_date_active IS NULL THEN
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: */
125:

Line 122: RAISE fnd_api.g_exc_unexpected_error;

118: /* Validate start date */
119: /*
120: IF l_start_date_active IS NULL THEN
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: */
125:
126: /*

Line 139: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

135: P_SRP_END_DATE => l_end_date_active,
136: P_CR_UPD_MODE => 'C',
137: X_RETURN_STATUS => x_return_status);
138:
139: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143: /* Check the Global Variable for SalesrepID, and call the appropriate Private API */

Line 140: RAISE FND_API.G_EXC_ERROR;

136: P_CR_UPD_MODE => 'C',
137: X_RETURN_STATUS => x_return_status);
138:
139: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143: /* Check the Global Variable for SalesrepID, and call the appropriate Private API */
144:

Line 156: P_INIT_MSG_LIST => fnd_api.g_false,

152: /* Calling Private API to insert salesrep */
153:
154: jtf_rs_salesreps_pvt.create_salesrep(
155: P_API_VERSION => 1,
156: P_INIT_MSG_LIST => fnd_api.g_false,
157: P_COMMIT => fnd_api.g_false,
158: P_RESOURCE_ID => l_resource_id,
159: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
160: P_NAME => l_name,

Line 157: P_COMMIT => fnd_api.g_false,

153:
154: jtf_rs_salesreps_pvt.create_salesrep(
155: P_API_VERSION => 1,
156: P_INIT_MSG_LIST => fnd_api.g_false,
157: P_COMMIT => fnd_api.g_false,
158: P_RESOURCE_ID => l_resource_id,
159: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
160: P_NAME => l_name,
161: P_STATUS => l_status,

Line 179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

175: X_MSG_COUNT => x_msg_count,
176: X_MSG_DATA => x_msg_data,
177: X_SALESREP_ID => x_salesrep_id
178: );
179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
181: RAISE FND_API.G_EXC_ERROR;
182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

176: X_MSG_DATA => x_msg_data,
177: X_SALESREP_ID => x_salesrep_id
178: );
179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
181: RAISE FND_API.G_EXC_ERROR;
182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;

Line 181: RAISE FND_API.G_EXC_ERROR;

177: X_SALESREP_ID => x_salesrep_id
178: );
179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
181: RAISE FND_API.G_EXC_ERROR;
182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185: END IF;

Line 182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

178: );
179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
181: RAISE FND_API.G_EXC_ERROR;
182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185: END IF;
186:

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
180: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
181: RAISE FND_API.G_EXC_ERROR;
182: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185: END IF;
186:
187: ELSE

Line 192: P_INIT_MSG_LIST => fnd_api.g_false,

188:
189: /* Call the private procedure for Migration. */
190: jtf_rs_salesreps_pvt.create_salesrep_migrate(
191: P_API_VERSION => 1,
192: P_INIT_MSG_LIST => fnd_api.g_false,
193: P_COMMIT => fnd_api.g_false,
194: P_RESOURCE_ID => l_resource_id,
195: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
196: P_NAME => l_name,

Line 193: P_COMMIT => fnd_api.g_false,

189: /* Call the private procedure for Migration. */
190: jtf_rs_salesreps_pvt.create_salesrep_migrate(
191: P_API_VERSION => 1,
192: P_INIT_MSG_LIST => fnd_api.g_false,
193: P_COMMIT => fnd_api.g_false,
194: P_RESOURCE_ID => l_resource_id,
195: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
196: P_NAME => l_name,
197: P_STATUS => l_status,

Line 232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

228: X_MSG_COUNT => x_msg_count,
229: X_MSG_DATA => x_msg_data,
230: X_SALESREP_ID => x_salesrep_id
231: );
232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

229: X_MSG_DATA => x_msg_data,
230: X_SALESREP_ID => x_salesrep_id
231: );
232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;

Line 234: RAISE FND_API.G_EXC_ERROR;

230: X_SALESREP_ID => x_salesrep_id
231: );
232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:

Line 235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

231: );
232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: END IF;

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
233: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: END IF;
240:

Line 243: IF fnd_api.to_Boolean(p_commit) THEN

239: END IF;
240:
241: END IF;
242:
243: IF fnd_api.to_Boolean(p_commit) THEN
244: COMMIT WORK;
245: END IF;
246:
247: /* Standard call to get message count and if count is 1, get message info. */

Line 255: WHEN fnd_api.g_exc_error THEN

251: );
252:
253: EXCEPTION
254:
255: WHEN fnd_api.g_exc_error THEN
256: ROLLBACK TO create_salesreps_pub;
257: x_return_status := fnd_api.g_ret_sts_error;
258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
259: p_data => x_msg_data);

Line 257: x_return_status := fnd_api.g_ret_sts_error;

253: EXCEPTION
254:
255: WHEN fnd_api.g_exc_error THEN
256: ROLLBACK TO create_salesreps_pub;
257: x_return_status := fnd_api.g_ret_sts_error;
258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN fnd_api.g_exc_unexpected_error THEN
261: ROLLBACK TO create_salesreps_pub;

Line 260: WHEN fnd_api.g_exc_unexpected_error THEN

256: ROLLBACK TO create_salesreps_pub;
257: x_return_status := fnd_api.g_ret_sts_error;
258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN fnd_api.g_exc_unexpected_error THEN
261: ROLLBACK TO create_salesreps_pub;
262: x_return_status := fnd_api.g_ret_sts_unexp_error;
263: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
264: p_data => x_msg_data);

Line 262: x_return_status := fnd_api.g_ret_sts_unexp_error;

258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN fnd_api.g_exc_unexpected_error THEN
261: ROLLBACK TO create_salesreps_pub;
262: x_return_status := fnd_api.g_ret_sts_unexp_error;
263: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
264: p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO create_salesreps_pub;

Line 272: x_return_status := fnd_api.g_ret_sts_unexp_error;

268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
274: p_data => x_msg_data);
275:
276: END create_salesrep;

Line 281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

277:
278:
279: PROCEDURE create_salesrep_migrate
280: (P_API_VERSION IN NUMBER,
281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,

Line 282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

278:
279: PROCEDURE create_salesrep_migrate
280: (P_API_VERSION IN NUMBER,
281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,

Line 380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

376: based on input values passed by calling routines. */
377:
378: PROCEDURE update_salesrep
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

377:
378: PROCEDURE update_salesrep
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,

381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,

384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,

385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,

386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,

388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

Line 394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,

Line 395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,

392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
400: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 429: x_return_status := fnd_api.g_ret_sts_success;

425: BEGIN
426:
427: SAVEPOINT update_salesreps_pub;
428:
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;

Line 431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

427: SAVEPOINT update_salesreps_pub;
428:
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 432: RAISE fnd_api.g_exc_unexpected_error;

428:
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;

Line 435: IF fnd_api.to_boolean(p_init_msg_list) THEN

431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;
437: END IF;
438:
439:

Line 448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

444: p_org_id => l_org_id,
445: x_return_status => x_return_status
446: );
447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

445: x_return_status => x_return_status
446: );
447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: );
447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END IF;

Line 451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END IF;
455:

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END IF;
455:
456: /* Validate Sales Credit type Id */

Line 463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

459: p_sales_credit_type_id => l_sales_credit_type_id,
460: x_return_status => x_return_status
461: );
462:
463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

460: x_return_status => x_return_status
461: );
462:
463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: );
462:
463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: END IF;

Line 466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

462:
463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: END IF;
470:

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
464: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: END IF;
470:
471: /* Validate start date */

Line 474: x_return_status := fnd_api.g_ret_sts_unexp_error;

470:
471: /* Validate start date */
472: /*
473: IF l_start_date_active IS NULL THEN
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477: */
478:

Line 475: RAISE fnd_api.g_exc_unexpected_error;

471: /* Validate start date */
472: /*
473: IF l_start_date_active IS NULL THEN
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477: */
478:
479: /*

Line 492: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

488: P_SRP_END_DATE => l_end_date_active,
489: P_CR_UPD_MODE => 'U',
490: X_RETURN_STATUS => x_return_status);
491:
492: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: /* Calling Private API to insert salesrep */

Line 493: RAISE FND_API.G_EXC_ERROR;

489: P_CR_UPD_MODE => 'U',
490: X_RETURN_STATUS => x_return_status);
491:
492: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: /* Calling Private API to insert salesrep */
497: jtf_rs_salesreps_pvt.update_salesrep(

Line 499: P_INIT_MSG_LIST => fnd_api.g_false,

495:
496: /* Calling Private API to insert salesrep */
497: jtf_rs_salesreps_pvt.update_salesrep(
498: P_API_VERSION => 1,
499: P_INIT_MSG_LIST => fnd_api.g_false,
500: P_COMMIT => fnd_api.g_false,
501: P_SALESREP_ID => l_salesrep_id,
502: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
503: P_NAME => l_name,

Line 500: P_COMMIT => fnd_api.g_false,

496: /* Calling Private API to insert salesrep */
497: jtf_rs_salesreps_pvt.update_salesrep(
498: P_API_VERSION => 1,
499: P_INIT_MSG_LIST => fnd_api.g_false,
500: P_COMMIT => fnd_api.g_false,
501: P_SALESREP_ID => l_salesrep_id,
502: P_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
503: P_NAME => l_name,
504: P_STATUS => l_status,

Line 523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

519: X_MSG_COUNT => x_msg_count,
520: X_MSG_DATA => x_msg_data
521: );
522:
523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

520: X_MSG_DATA => x_msg_data
521: );
522:
523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;

Line 525: RAISE FND_API.G_EXC_ERROR;

521: );
522:
523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: END IF;

Line 526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

522:
523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: END IF;
530:

Line 527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

523: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
524: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: END IF;
530:
531: IF fnd_api.to_Boolean(p_commit) THEN

Line 531: IF fnd_api.to_Boolean(p_commit) THEN

527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: END IF;
530:
531: IF fnd_api.to_Boolean(p_commit) THEN
532: COMMIT WORK;
533: END IF;
534:
535: /* Standard call to get message count and if count is 1, get message info. */

Line 543: WHEN fnd_api.g_exc_error THEN

539: );
540:
541: EXCEPTION
542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO update_salesreps_pub;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);

Line 545: x_return_status := fnd_api.g_ret_sts_error;

541: EXCEPTION
542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO update_salesreps_pub;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO update_salesreps_pub;

Line 548: WHEN fnd_api.g_exc_unexpected_error THEN

544: ROLLBACK TO update_salesreps_pub;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO update_salesreps_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);

Line 550: x_return_status := fnd_api.g_ret_sts_unexp_error;

546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO update_salesreps_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO update_salesreps_pub;

Line 560: x_return_status := fnd_api.g_ret_sts_unexp_error;

556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563:
564: END update_salesrep;