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.IGS_AS_SS_DOC_REQUEST dependencies on FND_MESSAGE

Line 152: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_EXISTS');

148: END IF;
149: CLOSE c_hold;
150: --
151: IF lvcholdexists = 'Y' THEN
152: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_EXISTS');
153: fnd_message.set_token ('HOLD_TYPE', cur_hold.encumbrance_type);
154: fnd_message.set_token ('START_DATE', cur_hold.pee_start_dt);
155: p_hold_message := fnd_message.get;
156: END IF;

Line 153: fnd_message.set_token ('HOLD_TYPE', cur_hold.encumbrance_type);

149: CLOSE c_hold;
150: --
151: IF lvcholdexists = 'Y' THEN
152: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_EXISTS');
153: fnd_message.set_token ('HOLD_TYPE', cur_hold.encumbrance_type);
154: fnd_message.set_token ('START_DATE', cur_hold.pee_start_dt);
155: p_hold_message := fnd_message.get;
156: END IF;
157: --

Line 154: fnd_message.set_token ('START_DATE', cur_hold.pee_start_dt);

150: --
151: IF lvcholdexists = 'Y' THEN
152: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_EXISTS');
153: fnd_message.set_token ('HOLD_TYPE', cur_hold.encumbrance_type);
154: fnd_message.set_token ('START_DATE', cur_hold.pee_start_dt);
155: p_hold_message := fnd_message.get;
156: END IF;
157: --
158: -- Check for Lifetime Fee

Line 155: p_hold_message := fnd_message.get;

151: IF lvcholdexists = 'Y' THEN
152: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_EXISTS');
153: fnd_message.set_token ('HOLD_TYPE', cur_hold.encumbrance_type);
154: fnd_message.set_token ('START_DATE', cur_hold.pee_start_dt);
155: p_hold_message := fnd_message.get;
156: END IF;
157: --
158: -- Check for Lifetime Fee
159: --

Line 177: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENCERT_TILL_HOLD');

173: IF lvcholdexists = 'Y' THEN
174: IF cur_setup.trans_request_if_hold_ind = 'Y'
175: AND cur_setup.hold_deliv_ind = 'N' THEN
176: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
177: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENCERT_TILL_HOLD');
178: p_hint_message := fnd_message.get;
179: p_request_allowed := 'Y';
180: p_transcript_allowed := 'N';
181: p_encert_allowed := 'Y';

Line 178: p_hint_message := fnd_message.get;

174: IF cur_setup.trans_request_if_hold_ind = 'Y'
175: AND cur_setup.hold_deliv_ind = 'N' THEN
176: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
177: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENCERT_TILL_HOLD');
178: p_hint_message := fnd_message.get;
179: p_request_allowed := 'Y';
180: p_transcript_allowed := 'N';
181: p_encert_allowed := 'Y';
182: RETURN;

Line 184: fnd_message.set_name ('IGS', 'IGS_SS_AS_NODOC_TILL_HOLD');

180: p_transcript_allowed := 'N';
181: p_encert_allowed := 'Y';
182: RETURN;
183: ELSE
184: fnd_message.set_name ('IGS', 'IGS_SS_AS_NODOC_TILL_HOLD');
185: p_hint_message := fnd_message.get;
186: p_request_allowed := 'N';
187: p_transcript_allowed := 'N';
188: p_encert_allowed := 'N';

Line 185: p_hint_message := fnd_message.get;

181: p_encert_allowed := 'Y';
182: RETURN;
183: ELSE
184: fnd_message.set_name ('IGS', 'IGS_SS_AS_NODOC_TILL_HOLD');
185: p_hint_message := fnd_message.get;
186: p_request_allowed := 'N';
187: p_transcript_allowed := 'N';
188: p_encert_allowed := 'N';
189: RETURN;

Line 198: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENC_DLV_TILL_HOLD');

194: --
195: ELSIF cur_setup.trans_request_if_hold_ind = 'N'
196: AND cur_setup.hold_deliv_ind = 'Y' THEN
197: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
198: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENC_DLV_TILL_HOLD');
199: p_hint_message := fnd_message.get;
200: p_request_allowed := 'Y';
201: p_transcript_allowed := 'Y';
202: p_encert_allowed := 'Y';

Line 199: p_hint_message := fnd_message.get;

195: ELSIF cur_setup.trans_request_if_hold_ind = 'N'
196: AND cur_setup.hold_deliv_ind = 'Y' THEN
197: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
198: fnd_message.set_name ('IGS', 'IGS_SS_AS_ENC_DLV_TILL_HOLD');
199: p_hint_message := fnd_message.get;
200: p_request_allowed := 'Y';
201: p_transcript_allowed := 'Y';
202: p_encert_allowed := 'Y';
203: RETURN;

Line 205: fnd_message.set_name ('IGS', 'IGS_SS_AS_TRN_DLV_TILL_HOLD');

201: p_transcript_allowed := 'Y';
202: p_encert_allowed := 'Y';
203: RETURN;
204: ELSE
205: fnd_message.set_name ('IGS', 'IGS_SS_AS_TRN_DLV_TILL_HOLD');
206: p_hint_message := fnd_message.get;
207: p_request_allowed := 'Y';
208: p_transcript_allowed := 'Y';
209: p_encert_allowed := 'N';

Line 206: p_hint_message := fnd_message.get;

202: p_encert_allowed := 'Y';
203: RETURN;
204: ELSE
205: fnd_message.set_name ('IGS', 'IGS_SS_AS_TRN_DLV_TILL_HOLD');
206: p_hint_message := fnd_message.get;
207: p_request_allowed := 'Y';
208: p_transcript_allowed := 'Y';
209: p_encert_allowed := 'N';
210: RETURN;

Line 214: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_DEIV');

210: RETURN;
211: END IF;
212: END IF;
213: IF cur_setup.hold_deliv_ind = 'Y' THEN
214: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_DEIV');
215: p_hint_message := fnd_message.get;
216: END IF;
217: END IF;
218: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN

Line 215: p_hint_message := fnd_message.get;

211: END IF;
212: END IF;
213: IF cur_setup.hold_deliv_ind = 'Y' THEN
214: fnd_message.set_name ('IGS', 'IGS_SS_AS_HOLD_DEIV');
215: p_hint_message := fnd_message.get;
216: END IF;
217: END IF;
218: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');

Line 219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');

215: p_hint_message := fnd_message.get;
216: END IF;
217: END IF;
218: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');
220: p_hint_message := fnd_message.get;
221: ELSE
222: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_TRANS');
223: p_hint_message := fnd_message.get;

Line 220: p_hint_message := fnd_message.get;

216: END IF;
217: END IF;
218: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');
220: p_hint_message := fnd_message.get;
221: ELSE
222: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_TRANS');
223: p_hint_message := fnd_message.get;
224: p_transcript_allowed := 'Y';

Line 222: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_TRANS');

218: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');
220: p_hint_message := fnd_message.get;
221: ELSE
222: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_TRANS');
223: p_hint_message := fnd_message.get;
224: p_transcript_allowed := 'Y';
225: p_encert_allowed := 'N';
226: END IF;

Line 223: p_hint_message := fnd_message.get;

219: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_BOTH_DOCS');
220: p_hint_message := fnd_message.get;
221: ELSE
222: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_TRANS');
223: p_hint_message := fnd_message.get;
224: p_transcript_allowed := 'Y';
225: p_encert_allowed := 'N';
226: END IF;
227: ELSE

Line 229: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_ENCERT');

225: p_encert_allowed := 'N';
226: END IF;
227: ELSE
228: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
229: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_ENCERT');
230: p_hint_message := fnd_message.get;
231: p_transcript_allowed := 'N';
232: p_encert_allowed := 'Y';
233: ELSE

Line 230: p_hint_message := fnd_message.get;

226: END IF;
227: ELSE
228: IF cur_setup.allow_enroll_cert_ind = 'Y' THEN
229: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_ONLY_ENCERT');
230: p_hint_message := fnd_message.get;
231: p_transcript_allowed := 'N';
232: p_encert_allowed := 'Y';
233: ELSE
234: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_NO_DOC');

Line 234: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_NO_DOC');

230: p_hint_message := fnd_message.get;
231: p_transcript_allowed := 'N';
232: p_encert_allowed := 'Y';
233: ELSE
234: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_NO_DOC');
235: p_hint_message := fnd_message.get;
236: --
237: -- Neither of Transcript and Enrollment Certification are allowed.
238: -- Hence do not allow request.

Line 235: p_hint_message := fnd_message.get;

231: p_transcript_allowed := 'N';
232: p_encert_allowed := 'Y';
233: ELSE
234: fnd_message.set_name ('IGS', 'IGS_SS_AS_ORDER_NO_DOC');
235: p_hint_message := fnd_message.get;
236: --
237: -- Neither of Transcript and Enrollment Certification are allowed.
238: -- Hence do not allow request.
239: --

Line 300: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');

296: || fnd_global.newline ();
297: END IF;
298: END LOOP;
299: IF RTRIM (LTRIM (lvdocdetails)) IS NULL THEN
300: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');
301: ELSE
302: RETURN lvdocdetails;
303: END IF;
304: END get_item_details_for_order;

Line 374: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');

370: || fnd_global.newline ();
371: END IF;
372: END LOOP;
373: IF RTRIM (LTRIM (lvdocdetails)) IS NULL THEN
374: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');
375: ELSE
376: RETURN lvdocdetails;
377: END IF;
378: END get_order_details_include_addr;

Line 767: fnd_message.set_name ('IGS', 'IGS_SS_AS_NO_SUCH_ORD');

763: FETCH c_ord INTO v_ord_rec;
764: IF c_ord%NOTFOUND THEN
765: CLOSE c_ord;
766: p_return_status := fnd_api.g_ret_sts_error;
767: fnd_message.set_name ('IGS', 'IGS_SS_AS_NO_SUCH_ORD');
768: fnd_msg_pub.ADD;
769: RAISE fnd_api.g_exc_error;
770: END IF;
771: CLOSE c_ord;

Line 779: fnd_message.set_name ('IGS', 'IGS_FI_SRC_TXN_ACC_INV');

775: FETCH c_igs_fi_invln INTO rec_c_igs_fi_invln;
776: IF c_igs_fi_invln%FOUND THEN
777: CLOSE c_igs_fi_invln;
778: p_return_status := fnd_api.g_ret_sts_error;
779: fnd_message.set_name ('IGS', 'IGS_FI_SRC_TXN_ACC_INV');
780: fnd_msg_pub.ADD;
781: RAISE fnd_api.g_exc_error;
782: END IF;
783: CLOSE c_igs_fi_invln;

Line 794: fnd_message.set_name ('IGS', 'IGS_SS_AS_FI_CAL_NOT_SET');

790: FETCH c_ftci INTO v_ftci_rec;
791: IF c_ftci%NOTFOUND THEN
792: CLOSE c_ftci;
793: p_return_status := fnd_api.g_ret_sts_error;
794: fnd_message.set_name ('IGS', 'IGS_SS_AS_FI_CAL_NOT_SET');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798: CLOSE c_ftci;

Line 806: fnd_message.set_name ('IGS', l_v_message_name);

802: p_v_curr_desc => l_v_curr_desc,
803: p_v_message_name => l_v_message_name
804: );
805: IF l_v_message_name IS NOT NULL THEN
806: fnd_message.set_name ('IGS', l_v_message_name);
807: fnd_msg_pub.ADD;
808: RAISE fnd_api.g_exc_error;
809: END IF;
810: igs_fi_ss_charges_api_pvt.create_charge (

Line 915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

911: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
912: RETURN;
913: WHEN OTHERS THEN
914: p_return_status := fnd_api.g_ret_sts_unexp_error;
915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
916: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
917: fnd_msg_pub.ADD;
918: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
919: RETURN;

Line 916: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);

912: RETURN;
913: WHEN OTHERS THEN
914: p_return_status := fnd_api.g_ret_sts_unexp_error;
915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
916: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
917: fnd_msg_pub.ADD;
918: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
919: RETURN;
920: END create_invoice;

Line 1236: l_return_string := l_return_string || ' ' || RTRIM (LTRIM (fnd_message.get_string ('IGS', 'IGS_GE_GRAD_DATE'))) || ' ' || c_conferral_dt_rec.conferral_date;

1232: EXIT;
1233: END LOOP;
1234: --
1235: FOR c_conferral_dt_rec IN c_conferral_dt (p_person_id, p_course_cd) LOOP
1236: l_return_string := l_return_string || ' ' || RTRIM (LTRIM (fnd_message.get_string ('IGS', 'IGS_GE_GRAD_DATE'))) || ' ' || c_conferral_dt_rec.conferral_date;
1237: EXIT;
1238: END LOOP;
1239: --
1240: FOR c_sua_end_rec IN c_sua_end LOOP

Line 1241: l_return_string := l_return_string || ' ' || RTRIM (LTRIM (fnd_message.get_string ('IGS', 'IGS_GE_UNTIL'))) || ' ' || c_sua_end_rec.load_description;

1237: EXIT;
1238: END LOOP;
1239: --
1240: FOR c_sua_end_rec IN c_sua_end LOOP
1241: l_return_string := l_return_string || ' ' || RTRIM (LTRIM (fnd_message.get_string ('IGS', 'IGS_GE_UNTIL'))) || ' ' || c_sua_end_rec.load_description;
1242: EXIT;
1243: END LOOP;
1244: --
1245: RETURN l_return_string;

Line 1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1723: p_return_status := fnd_api.g_ret_sts_unexp_error;
1724: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1725: WHEN OTHERS THEN
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);
1729: fnd_msg_pub.ADD;
1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1731: END pay_lifetime_fees;

Line 1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);

1724: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1725: WHEN OTHERS THEN
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);
1729: fnd_msg_pub.ADD;
1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1731: END pay_lifetime_fees;
1732:

Line 2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1997: p_return_status := fnd_api.g_ret_sts_unexp_error;
1998: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1999: WHEN OTHERS THEN
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
2003: fnd_msg_pub.ADD;
2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2005: END recalc_after_lft_paid;

Line 2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);

1998: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1999: WHEN OTHERS THEN
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
2003: fnd_msg_pub.ADD;
2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2005: END recalc_after_lft_paid;
2006:

Line 2550: fnd_message.set_name ('IGS', 'IGS_FI_FEE_ENCUMB_FEECAT_CAL');

2546: FETCH c_ftci INTO v_ftci_rec;
2547: IF c_ftci%NOTFOUND THEN
2548: CLOSE c_ftci;
2549: p_return_status := fnd_api.g_ret_sts_error;
2550: fnd_message.set_name ('IGS', 'IGS_FI_FEE_ENCUMB_FEECAT_CAL');
2551: fnd_msg_pub.ADD;
2552: RAISE fnd_api.g_exc_error;
2553: END IF;
2554: CLOSE c_ftci;

Line 2562: fnd_message.set_name ('IGS', l_v_message_name);

2558: p_v_curr_desc => l_v_curr_desc,
2559: p_v_message_name => l_v_message_name
2560: );
2561: IF l_v_message_name IS NOT NULL THEN
2562: fnd_message.set_name ('IGS', l_v_message_name);
2563: fnd_msg_pub.ADD;
2564: RAISE fnd_api.g_exc_error;
2565: END IF;
2566: igs_fi_ss_charges_api_pvt.create_charge (

Line 2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

2606: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2607: RETURN;
2608: WHEN OTHERS THEN
2609: p_return_status := fnd_api.g_ret_sts_unexp_error;
2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2611: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
2612: fnd_msg_pub.ADD;
2613: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2614: RETURN;

Line 2611: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);

2607: RETURN;
2608: WHEN OTHERS THEN
2609: p_return_status := fnd_api.g_ret_sts_unexp_error;
2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2611: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
2612: fnd_msg_pub.ADD;
2613: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2614: RETURN;
2615: END create_trns_plan_invoice_id;

Line 2644: fnd_message.set_name ('IGS', 'IGS_SS_AS_CNT_DEL_BLK_ITM');

2640: OPEN c_chk_del_allwed;
2641: FETCH c_chk_del_allwed INTO l_count;
2642: CLOSE c_chk_del_allwed;
2643: IF l_count > 0 THEN
2644: fnd_message.set_name ('IGS', 'IGS_SS_AS_CNT_DEL_BLK_ITM');
2645: fnd_msg_pub.ADD;
2646: RAISE fnd_api.g_exc_error;
2647: END IF;
2648: -- Delete all the items in this order

Line 2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

2674: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2675: RETURN;
2676: WHEN OTHERS THEN
2677: p_return_status := fnd_api.g_ret_sts_unexp_error;
2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2679: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2680: fnd_msg_pub.ADD;
2681: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2682: RETURN;

Line 2679: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);

2675: RETURN;
2676: WHEN OTHERS THEN
2677: p_return_status := fnd_api.g_ret_sts_unexp_error;
2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2679: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2680: fnd_msg_pub.ADD;
2681: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2682: RETURN;
2683: END delete_bulk_item;

Line 2725: p_effbuff := fnd_message.get;

2721: );
2722: IF p_action_type = 'PRODUCE_DOCS'
2723: AND p_effbuff = 0 THEN
2724: p_status := fnd_api.g_ret_sts_error;
2725: p_effbuff := fnd_message.get;
2726: ELSIF p_status = 1 THEN
2727: p_status := fnd_api.g_ret_sts_error;
2728: ELSE
2729: p_status := fnd_api.g_ret_sts_success;

Line 2797: p_errbuf := fnd_message.get;

2793: argument10 => p_item_numbers
2794: );
2795: p_retcode := TO_CHAR (l_req_id);
2796: IF l_req_id = 0 THEN
2797: p_errbuf := fnd_message.get;
2798: END IF;
2799: COMMIT; --Since the job will not be saved till commit is done
2800: END submit_print_request;
2801:

Line 2878: p_effbuff := fnd_message.get;

2874: argument10 => p_item_numbers --Concatr string of item number
2875: );
2876: IF l_req_id = 0 THEN
2877: p_ret_status := fnd_api.g_ret_sts_error;
2878: p_effbuff := fnd_message.get;
2879: ELSIF l_req_id IS NULL THEN
2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2881: p_effbuff := fnd_message.get;
2882: ELSE

Line 2881: p_effbuff := fnd_message.get;

2877: p_ret_status := fnd_api.g_ret_sts_error;
2878: p_effbuff := fnd_message.get;
2879: ELSIF l_req_id IS NULL THEN
2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2881: p_effbuff := fnd_message.get;
2882: ELSE
2883: p_ret_status := fnd_api.g_ret_sts_success;
2884: p_req_ids := l_req_id;
2885: END IF;

Line 2916: p_effbuff := fnd_message.get;

2912: argument7 => ''
2913: );
2914: IF l_req_id = 0 THEN
2915: p_ret_status := fnd_api.g_ret_sts_error;
2916: p_effbuff := fnd_message.get;
2917: ELSIF l_req_id IS NULL THEN
2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2919: p_effbuff := fnd_message.get;
2920: ELSE

Line 2919: p_effbuff := fnd_message.get;

2915: p_ret_status := fnd_api.g_ret_sts_error;
2916: p_effbuff := fnd_message.get;
2917: ELSIF l_req_id IS NULL THEN
2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2919: p_effbuff := fnd_message.get;
2920: ELSE
2921: p_ret_status := fnd_api.g_ret_sts_success;
2922: IF p_req_ids IS NULL THEN
2923: p_req_ids := l_req_id;

Line 3055: fnd_message.set_name ('IGS', l_msg_data);

3051: x_order_description => p_order_desc,
3052: x_order_placed_by => p_admin_person_id
3053: );
3054: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3055: fnd_message.set_name ('IGS', l_msg_data);
3056: fnd_msg_pub.ADD;
3057: --Log the error and exit since if order is not created, no item can be created
3058: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3059: fnd_file.put_line (fnd_file.LOG, l_msg_data);

Line 3292: fnd_message.set_name ('IGS', 'IGS_JOB_FAILED');

3288: argument9 => l_order_number, --Order Number
3289: argument10 => NULL -- Concatr string of item number
3290: );
3291: IF NVL (l_req_id, 0) = 0 THEN
3292: fnd_message.set_name ('IGS', 'IGS_JOB_FAILED');
3293: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3294: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
3295: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3296: END IF;

Line 3294: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

3290: );
3291: IF NVL (l_req_id, 0) = 0 THEN
3292: fnd_message.set_name ('IGS', 'IGS_JOB_FAILED');
3293: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3294: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
3295: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3296: END IF;
3297: END IF;
3298: -- End of the main loop which loops through the persons for whom the order is to be created ---------

Line 3324: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

3320: RETURN;
3321: WHEN OTHERS THEN
3322: ROLLBACK;
3323: l_return_status := fnd_api.g_ret_sts_unexp_error;
3324: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3325: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3326: fnd_msg_pub.ADD;
3327: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3328: errbuf := l_msg_data;

Line 3325: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);

3321: WHEN OTHERS THEN
3322: ROLLBACK;
3323: l_return_status := fnd_api.g_ret_sts_unexp_error;
3324: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3325: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3326: fnd_msg_pub.ADD;
3327: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3328: errbuf := l_msg_data;
3329: retcode := 2; --l_RETURN_STATUS;