APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on FND_MSG_PUB

Line 354: FND_MSG_PUB.initialize;

350: BEGIN
351:
352: print_debuginfo(l_module_name, 'ENTER');
353:
354: FND_MSG_PUB.initialize;
355:
356: /*
357: * STATUS CHANGE:
358: *

Line 488: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

484: );
485:
486: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
487: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
488: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
489:
490: /*
491: * Propogate exception to caller.
492: */

Line 513: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

509: );
510:
511: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
512: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
513: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: print_debuginfo(l_module_name, 'EXIT');
517:

Line 578: FND_MSG_PUB.initialize;

574: BEGIN
575:
576: print_debuginfo(l_module_name, 'ENTER');
577:
578: FND_MSG_PUB.initialize;
579:
580: IF (p_doc_list.COUNT = 0 OR p_doc_status_list.COUNT = 0) THEN
581:
582: print_debuginfo(l_module_name, 'Error: List of document '

Line 750: FND_MSG_PUB.initialize;

746: BEGIN
747:
748: print_debuginfo(l_module_name, 'ENTER');
749:
750: FND_MSG_PUB.initialize;
751:
752: /*
753: * STATUS CHANGE:
754: *

Line 900: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

896: );
897:
898: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
899: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
900: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
901:
902: /*
903: * Propogate exception to caller.
904: */

Line 926: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

922: );
923:
924: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
925: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
926: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
927:
928: x_return_status := FND_API.G_RET_STS_ERROR;
929:
930: print_debuginfo(l_module_name, 'EXIT');

Line 996: FND_MSG_PUB.initialize;

992: BEGIN
993:
994: print_debuginfo(l_module_name, 'ENTER');
995:
996: FND_MSG_PUB.initialize;
997:
998: IF (p_pmt_list.COUNT = 0 OR p_pmt_status_list.COUNT = 0) THEN
999:
1000: print_debuginfo(l_module_name, 'Error: List of payment '

Line 1152: FND_MSG_PUB.initialize;

1148: BEGIN
1149:
1150: print_debuginfo(l_module_name, 'ENTER');
1151:
1152: FND_MSG_PUB.initialize;
1153:
1154: /*
1155: * Pick up all documents for this payment request.
1156: */

Line 1325: FND_MSG_PUB.initialize;

1321: BEGIN
1322:
1323: print_debuginfo(l_module_name, 'ENTER');
1324:
1325: FND_MSG_PUB.initialize;
1326:
1327: /*
1328: * STATUS CHANGE:
1329: *

Line 1552: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1548: );
1549:
1550: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
1551: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
1552: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1553:
1554: /*
1555: * Propogate exception to caller.
1556: */

Line 1577: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1573: );
1574:
1575: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
1576: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
1577: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1578:
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580:
1581: print_debuginfo(l_module_name, 'EXIT');

Line 1647: FND_MSG_PUB.initialize;

1643: BEGIN
1644:
1645: print_debuginfo(l_module_name, 'ENTER');
1646:
1647: FND_MSG_PUB.initialize;
1648:
1649: IF (p_pmt_list.COUNT = 0 OR p_pmt_status_list.COUNT = 0) THEN
1650:
1651: print_debuginfo(l_module_name, 'Error: List of payment '

Line 1829: FND_MSG_PUB.initialize;

1825: END IF;
1826:
1827: /* Initialize message list if p_init_msg_list is set to TRUE */
1828: IF FND_API.to_boolean(p_init_msg_list) THEN
1829: FND_MSG_PUB.initialize;
1830: END IF;
1831:
1832: /* Initialize return status */
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2011: FND_MSG_PUB.Count_And_Get(

2007: /*
2008: * Standard call to get message count and if count is 1, get
2009: * message info.
2010: */
2011: FND_MSG_PUB.Count_And_Get(
2012: p_encoded => FND_API.G_FALSE,
2013: p_count => x_msg_count,
2014: p_data => x_msg_data
2015: );

Line 2033: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2029: );
2030:
2031: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
2032: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
2033: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2034:
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036:
2037: FND_MSG_PUB.Count_And_Get(

Line 2037: FND_MSG_PUB.Count_And_Get(

2033: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2034:
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036:
2037: FND_MSG_PUB.Count_And_Get(
2038: p_encoded => FND_API.G_FALSE,
2039: p_count => x_msg_count,
2040: p_data => x_msg_data
2041: );

Line 2243: FND_MSG_PUB.initialize;

2239: END IF;
2240:
2241: /* Initialize message list if p_init_msg_list is set to TRUE */
2242: IF FND_API.to_boolean(p_init_msg_list) THEN
2243: FND_MSG_PUB.initialize;
2244: END IF;
2245:
2246: /* Initialize return status */
2247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2323: FND_MSG_PUB.Count_And_Get(

2319: );
2320:
2321: x_return_status := FND_API.G_RET_STS_ERROR;
2322:
2323: FND_MSG_PUB.Count_And_Get(
2324: p_encoded => FND_API.G_FALSE,
2325: p_count => x_msg_count,
2326: p_data => x_msg_data
2327: );

Line 2594: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2590: );
2591:
2592: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
2593: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
2594: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2595:
2596: /*
2597: * Propogate exception to caller.
2598: */

Line 2606: FND_MSG_PUB.Count_And_Get(

2602: /*
2603: * Standard call to get message count and if count is 1, get
2604: * message info.
2605: */
2606: FND_MSG_PUB.Count_And_Get(
2607: p_encoded => FND_API.G_FALSE,
2608: p_count => x_msg_count,
2609: p_data => x_msg_data
2610: );

Line 2627: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2623: );
2624:
2625: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
2626: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
2627: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2628:
2629: x_return_status := FND_API.G_RET_STS_ERROR;
2630:
2631: FND_MSG_PUB.Count_And_Get(

Line 2631: FND_MSG_PUB.Count_And_Get(

2627: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2628:
2629: x_return_status := FND_API.G_RET_STS_ERROR;
2630:
2631: FND_MSG_PUB.Count_And_Get(
2632: p_encoded => FND_API.G_FALSE,
2633: p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );

Line 2725: FND_MSG_PUB.initialize;

2721: END IF;
2722:
2723: /* Initialize message list if p_init_msg_list is set to TRUE */
2724: IF FND_API.to_boolean(p_init_msg_list) THEN
2725: FND_MSG_PUB.initialize;
2726: END IF;
2727:
2728: /* Initialize return status */
2729: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2846: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2842: );
2843:
2844: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
2845: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
2846: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2847:
2848: /*
2849: * Propogate exception to caller.
2850: */

Line 2869: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2865: );
2866:
2867: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
2868: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
2869: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2870:
2871: x_return_status := FND_API.G_RET_STS_ERROR;
2872:
2873: print_debuginfo(l_module_name, 'EXIT');

Line 2966: FND_MSG_PUB.initialize;

2962: BEGIN
2963:
2964: print_debuginfo(l_module_name, 'ENTER');
2965:
2966: FND_MSG_PUB.initialize;
2967:
2968: /*
2969: * Pick up all qualifying payments of the payment instruction.
2970: */

Line 3179: FND_MSG_PUB.initialize;

3175: END IF;
3176:
3177: /* Initialize message list if p_init_msg_list is set to TRUE */
3178: IF FND_API.to_boolean(p_init_msg_list) THEN
3179: FND_MSG_PUB.initialize;
3180: END IF;
3181:
3182: /* Initialize return status */
3183: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3221: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3217: );
3218:
3219: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3220: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3221: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3222:
3223: x_return_status := FND_API.G_RET_STS_ERROR;
3224:
3225: l_error_code := 'IBY_INS_NO_PMT_DOC';

Line 3232: FND_MSG_PUB.ADD;

3228: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
3229: p_payment_doc_id,
3230: FALSE);
3231:
3232: FND_MSG_PUB.ADD;
3233:
3234: FND_MSG_PUB.COUNT_AND_GET(
3235: p_count => x_msg_count,
3236: p_data => x_msg_data

Line 3234: FND_MSG_PUB.COUNT_AND_GET(

3230: FALSE);
3231:
3232: FND_MSG_PUB.ADD;
3233:
3234: FND_MSG_PUB.COUNT_AND_GET(
3235: p_count => x_msg_count,
3236: p_data => x_msg_data
3237: );
3238:

Line 3265: FND_MSG_PUB.ADD;

3261: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
3262: p_payment_doc_id,
3263: FALSE);
3264:
3265: FND_MSG_PUB.ADD;
3266:
3267: FND_MSG_PUB.COUNT_AND_GET(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data

Line 3267: FND_MSG_PUB.COUNT_AND_GET(

3263: FALSE);
3264:
3265: FND_MSG_PUB.ADD;
3266:
3267: FND_MSG_PUB.COUNT_AND_GET(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data
3270: );
3271:

Line 3357: FND_MSG_PUB.ADD;

3353:
3354: l_error_code := 'IBY_CHECK_STOCK_EXHAUSTED';
3355: FND_MESSAGE.set_name('IBY', l_error_code);
3356:
3357: FND_MSG_PUB.ADD;
3358:
3359: FND_MSG_PUB.COUNT_AND_GET(
3360: p_count => x_msg_count,
3361: p_data => x_msg_data

Line 3359: FND_MSG_PUB.COUNT_AND_GET(

3355: FND_MESSAGE.set_name('IBY', l_error_code);
3356:
3357: FND_MSG_PUB.ADD;
3358:
3359: FND_MSG_PUB.COUNT_AND_GET(
3360: p_count => x_msg_count,
3361: p_data => x_msg_data
3362: );
3363:

Line 3438: FND_MSG_PUB.ADD;

3434: FND_MESSAGE.SET_TOKEN('FIRST_AVAILABLE_DOC_NUM',
3435: l_first_avail_check_num,
3436: FALSE);
3437:
3438: FND_MSG_PUB.ADD;
3439:
3440: FND_MSG_PUB.COUNT_AND_GET(
3441: p_count => x_msg_count,
3442: p_data => x_msg_data

Line 3440: FND_MSG_PUB.COUNT_AND_GET(

3436: FALSE);
3437:
3438: FND_MSG_PUB.ADD;
3439:
3440: FND_MSG_PUB.COUNT_AND_GET(
3441: p_count => x_msg_count,
3442: p_data => x_msg_data
3443: );
3444:

Line 3489: FND_MSG_PUB.ADD;

3485: FND_MESSAGE.SET_TOKEN('LAST_AVAILABLE_DOC_NUM',
3486: l_last_avail_check_num,
3487: FALSE);
3488:
3489: FND_MSG_PUB.ADD;
3490:
3491: FND_MSG_PUB.COUNT_AND_GET(
3492: p_count => x_msg_count,
3493: p_data => x_msg_data

Line 3491: FND_MSG_PUB.COUNT_AND_GET(

3487: FALSE);
3488:
3489: FND_MSG_PUB.ADD;
3490:
3491: FND_MSG_PUB.COUNT_AND_GET(
3492: p_count => x_msg_count,
3493: p_data => x_msg_data
3494: );
3495:

Line 3536: FND_MSG_PUB.ADD;

3532:
3533: l_error_code := 'IBY_DOC_NUM_BELOW_ISSUED';
3534: FND_MESSAGE.set_name('IBY', l_error_code);
3535:
3536: FND_MSG_PUB.ADD;
3537:
3538: FND_MSG_PUB.COUNT_AND_GET(
3539: p_count => x_msg_count,
3540: p_data => x_msg_data

Line 3538: FND_MSG_PUB.COUNT_AND_GET(

3534: FND_MESSAGE.set_name('IBY', l_error_code);
3535:
3536: FND_MSG_PUB.ADD;
3537:
3538: FND_MSG_PUB.COUNT_AND_GET(
3539: p_count => x_msg_count,
3540: p_data => x_msg_data
3541: );
3542:

Line 3566: FND_MSG_PUB.ADD;

3562:
3563: l_error_code := 'IBY_DOC_NUM_USED';
3564: FND_MESSAGE.set_name('IBY', l_error_code);
3565:
3566: FND_MSG_PUB.ADD;
3567:
3568: FND_MSG_PUB.COUNT_AND_GET(
3569: p_count => x_msg_count,
3570: p_data => x_msg_data

Line 3568: FND_MSG_PUB.COUNT_AND_GET(

3564: FND_MESSAGE.set_name('IBY', l_error_code);
3565:
3566: FND_MSG_PUB.ADD;
3567:
3568: FND_MSG_PUB.COUNT_AND_GET(
3569: p_count => x_msg_count,
3570: p_data => x_msg_data
3571: );
3572:

Line 3730: FND_MSG_PUB.initialize;

3726: BEGIN
3727:
3728: print_debuginfo(l_module_name, 'ENTER');
3729:
3730: FND_MSG_PUB.initialize;
3731:
3732: /*
3733: * STATUS CHANGE:
3734: *

Line 3785: FND_MSG_PUB.ADD;

3781: x_return_status := FND_API.G_RET_STS_ERROR;
3782:
3783: l_error_code := 'IBY_INS_LOCKED';
3784: FND_MESSAGE.set_name('IBY', l_error_code);
3785: FND_MSG_PUB.ADD;
3786:
3787: --FND_MSG_PUB.COUNT_AND_GET(
3788: -- p_count => x_msg_count,
3789: -- p_data => x_msg_data

Line 3787: --FND_MSG_PUB.COUNT_AND_GET(

3783: l_error_code := 'IBY_INS_LOCKED';
3784: FND_MESSAGE.set_name('IBY', l_error_code);
3785: FND_MSG_PUB.ADD;
3786:
3787: --FND_MSG_PUB.COUNT_AND_GET(
3788: -- p_count => x_msg_count,
3789: -- p_data => x_msg_data
3790: -- );
3791:

Line 3865: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3861: || '. Aborting program ..'
3862: );
3863: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3864: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3865: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3866:
3867: /*
3868: * Propogate exception to caller.
3869: */

Line 3925: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3921: print_debuginfo(l_module_name, 'No payments exist for payment '
3922: || 'instruction '
3923: || p_instr_id
3924: );
3925: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3926:
3927: WHEN OTHERS THEN
3928: print_debuginfo(l_module_name, 'Fatal: Exception occured '
3929: || 'when attempting to update status of payments '

Line 3936: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3932: || '. Aborting program ..'
3933: );
3934: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3935: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3936: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3937:
3938: /*
3939: * Propogate exception to caller.
3940: */

Line 4061: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4057: );
4058:
4059: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
4060: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
4061: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4062:
4063: END;
4064:
4065: /*

Line 4235: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4231: );
4232:
4233: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4234: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4235: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4236:
4237: /*
4238: * Propogate exception to caller.
4239: */

Line 4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4285: );
4286:
4287: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
4288: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4290:
4291: x_return_status := FND_API.G_RET_STS_ERROR;
4292:
4293: print_debuginfo(l_module_name, 'EXIT');

Line 4380: FND_MSG_PUB.initialize;

4376: || ', payment request status: '
4377: || p_req_status
4378: );
4379:
4380: FND_MSG_PUB.initialize;
4381:
4382: /*
4383: * STATUS CHANGE:
4384: *

Line 4416: FND_MSG_PUB.ADD;

4412: x_return_status := FND_API.G_RET_STS_ERROR;
4413:
4414: l_error_code := 'IBY_PPR_LOCKED';
4415: FND_MESSAGE.set_name('IBY', l_error_code);
4416: FND_MSG_PUB.ADD;
4417:
4418: --FND_MSG_PUB.COUNT_AND_GET(
4419: -- p_count => x_msg_count,
4420: -- p_data => x_msg_data

Line 4418: --FND_MSG_PUB.COUNT_AND_GET(

4414: l_error_code := 'IBY_PPR_LOCKED';
4415: FND_MESSAGE.set_name('IBY', l_error_code);
4416: FND_MSG_PUB.ADD;
4417:
4418: --FND_MSG_PUB.COUNT_AND_GET(
4419: -- p_count => x_msg_count,
4420: -- p_data => x_msg_data
4421: -- );
4422:

Line 4460: FND_MSG_PUB.ADD;

4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457:
4458: l_error_code := 'IBY_PPR_TERM_NOT_ALLOWED';
4459: FND_MESSAGE.set_name('IBY', l_error_code);
4460: FND_MSG_PUB.ADD;
4461:
4462: --FND_MSG_PUB.COUNT_AND_GET(
4463: -- p_count => x_msg_count,
4464: -- p_data => x_msg_data

Line 4462: --FND_MSG_PUB.COUNT_AND_GET(

4458: l_error_code := 'IBY_PPR_TERM_NOT_ALLOWED';
4459: FND_MESSAGE.set_name('IBY', l_error_code);
4460: FND_MSG_PUB.ADD;
4461:
4462: --FND_MSG_PUB.COUNT_AND_GET(
4463: -- p_count => x_msg_count,
4464: -- p_data => x_msg_data
4465: -- );
4466:

Line 4534: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4530: || '. Aborting program ..'
4531: );
4532: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4533: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4534: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4535:
4536: /*
4537: * Propogate exception to caller.
4538: */

Line 4611: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4607: || '. Aborting program ..'
4608: );
4609: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4610: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4611: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4612:
4613: /*
4614: * Propogate exception to caller.
4615: */

Line 4757: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4753: );
4754:
4755: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4756: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4757: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4758:
4759: /*
4760: * Propogate exception to caller.
4761: */

Line 4809: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4805: );
4806:
4807: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
4808: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
4809: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4810:
4811: x_return_status := FND_API.G_RET_STS_ERROR;
4812:
4813: print_debuginfo(l_module_name, 'EXIT');

Line 4871: FND_MSG_PUB.initialize;

4867: BEGIN
4868:
4869: print_debuginfo(l_module_name, 'ENTER');
4870:
4871: FND_MSG_PUB.initialize;
4872:
4873: /*
4874: * STATUS CHANGE:
4875: *

Line 5047: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

5043: || p_payreq_id
5044: );
5045: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5046: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5047: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5048:
5049: x_error_buf := 'BUILD PROGRAM ERROR - RESUBMITTING PAYMENT'
5050: || ' REQUEST FAILED';
5051:

Line 5096: FND_MSG_PUB.initialize;

5092: BEGIN
5093:
5094: print_debuginfo(l_module_name, 'ENTER');
5095:
5096: FND_MSG_PUB.initialize;
5097:
5098: /*
5099: * STATUS CHANGE:
5100: *

Line 5204: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

5200: || p_ins_id
5201: );
5202: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5203: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5204: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5205:
5206: x_error_buf := 'PICP ERROR - RESUBMITTING PAYMENT'
5207: || ' INSTRUCTION FAILED';
5208:

Line 5330: FND_MSG_PUB.initialize;

5326: BEGIN
5327:
5328: print_debuginfo(l_module_name, 'ENTER');
5329:
5330: FND_MSG_PUB.initialize;
5331:
5332: /*
5333: * STATUS CHANGE:
5334: *

Line 5646: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

5642: );
5643:
5644: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
5645: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
5646: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5647:
5648: /*
5649: * Propogate exception to caller.
5650: */

Line 5683: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

5679: );
5680:
5681: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5682: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5683: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5684:
5685: x_return_status := FND_API.G_RET_STS_ERROR;
5686:
5687: print_debuginfo(l_module_name, 'EXIT');

Line 5762: FND_MSG_PUB.initialize;

5758: BEGIN
5759:
5760: print_debuginfo(l_module_name, 'ENTER');
5761:
5762: FND_MSG_PUB.initialize;
5763:
5764: /*
5765: * STEP 0 .
5766: *

Line 5886: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

5882: );
5883:
5884: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5885: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5886: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5887:
5888: x_return_status := FND_API.G_RET_STS_ERROR;
5889:
5890: print_debuginfo(l_module_name, 'EXIT');

Line 5940: FND_MSG_PUB.initialize;

5936: BEGIN
5937:
5938: print_debuginfo(l_module_name, 'ENTER');
5939:
5940: FND_MSG_PUB.initialize;
5941:
5942: /*
5943: * STEP 1:
5944: *

Line 6022: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

6018: );
6019:
6020: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
6021: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
6022: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6023:
6024: x_return_status := FND_API.G_RET_STS_ERROR;
6025:
6026: print_debuginfo(l_module_name, 'EXIT');

Line 6245: FND_MSG_PUB.initialize;

6241: BEGIN
6242:
6243: print_debuginfo(l_module_name, 'ENTER');
6244:
6245: FND_MSG_PUB.initialize;
6246:
6247: /*
6248: * STATUS CHANGE:
6249: *

Line 6406: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

6402: );
6403:
6404: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
6405: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
6406: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6407:
6408: /*
6409: * Propogate exception to caller.
6410: */

Line 6482: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

6478: );
6479:
6480: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
6481: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
6482: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6483:
6484: /*
6485: * Propogate exception to caller.
6486: */

Line 6587: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

6583: );
6584:
6585: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
6586: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
6587: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6588:
6589: x_return_status := FND_API.G_RET_STS_ERROR;
6590:
6591: print_debuginfo(l_module_name, 'EXIT');

Line 6726: FND_MSG_PUB.initialize;

6722: BEGIN
6723:
6724: print_debuginfo(l_module_name, 'ENTER');
6725:
6726: FND_MSG_PUB.initialize;
6727:
6728: /*
6729: * STATUS CHANGE:
6730: *

Line 7005: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

7001: );
7002:
7003: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
7004: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
7005: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7006:
7007: /*
7008: * Propogate exception to caller.
7009: */

Line 7081: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

7077: );
7078:
7079: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
7080: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
7081: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7082:
7083: /*
7084: * Propogate exception to caller.
7085: */

Line 7186: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

7182: );
7183:
7184: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
7185: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
7186: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7187:
7188: x_return_status := FND_API.G_RET_STS_ERROR;
7189:
7190: print_debuginfo(l_module_name, 'EXIT');

Line 7342: FND_MSG_PUB.initialize;

7338: BEGIN
7339:
7340: print_debuginfo(l_module_name, 'ENTER');
7341:
7342: FND_MSG_PUB.initialize;
7343:
7344: /*
7345: * STATUS CHANGE:
7346: *

Line 7584: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

7580: );
7581:
7582: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
7583: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
7584: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7585:
7586: x_return_status := FND_API.G_RET_STS_ERROR;
7587:
7588: print_debuginfo(l_module_name, 'EXIT');

Line 7829: FND_MSG_PUB.initialize;

7825: BEGIN
7826:
7827: print_debuginfo(l_module_name, 'ENTER');
7828:
7829: FND_MSG_PUB.initialize;
7830:
7831: /*
7832: * STEP I:
7833: *

Line 8338: FND_MSG_PUB.ADD;

8334: * Set the message on the error stack
8335: * to display in UI (in case of direct
8336: * API call from UI).
8337: */
8338: FND_MSG_PUB.ADD;
8339:
8340: --FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8341:
8342: /*

Line 8340: --FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

8336: * API call from UI).
8337: */
8338: FND_MSG_PUB.ADD;
8339:
8340: --FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8341:
8342: /*
8343: * Propogate exception to caller.
8344: */

Line 8722: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

8718: );
8719:
8720: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
8721: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
8722: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8723:
8724: x_return_status := FND_API.G_RET_STS_ERROR;
8725:
8726: print_debuginfo(l_module_name, 'EXIT');

Line 8766: FND_MSG_PUB.initialize;

8762:
8763: BEGIN
8764:
8765: print_debuginfo(l_module_name, 'ENTER');
8766: FND_MSG_PUB.initialize;
8767:
8768: x_return_status := FND_API.G_RET_STS_SUCCESS;
8769:
8770: -- Update payment transaction statuses (instruction, payments, etc.)

Line 8809: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

8805: );
8806:
8807: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
8808: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
8809: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8810:
8811: x_return_status := FND_API.G_RET_STS_ERROR;
8812:
8813: print_debuginfo(l_module_name, 'EXIT');

Line 9179: FND_MSG_PUB.initialize;

9175: BEGIN
9176:
9177: print_debuginfo(l_module_name, 'ENTER');
9178:
9179: FND_MSG_PUB.initialize;
9180:
9181: /*
9182: * Get the status of the provided payment instruction.
9183: */

Line 9212: FND_MSG_PUB.add;

9208:
9209: FND_MESSAGE.SET_TOKEN('INS_ID',
9210: p_instruction_id,
9211: FALSE);
9212: FND_MSG_PUB.add;
9213: x_return_message := FND_MESSAGE.get;
9214:
9215: /*
9216: * Propogate exception.

Line 9252: FND_MSG_PUB.add;

9248:
9249: FND_MESSAGE.SET_TOKEN('BAD_STATUS',
9250: l_instr_status,
9251: FALSE);
9252: FND_MSG_PUB.add;
9253: x_return_message := FND_MESSAGE.get;
9254:
9255: APP_EXCEPTION.RAISE_EXCEPTION;
9256:

Line 9327: FND_MSG_PUB.add;

9323:
9324: FND_MESSAGE.SET_TOKEN('INS_ID',
9325: p_instruction_id,
9326: FALSE);
9327: FND_MSG_PUB.add;
9328: x_return_message := FND_MESSAGE.get;
9329:
9330: /*
9331: * Propagate exception.

Line 9396: FND_MSG_PUB.add;

9392:
9393: FND_MESSAGE.SET_TOKEN('INS_ID',
9394: p_instruction_id,
9395: FALSE);
9396: FND_MSG_PUB.add;
9397: x_return_message := FND_MESSAGE.get;
9398:
9399: print_debuginfo(l_module_name, 'Extract and '
9400: || 'format operation generated '

Line 9433: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

9429: print_debuginfo(l_module_name, 'SQL code: '
9430: || SQLCODE);
9431: print_debuginfo(l_module_name, 'SQL err msg: '
9432: || SQLERRM);
9433: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
9434:
9435: print_debuginfo(l_module_name, 'Returning failure response .. '
9436: );
9437:

Line 9657: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

9653:
9654: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
9655: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
9656:
9657: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
9658: x_return_status := FND_API.G_RET_STS_ERROR;
9659:
9660: print_debuginfo(l_module_name, 'EXIT');
9661:

Line 9725: FND_MSG_PUB.initialize;

9721: BEGIN
9722:
9723: print_debuginfo(l_module_name, 'ENTER');
9724:
9725: FND_MSG_PUB.initialize;
9726:
9727: print_debuginfo(l_module_name, 'Input params - '
9728: || 'object id: '
9729: || p_object_id

Line 9867: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

9863:
9864: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
9865: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
9866:
9867: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
9868:
9869: ROLLBACK;
9870:
9871: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10004: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

10000:
10001: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
10002: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
10003:
10004: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10005:
10006: ROLLBACK;
10007:
10008: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10050: FND_MSG_PUB.initialize;

10046: where lookup_type='IBY_PAYMENT_FUNCTIONS';
10047:
10048: begin
10049:
10050: FND_MSG_PUB.initialize;
10051:
10052: -- first check whether the payment function is populated or not
10053: begin
10054: select count(1)

Line 10102: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

10098: print_debuginfo(l_module_name, 'SQL err msg: '
10099: || SQLERRM);
10100: print_debuginfo(l_module_name, 'Returning failure response .. '
10101: );
10102: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10103: /*
10104: * The error message would have already been set.
10105: * Just set the error status here.
10106: */

Line 10153: FND_MSG_PUB.initialize;

10149:
10150: -- initiate the return parameter
10151: print_debuginfo(l_module_name, 'ENTER');
10152:
10153: FND_MSG_PUB.initialize;
10154: populatePaymentFunctions(x_return_status, x_return_message);
10155: x_access_flag:='N';
10156:
10157: /* Initialize return status */

Line 10199: FND_MSG_PUB.add;

10195: end if;
10196:
10197:
10198: FND_MESSAGE.set_name('IBY', l_message_code);
10199: FND_MSG_PUB.add;
10200:
10201: x_return_status := FND_API.G_RET_STS_ERROR;
10202:
10203: FND_MSG_PUB.Count_And_Get(

Line 10203: FND_MSG_PUB.Count_And_Get(

10199: FND_MSG_PUB.add;
10200:
10201: x_return_status := FND_API.G_RET_STS_ERROR;
10202:
10203: FND_MSG_PUB.Count_And_Get(
10204: p_encoded => FND_API.G_FALSE,
10205: p_count => l_msg_count,
10206: p_data => x_return_message
10207: );

Line 10221: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

10217: print_debuginfo(l_module_name, 'SQL err msg: '
10218: || SQLERRM);
10219: print_debuginfo(l_module_name, 'Returning failure response .. '
10220: );
10221: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10222: /*
10223: * The error message would have already been set.
10224: * Just set the error status here.
10225: */

Line 10572: FND_MSG_PUB.initialize;

10568:
10569: BEGIN
10570:
10571: print_debuginfo(l_module_name, 'ENTER');
10572: FND_MSG_PUB.initialize;
10573:
10574: /*
10575: * STEP 1:
10576: *

Line 10988: FND_MSG_PUB.initialize;

10984: BEGIN
10985: print_debuginfo(l_module_name, 'ENTER');
10986:
10987: x_return_status := FND_API.G_RET_STS_SUCCESS;
10988: FND_MSG_PUB.initialize;
10989:
10990: /* set the context for the request set IBY_SECURITY_MASKING_REQ_SET */
10991: l_success := fnd_submit.set_request_set('IBY', 'IBY_SECURITY_MASKING_REQ_SET');
10992: l_phase := 'After set request set.';

Line 11032: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11028: EXCEPTION
11029: WHEN submit_failed THEN
11030: x_return_status := FND_API.G_RET_STS_ERROR;
11031: print_debuginfo(l_module_name, 'Exception submit_failed - ' || l_phase);
11032: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11033:
11034: WHEN others THEN
11035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11036: print_debuginfo(l_module_name, 'Exception others.');

Line 11039: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11036: print_debuginfo(l_module_name, 'Exception others.');
11037: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
11038: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
11039: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11040:
11041: END submit_masking_req_set;
11042:
11043: -- The procedure to submit a request set

Line 11083: FND_MSG_PUB.initialize;

11079: BEGIN
11080: print_debuginfo(l_module_name, 'ENTER');
11081:
11082: x_return_status := FND_API.G_RET_STS_SUCCESS;
11083: FND_MSG_PUB.initialize;
11084:
11085: /* set the context for the request set IBY_SECURITY_DECRYPT_REQ_SET */
11086: l_success := fnd_submit.set_request_set('IBY', 'IBY_SECURITY_DECRYPT_REQ_SET');
11087: l_phase := 'After set request set.';

Line 11151: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11147: EXCEPTION
11148: WHEN submit_failed THEN
11149: x_return_status := FND_API.G_RET_STS_ERROR;
11150: print_debuginfo(l_module_name, 'Exception submit_failed - ' || l_phase);
11151: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11152:
11153: WHEN others THEN
11154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11155: print_debuginfo(l_module_name, 'Exception others.');

Line 11158: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11155: print_debuginfo(l_module_name, 'Exception others.');
11156: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
11157: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
11158: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11159:
11160: END submit_decrypt_req_set;
11161:
11162: /*--------------------------------------------------------------------

Line 11273: FND_MSG_PUB.initialize;

11269:
11270: print_debuginfo(l_module_name, 'ENTER');
11271: print_debuginfo(l_module_name, 'completion id: ' || p_completion_id);
11272:
11273: FND_MSG_PUB.initialize;
11274:
11275: OPEN c_pmt_ids (p_completion_id);
11276: FETCH c_pmt_ids BULK COLLECT INTO l_pmts_list;
11277: CLOSE c_pmt_ids;

Line 11315: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11311: );
11312:
11313: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
11314: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
11315: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11316:
11317: END print_completed_pmts;
11318:
11319:

Line 11372: FND_MSG_PUB.initialize;

11368:
11369: print_debuginfo(l_module_name, 'ENTER');
11370: print_debuginfo(l_module_name, 'completion id: ' || p_completion_id);
11371:
11372: FND_MSG_PUB.initialize;
11373:
11374: OPEN c_doc_ids (p_completion_id);
11375: FETCH c_doc_ids BULK COLLECT INTO l_docs_list;
11376: CLOSE c_doc_ids;

Line 11414: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11410: );
11411:
11412: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
11413: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
11414: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11415:
11416: END print_completed_docs;
11417:
11418:

Line 11498: FND_MSG_PUB.initialize;

11494: print_debuginfo(l_module_name, 'ENTER');
11495: --Initializing the out parameter
11496: x_inaccessible_entities :='N';
11497:
11498: FND_MSG_PUB.initialize;
11499:
11500: /*Initializing security through CE for populating the
11501: ce related global tables*/
11502: CEP_STANDARD.init_security();

Line 11590: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

11586: print_debuginfo(l_module_name, 'SQL err msg: '
11587: || SQLERRM);
11588: print_debuginfo(l_module_name, 'Returning failure response .. '
11589: );
11590: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11591: /*
11592: * The error message would have already been set.
11593: * Just set the error status here.
11594: */