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.FLM_MULTIPLE_SUPPLIERS dependencies on FND_API

Line 31: x_retcode := fnd_api.g_ret_sts_success;

27: l_returnStatus VARCHAR2(1);
28:
29: BEGIN
30:
31: x_retcode := fnd_api.g_ret_sts_success;
32:
33: BEGIN
34: SELECT Sum(sourcing_percentage), Count(mpss.supplier_id)
35: INTO l_total_perc, l_sup_flag

Line 64: x_retcode := fnd_api.g_ret_sts_error;

60:
61: EXCEPTION
62:
63: WHEN SUPPLIER_PERC_MISMATCH THEN
64: x_retcode := fnd_api.g_ret_sts_error;
65: fnd_message.set_name('FLM','FLM_SUP_PERC_MISMATCH_ERR');
66: x_err_msg := fnd_message.get;
67: log('Suppliers percentages dont sum to 100%', 'flm_multiple_suppliers.validate_supplier_percentages' , l_returnStatus);
68:

Line 70: x_retcode := fnd_api.g_ret_sts_error;

66: x_err_msg := fnd_message.get;
67: log('Suppliers percentages dont sum to 100%', 'flm_multiple_suppliers.validate_supplier_percentages' , l_returnStatus);
68:
69: WHEN OTHERS THEN
70: x_retcode := fnd_api.g_ret_sts_error;
71: x_err_msg := SQLCODE || substr(SQLERRM, 1, 200);
72: log('exception occurred ' || x_err_msg, 'flm_multiple_suppliers.validate_supplier_percentages' , l_returnStatus);
73:
74: END validate_supplier_percentages;

Line 135: x_retcode := fnd_api.g_ret_sts_success;

131: l_max_deficiency NUMBER;
132: l_max_act_sup_cards NUMBER;
133:
134: BEGIN
135: x_retcode := fnd_api.g_ret_sts_success;
136:
137: validate_supplier_percentages(p_pull_seq_id => p_pull_seq_id,
138: x_supplier => l_supplier,
139: x_retcode => x_retcode,

Line 141: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN

137: validate_supplier_percentages(p_pull_seq_id => p_pull_seq_id,
138: x_supplier => l_supplier,
139: x_retcode => x_retcode,
140: x_err_msg => x_err_msg);
141: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
142: raise fnd_api.g_exc_unexpected_error;
143: END IF;
144: log('After validating supplier', 'flm_multiple_suppliers.get_supplier' , l_returnStatus);
145:

Line 142: raise fnd_api.g_exc_unexpected_error;

138: x_supplier => l_supplier,
139: x_retcode => x_retcode,
140: x_err_msg => x_err_msg);
141: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
142: raise fnd_api.g_exc_unexpected_error;
143: END IF;
144: log('After validating supplier', 'flm_multiple_suppliers.get_supplier' , l_returnStatus);
145:
146: --get the supplier_id and site_id from custom hook

Line 152: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN

148: x_supplier_id => x_supplier_id,
149: x_suppier_site_id => x_supplier_site_id,
150: x_retcode => x_retcode,
151: x_err_msg => x_err_msg);
152: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
153: raise fnd_api.g_exc_unexpected_error;
154: END IF;
155: log('Custom hook returned supplier: ' || x_supplier_id || ' supplier site: ' || x_supplier_site_id,
156: 'flm_multiple_suppliers.get_supplier' , l_returnStatus);

Line 153: raise fnd_api.g_exc_unexpected_error;

149: x_suppier_site_id => x_supplier_site_id,
150: x_retcode => x_retcode,
151: x_err_msg => x_err_msg);
152: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
153: raise fnd_api.g_exc_unexpected_error;
154: END IF;
155: log('Custom hook returned supplier: ' || x_supplier_id || ' supplier site: ' || x_supplier_site_id,
156: 'flm_multiple_suppliers.get_supplier' , l_returnStatus);
157:

Line 252: x_retcode := fnd_api.g_ret_sts_error;

248: RETURN;
249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: x_retcode := fnd_api.g_ret_sts_error;
253: x_err_msg := SQLCODE || substr(SQLERRM, 1, 200);
254: log('Exception: ' || x_err_msg, 'flm_multiple_suppliers.get_supplier' , l_returnStatus);
255: END GET_SUPPLIER;
256:

Line 278: x_retcode := fnd_api.g_ret_sts_success;

274: l_future_cards NUMBER;
275: l_fut_sup_cards NUMBER;
276:
277: BEGIN
278: x_retcode := fnd_api.g_ret_sts_success;
279: validate_supplier_percentages(p_pull_seq_id => p_pull_seq_id,
280: x_supplier => l_supplier,
281: x_retcode => x_retcode,
282: x_err_msg => x_err_msg);

Line 283: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN

279: validate_supplier_percentages(p_pull_seq_id => p_pull_seq_id,
280: x_supplier => l_supplier,
281: x_retcode => x_retcode,
282: x_err_msg => x_err_msg);
283: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
284: raise fnd_api.g_exc_unexpected_error;
285: END IF;
286: IF (l_supplier = NO_SUPPLIER) THEN
287: RETURN;

Line 284: raise fnd_api.g_exc_unexpected_error;

280: x_supplier => l_supplier,
281: x_retcode => x_retcode,
282: x_err_msg => x_err_msg);
283: IF(x_retcode <> fnd_api.g_ret_sts_success) THEN
284: raise fnd_api.g_exc_unexpected_error;
285: END IF;
286: IF (l_supplier = NO_SUPPLIER) THEN
287: RETURN;
288: END IF;

Line 347: WHEN fnd_api.g_exc_unexpected_error THEN

343: CLOSE supplier_cur;
344: END IF;
345:
346: EXCEPTION
347: WHEN fnd_api.g_exc_unexpected_error THEN
348: RETURN;
349: WHEN OTHERS THEN
350: x_retcode := fnd_api.g_ret_sts_error;
351: x_err_msg := SQLCODE || substr(SQLERRM, 1, 200);

Line 350: x_retcode := fnd_api.g_ret_sts_error;

346: EXCEPTION
347: WHEN fnd_api.g_exc_unexpected_error THEN
348: RETURN;
349: WHEN OTHERS THEN
350: x_retcode := fnd_api.g_ret_sts_error;
351: x_err_msg := SQLCODE || substr(SQLERRM, 1, 200);
352:
353: END multiple_supplier_kanban_cards;
354: