DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on FND_MSG_PUB

Line 382: FND_MSG_PUB.initialize;

378: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
379: print_debuginfo(l_module_name, 'ENTER');
380:
381: END IF;
382: FND_MSG_PUB.initialize;
383:
384: /*
385: * STATUS CHANGE:
386: *

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

523:
524: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
525: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
526:
527: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
528:
529: /*
530: * Propogate exception to caller.
531: */

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

552:
553: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
554: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
555: END IF;
556: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
557: x_return_status := FND_API.G_RET_STS_ERROR;
558:
559: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
560: print_debuginfo(l_module_name, 'EXIT');

Line 638: FND_MSG_PUB.initialize;

634: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
635: print_debuginfo(l_module_name, 'ENTER');
636:
637: END IF;
638: FND_MSG_PUB.initialize;
639:
640: IF (p_doc_list.COUNT = 0 OR p_doc_status_list.COUNT = 0) THEN
641:
642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

824:
825: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
826: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
827:
828: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
829:
830: /*
831: * Propogate exception to caller.
832: */

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

853:
854: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
855: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
856: END IF;
857: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
858: x_return_status := FND_API.G_RET_STS_ERROR;
859:
860: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
861: print_debuginfo(l_module_name, 'EXIT');

Line 960: FND_MSG_PUB.initialize;

956: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
957: print_debuginfo(l_module_name, 'ENTER');
958:
959: END IF;
960: FND_MSG_PUB.initialize;
961:
962: /*
963: * STATUS CHANGE:
964: *

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

1118:
1119: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
1120: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
1121:
1122: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1123:
1124: /*
1125: * Propogate exception to caller.
1126: */

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

1148:
1149: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
1150: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
1151: END IF;
1152: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1226: FND_MSG_PUB.initialize;

1222: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1223: print_debuginfo(l_module_name, 'ENTER');
1224:
1225: END IF;
1226: FND_MSG_PUB.initialize;
1227:
1228: IF (p_pmt_list.COUNT = 0 OR p_pmt_status_list.COUNT = 0) THEN
1229:
1230: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1396: FND_MSG_PUB.initialize;

1392: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1393: print_debuginfo(l_module_name, 'ENTER');
1394:
1395: END IF;
1396: FND_MSG_PUB.initialize;
1397:
1398: /*
1399: * Pick up all documents for this payment request.
1400: */

Line 1577: FND_MSG_PUB.initialize;

1573: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1574: print_debuginfo(l_module_name, 'ENTER');
1575:
1576: END IF;
1577: FND_MSG_PUB.initialize;
1578:
1579: /*
1580: * STATUS CHANGE:
1581: *

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

1812:
1813: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
1814: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
1815:
1816: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1817:
1818: /*
1819: * Propogate exception to caller.
1820: */

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

1841:
1842: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
1843: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
1844: END IF;
1845: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1846:
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848:
1849: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1919: FND_MSG_PUB.initialize;

1915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: print_debuginfo(l_module_name, 'ENTER');
1917:
1918: END IF;
1919: FND_MSG_PUB.initialize;
1920:
1921: IF (p_pmt_list.COUNT = 0 OR p_pmt_status_list.COUNT = 0) THEN
1922:
1923: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2115: FND_MSG_PUB.initialize;

2111: END IF;
2112:
2113: /* Initialize message list if p_init_msg_list is set to TRUE */
2114: IF FND_API.to_boolean(p_init_msg_list) THEN
2115: FND_MSG_PUB.initialize;
2116: END IF;
2117:
2118: /* Initialize return status */
2119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2323: FND_MSG_PUB.Count_And_Get(

2319: /*
2320: * Standard call to get message count and if count is 1, get
2321: * message info.
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 2349: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

2345:
2346: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
2347: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
2348: END IF;
2349: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2350:
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352:
2353: FND_MSG_PUB.Count_And_Get(

Line 2353: FND_MSG_PUB.Count_And_Get(

2349: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2350:
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352:
2353: FND_MSG_PUB.Count_And_Get(
2354: p_encoded => FND_API.G_FALSE,
2355: p_count => x_msg_count,
2356: p_data => x_msg_data
2357: );

Line 2580: FND_MSG_PUB.initialize;

2576: END IF;
2577:
2578: /* Initialize message list if p_init_msg_list is set to TRUE */
2579: IF FND_API.to_boolean(p_init_msg_list) THEN
2580: FND_MSG_PUB.initialize;
2581: END IF;
2582:
2583: /* Initialize return status */
2584: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2668: FND_MSG_PUB.Count_And_Get(

2664:
2665: END IF;
2666: x_return_status := FND_API.G_RET_STS_ERROR;
2667:
2668: FND_MSG_PUB.Count_And_Get(
2669: p_encoded => FND_API.G_FALSE,
2670: p_count => x_msg_count,
2671: p_data => x_msg_data
2672: );

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

3004:
3005: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3006: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3007:
3008: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3009:
3010: /*
3011: * Propogate exception to caller.
3012: */

Line 3020: FND_MSG_PUB.Count_And_Get(

3016: /*
3017: * Standard call to get message count and if count is 1, get
3018: * message info.
3019: */
3020: FND_MSG_PUB.Count_And_Get(
3021: p_encoded => FND_API.G_FALSE,
3022: p_count => x_msg_count,
3023: p_data => x_msg_data
3024: );

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

3041:
3042: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3043: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3044: END IF;
3045: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3046:
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: FND_MSG_PUB.Count_And_Get(

Line 3049: FND_MSG_PUB.Count_And_Get(

3045: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3046:
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: FND_MSG_PUB.Count_And_Get(
3050: p_encoded => FND_API.G_FALSE,
3051: p_count => x_msg_count,
3052: p_data => x_msg_data
3053: );

Line 3147: FND_MSG_PUB.initialize;

3143: END IF;
3144:
3145: /* Initialize message list if p_init_msg_list is set to TRUE */
3146: IF FND_API.to_boolean(p_init_msg_list) THEN
3147: FND_MSG_PUB.initialize;
3148: END IF;
3149:
3150: /* Initialize return status */
3151: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3278:
3279: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3280: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3281:
3282: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3283:
3284: /*
3285: * Propogate exception to caller.
3286: */

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

3305:
3306: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
3307: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
3308: END IF;
3309: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3310:
3311: x_return_status := FND_API.G_RET_STS_ERROR;
3312:
3313: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3411: FND_MSG_PUB.initialize;

3407: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3408: print_debuginfo(l_module_name, 'ENTER');
3409:
3410: END IF;
3411: FND_MSG_PUB.initialize;
3412:
3413: /* Bug: 8692538
3414: *
3415: * Validation to make sure that void date is not prior to payment date

Line 3429: fnd_msg_pub.add;

3425: IF(p_void_date < l_pmt_date) THEN
3426: x_return_status := FND_API.G_RET_STS_ERROR;
3427: fnd_message.set_name('IBY', 'IBY_VOID_DATE_BEF_PMT_DATE');
3428: fnd_message.set_Token('PMT_DATE', l_pmt_date);
3429: fnd_msg_pub.add;
3430: RETURN;
3431: END IF;
3432:
3433:

Line 3663: FND_MSG_PUB.initialize;

3659: END IF;
3660:
3661: /* Initialize message list if p_init_msg_list is set to TRUE */
3662: IF FND_API.to_boolean(p_init_msg_list) THEN
3663: FND_MSG_PUB.initialize;
3664: END IF;
3665:
3666: /* Initialize return status */
3667: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3703:
3704: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3705: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
3706: END IF;
3707: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3708:
3709: x_return_status := FND_API.G_RET_STS_ERROR;
3710:
3711: l_error_code := 'IBY_INS_NO_PMT_DOC';

Line 3718: FND_MSG_PUB.ADD;

3714: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
3715: p_payment_doc_id,
3716: FALSE);
3717:
3718: FND_MSG_PUB.ADD;
3719:
3720: FND_MSG_PUB.COUNT_AND_GET(
3721: p_count => x_msg_count,
3722: p_data => x_msg_data

Line 3720: FND_MSG_PUB.COUNT_AND_GET(

3716: FALSE);
3717:
3718: FND_MSG_PUB.ADD;
3719:
3720: FND_MSG_PUB.COUNT_AND_GET(
3721: p_count => x_msg_count,
3722: p_data => x_msg_data
3723: );
3724:

Line 3755: FND_MSG_PUB.ADD;

3751: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
3752: p_payment_doc_id,
3753: FALSE);
3754:
3755: FND_MSG_PUB.ADD;
3756:
3757: FND_MSG_PUB.COUNT_AND_GET(
3758: p_count => x_msg_count,
3759: p_data => x_msg_data

Line 3757: FND_MSG_PUB.COUNT_AND_GET(

3753: FALSE);
3754:
3755: FND_MSG_PUB.ADD;
3756:
3757: FND_MSG_PUB.COUNT_AND_GET(
3758: p_count => x_msg_count,
3759: p_data => x_msg_data
3760: );
3761:

Line 3858: FND_MSG_PUB.ADD;

3854:
3855: l_error_code := 'IBY_CHECK_STOCK_EXHTD_REENTER';
3856: FND_MESSAGE.set_name('IBY', l_error_code);
3857:
3858: FND_MSG_PUB.ADD;
3859:
3860: FND_MSG_PUB.COUNT_AND_GET(
3861: p_count => x_msg_count,
3862: p_data => x_msg_data

Line 3860: FND_MSG_PUB.COUNT_AND_GET(

3856: FND_MESSAGE.set_name('IBY', l_error_code);
3857:
3858: FND_MSG_PUB.ADD;
3859:
3860: FND_MSG_PUB.COUNT_AND_GET(
3861: p_count => x_msg_count,
3862: p_data => x_msg_data
3863: );
3864:

Line 3949: FND_MSG_PUB.ADD;

3945: FND_MESSAGE.SET_TOKEN('FIRST_AVAILABLE_DOC_NUM',
3946: l_first_avail_check_num,
3947: FALSE);
3948:
3949: FND_MSG_PUB.ADD;
3950:
3951: FND_MSG_PUB.COUNT_AND_GET(
3952: p_count => x_msg_count,
3953: p_data => x_msg_data

Line 3951: FND_MSG_PUB.COUNT_AND_GET(

3947: FALSE);
3948:
3949: FND_MSG_PUB.ADD;
3950:
3951: FND_MSG_PUB.COUNT_AND_GET(
3952: p_count => x_msg_count,
3953: p_data => x_msg_data
3954: );
3955:

Line 4004: FND_MSG_PUB.ADD;

4000: FND_MESSAGE.SET_TOKEN('LAST_AVAILABLE_DOC_NUM',
4001: l_last_avail_check_num,
4002: FALSE);
4003:
4004: FND_MSG_PUB.ADD;
4005:
4006: FND_MSG_PUB.COUNT_AND_GET(
4007: p_count => x_msg_count,
4008: p_data => x_msg_data

Line 4006: FND_MSG_PUB.COUNT_AND_GET(

4002: FALSE);
4003:
4004: FND_MSG_PUB.ADD;
4005:
4006: FND_MSG_PUB.COUNT_AND_GET(
4007: p_count => x_msg_count,
4008: p_data => x_msg_data
4009: );
4010:

Line 4055: FND_MSG_PUB.ADD;

4051: END IF;
4052: l_error_code := 'IBY_DOC_NUM_BELOW_ISSUED';
4053: FND_MESSAGE.set_name('IBY', l_error_code);
4054:
4055: FND_MSG_PUB.ADD;
4056:
4057: FND_MSG_PUB.COUNT_AND_GET(
4058: p_count => x_msg_count,
4059: p_data => x_msg_data

Line 4057: FND_MSG_PUB.COUNT_AND_GET(

4053: FND_MESSAGE.set_name('IBY', l_error_code);
4054:
4055: FND_MSG_PUB.ADD;
4056:
4057: FND_MSG_PUB.COUNT_AND_GET(
4058: p_count => x_msg_count,
4059: p_data => x_msg_data
4060: );
4061:

Line 4087: FND_MSG_PUB.ADD;

4083:
4084: l_error_code := 'IBY_DOC_NUM_USED';
4085: FND_MESSAGE.set_name('IBY', l_error_code);
4086:
4087: FND_MSG_PUB.ADD;
4088:
4089: FND_MSG_PUB.COUNT_AND_GET(
4090: p_count => x_msg_count,
4091: p_data => x_msg_data

Line 4089: FND_MSG_PUB.COUNT_AND_GET(

4085: FND_MESSAGE.set_name('IBY', l_error_code);
4086:
4087: FND_MSG_PUB.ADD;
4088:
4089: FND_MSG_PUB.COUNT_AND_GET(
4090: p_count => x_msg_count,
4091: p_data => x_msg_data
4092: );
4093:

Line 4214: FND_MSG_PUB.initialize;

4210: END IF;
4211:
4212: /* Initialize message list if p_init_msg_list is set to TRUE */
4213: IF FND_API.to_boolean(p_init_msg_list) THEN
4214: FND_MSG_PUB.initialize;
4215: END IF;
4216:
4217: /* Initialize return status */
4218: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4243:
4244: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4245: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4246: END IF;
4247: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4248:
4249: x_return_status := FND_API.G_RET_STS_ERROR;
4250:
4251: l_error_code := 'IBY_INS_NO_PMT_DOC';

Line 4258: FND_MSG_PUB.ADD;

4254: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
4255: p_payment_doc_id,
4256: FALSE);
4257:
4258: FND_MSG_PUB.ADD;
4259:
4260: FND_MSG_PUB.COUNT_AND_GET(
4261: p_count => x_msg_count,
4262: p_data => x_msg_data

Line 4260: FND_MSG_PUB.COUNT_AND_GET(

4256: FALSE);
4257:
4258: FND_MSG_PUB.ADD;
4259:
4260: FND_MSG_PUB.COUNT_AND_GET(
4261: p_count => x_msg_count,
4262: p_data => x_msg_data
4263: );
4264:

Line 4295: FND_MSG_PUB.ADD;

4291: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
4292: p_payment_doc_id,
4293: FALSE);
4294:
4295: FND_MSG_PUB.ADD;
4296:
4297: FND_MSG_PUB.COUNT_AND_GET(
4298: p_count => x_msg_count,
4299: p_data => x_msg_data

Line 4297: FND_MSG_PUB.COUNT_AND_GET(

4293: FALSE);
4294:
4295: FND_MSG_PUB.ADD;
4296:
4297: FND_MSG_PUB.COUNT_AND_GET(
4298: p_count => x_msg_count,
4299: p_data => x_msg_data
4300: );
4301:

Line 4337: FND_MSG_PUB.ADD;

4333:
4334: FND_MESSAGE.SET_TOKEN('PAY_INSTRUCTION',
4335: l_pmt_instr_id,
4336: FALSE);
4337: FND_MSG_PUB.ADD;
4338:
4339: FND_MSG_PUB.COUNT_AND_GET(
4340: p_count => x_msg_count,
4341: p_data => x_msg_data

Line 4339: FND_MSG_PUB.COUNT_AND_GET(

4335: l_pmt_instr_id,
4336: FALSE);
4337: FND_MSG_PUB.ADD;
4338:
4339: FND_MSG_PUB.COUNT_AND_GET(
4340: p_count => x_msg_count,
4341: p_data => x_msg_data
4342: );
4343:

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

4381:
4382: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4383: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4384: END IF;
4385: --FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4386:
4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388:
4389: l_error_code := 'IBY_PMT_DOC_UNAVAILABLE';

Line 4392: FND_MSG_PUB.ADD;

4388:
4389: l_error_code := 'IBY_PMT_DOC_UNAVAILABLE';
4390: FND_MESSAGE.set_name('IBY', l_error_code);
4391:
4392: FND_MSG_PUB.ADD;
4393:
4394: FND_MSG_PUB.COUNT_AND_GET(
4395: p_count => x_msg_count,
4396: p_data => x_msg_data

Line 4394: FND_MSG_PUB.COUNT_AND_GET(

4390: FND_MESSAGE.set_name('IBY', l_error_code);
4391:
4392: FND_MSG_PUB.ADD;
4393:
4394: FND_MSG_PUB.COUNT_AND_GET(
4395: p_count => x_msg_count,
4396: p_data => x_msg_data
4397: );
4398:

Line 4429: FND_MSG_PUB.ADD;

4425: FND_MESSAGE.SET_TOKEN('PMT_DOC_ID',
4426: p_payment_doc_id,
4427: FALSE);
4428:
4429: FND_MSG_PUB.ADD;
4430:
4431: FND_MSG_PUB.COUNT_AND_GET(
4432: p_count => x_msg_count,
4433: p_data => x_msg_data

Line 4431: FND_MSG_PUB.COUNT_AND_GET(

4427: FALSE);
4428:
4429: FND_MSG_PUB.ADD;
4430:
4431: FND_MSG_PUB.COUNT_AND_GET(
4432: p_count => x_msg_count,
4433: p_data => x_msg_data
4434: );
4435:

Line 4586: FND_MSG_PUB.initialize;

4582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4583: print_debuginfo(l_module_name, 'ENTER');
4584:
4585: END IF;
4586: FND_MSG_PUB.initialize;
4587:
4588: /*
4589: * STATUS CHANGE:
4590: *

Line 4655: FND_MSG_PUB.ADD;

4651: x_return_status := FND_API.G_RET_STS_ERROR;
4652:
4653: l_error_code := 'IBY_INS_LOCKED';
4654: FND_MESSAGE.set_name('IBY', l_error_code);
4655: FND_MSG_PUB.ADD;
4656:
4657: --FND_MSG_PUB.COUNT_AND_GET(
4658: -- p_count => x_msg_count,
4659: -- p_data => x_msg_data

Line 4657: --FND_MSG_PUB.COUNT_AND_GET(

4653: l_error_code := 'IBY_INS_LOCKED';
4654: FND_MESSAGE.set_name('IBY', l_error_code);
4655: FND_MSG_PUB.ADD;
4656:
4657: --FND_MSG_PUB.COUNT_AND_GET(
4658: -- p_count => x_msg_count,
4659: -- p_data => x_msg_data
4660: -- );
4661:

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

4828: );
4829: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4830: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4831:
4832: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4833:
4834: /*
4835: * Propogate exception to caller.
4836: */

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

4890: || 'instruction '
4891: || p_instr_id
4892: );
4893: END IF;
4894: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4895:
4896: WHEN OTHERS THEN
4897:
4898: print_debuginfo(l_module_name, 'Fatal: Exception occured '

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

4903: );
4904: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4905: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
4906:
4907: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4908:
4909: /*
4910: * Propogate exception to caller.
4911: */

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

5071:
5072: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5073: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5074: END IF;
5075: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5076:
5077: END;
5078:
5079: /*

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

5261:
5262: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
5263: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
5264:
5265: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5266:
5267: /*
5268: * Propogate exception to caller.
5269: */

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

5319:
5320: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5321: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5322: END IF;
5323: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5324:
5325: x_return_status := FND_API.G_RET_STS_ERROR;
5326:
5327: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5431: FND_MSG_PUB.initialize;

5427: || p_req_status
5428: );
5429:
5430: END IF;
5431: FND_MSG_PUB.initialize;
5432:
5433: /*
5434: * STATUS CHANGE:
5435: *

Line 5469: FND_MSG_PUB.ADD;

5465: x_return_status := FND_API.G_RET_STS_ERROR;
5466:
5467: l_error_code := 'IBY_PPR_LOCKED';
5468: FND_MESSAGE.set_name('IBY', l_error_code);
5469: FND_MSG_PUB.ADD;
5470:
5471: --FND_MSG_PUB.COUNT_AND_GET(
5472: -- p_count => x_msg_count,
5473: -- p_data => x_msg_data

Line 5471: --FND_MSG_PUB.COUNT_AND_GET(

5467: l_error_code := 'IBY_PPR_LOCKED';
5468: FND_MESSAGE.set_name('IBY', l_error_code);
5469: FND_MSG_PUB.ADD;
5470:
5471: --FND_MSG_PUB.COUNT_AND_GET(
5472: -- p_count => x_msg_count,
5473: -- p_data => x_msg_data
5474: -- );
5475:

Line 5539: FND_MSG_PUB.ADD;

5535: END IF;
5536: x_return_status := FND_API.G_RET_STS_ERROR;
5537: l_error_code := 'IBY_PPR_TERM_NOT_ALLOWED';
5538: FND_MESSAGE.set_name('IBY', l_error_code);
5539: FND_MSG_PUB.ADD;
5540:
5541: ELSE
5542: /* Sanity Check to confirm if all the instructions
5543: * could be terminated

Line 5559: FND_MSG_PUB.ADD;

5555: END IF;
5556: x_return_status := FND_API.G_RET_STS_ERROR;
5557: l_error_code := 'IBY_PPR_TERM_NOT_ALLOWED';
5558: FND_MESSAGE.set_name('IBY', l_error_code);
5559: FND_MSG_PUB.ADD;
5560: return;
5561: END IF;
5562: end loop;
5563:

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

5666: );
5667: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
5668: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
5669:
5670: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5671:
5672: /*
5673: * Propogate exception to caller.
5674: */

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

5749: );
5750: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
5751: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
5752:
5753: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5754:
5755: /*
5756: * Propogate exception to caller.
5757: */

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

5909:
5910: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
5911: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
5912:
5913: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5914:
5915: /*
5916: * Propogate exception to caller.
5917: */

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

5966:
5967: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
5968: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
5969: END IF;
5970: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
5971:
5972: x_return_status := FND_API.G_RET_STS_ERROR;
5973:
5974: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6036: FND_MSG_PUB.initialize;

6032: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6033: print_debuginfo(l_module_name, 'ENTER');
6034:
6035: END IF;
6036: FND_MSG_PUB.initialize;
6037:
6038: /*
6039: * STATUS CHANGE:
6040: *

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

6218: );
6219: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
6220: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
6221: END IF;
6222: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6223:
6224: x_error_buf := 'BUILD PROGRAM ERROR - RESUBMITTING PAYMENT'
6225: || ' REQUEST FAILED';
6226:

Line 6275: FND_MSG_PUB.initialize;

6271: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6272: print_debuginfo(l_module_name, 'ENTER');
6273:
6274: END IF;
6275: FND_MSG_PUB.initialize;
6276:
6277: /*
6278: * STATUS CHANGE:
6279: *

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

6389: );
6390: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
6391: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
6392: END IF;
6393: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6394:
6395: x_error_buf := 'PICP ERROR - RESUBMITTING PAYMENT'
6396: || ' INSTRUCTION FAILED';
6397:

Line 6523: FND_MSG_PUB.initialize;

6519: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6520: print_debuginfo(l_module_name, 'ENTER');
6521:
6522: END IF;
6523: FND_MSG_PUB.initialize;
6524:
6525: /*
6526: * STATUS CHANGE:
6527: *

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

6869:
6870: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
6871: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
6872:
6873: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6874:
6875: /*
6876: * Propogate exception to caller.
6877: */

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

6910:
6911: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
6912: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
6913: END IF;
6914: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
6915:
6916: x_return_status := FND_API.G_RET_STS_ERROR;
6917:
6918: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6997: FND_MSG_PUB.initialize;

6993: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6994: print_debuginfo(l_module_name, 'ENTER');
6995:
6996: END IF;
6997: FND_MSG_PUB.initialize;
6998:
6999: /*
7000: * STEP 0 .
7001: *

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

7127:
7128: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
7129: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
7130: END IF;
7131: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7132:
7133: x_return_status := FND_API.G_RET_STS_ERROR;
7134:
7135: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7189: FND_MSG_PUB.initialize;

7185: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7186: print_debuginfo(l_module_name, 'ENTER');
7187:
7188: END IF;
7189: FND_MSG_PUB.initialize;
7190:
7191: /*
7192: * STEP 1:
7193: *

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

7276:
7277: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
7278: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
7279: END IF;
7280: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
7281:
7282: x_return_status := FND_API.G_RET_STS_ERROR;
7283:
7284: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8180: FND_MSG_PUB.initialize;

8176:
8177: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8178: print_debuginfo(l_module_name, 'ENTER');
8179: END IF;
8180: FND_MSG_PUB.initialize;
8181:
8182: IF (p_submit_postive_pay = 'TRUE') THEN
8183: l_submit_postive_pay := TRUE;
8184: ELSE

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

8527:
8528: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
8529: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
8530:
8531: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8532:
8533: /*
8534: * Propogate exception to caller.
8535: */

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

8622:
8623: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
8624: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
8625:
8626: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8627:
8628: /*
8629: * Propogate exception to caller.
8630: */

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

8767:
8768: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
8769: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
8770: END IF;
8771: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
8772:
8773: l_return_status := FND_API.G_RET_STS_ERROR;
8774: ROLLBACK;
8775: x_errbuf := 'RECORD PRINT STATUS COMPLETED IN ERRORS';

Line 9066: FND_MSG_PUB.initialize;

9062: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9063: print_debuginfo(l_module_name, 'ENTER');
9064:
9065: END IF;
9066: FND_MSG_PUB.initialize;
9067:
9068: iby_debug_pub.log(debug_msg => 'Enter Mark Complete: Timestamp:' || systimestamp,
9069: debug_level => FND_LOG.LEVEL_PROCEDURE,
9070: module => l_module_name);

Line 9674: FND_MSG_PUB.ADD;

9670: * Set the message on the error stack
9671: * to display in UI (in case of direct
9672: * API call from UI).
9673: */
9674: FND_MSG_PUB.ADD;
9675:
9676: /*
9677: * Set the error message on the concurrent
9678: * program output file (to warn user that

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

9679: * the hook failed).
9680: */
9681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
9682:
9683: --FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
9684:
9685: /*
9686: * Propogate exception to caller.
9687: */

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

10219:
10220: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
10221: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
10222: --END IF; Bug 14335525
10223: -- FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10224:
10225: x_return_status := FND_API.G_RET_STS_ERROR;
10226:
10227: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 10271: FND_MSG_PUB.initialize;

10267:
10268: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10269: print_debuginfo(l_module_name, 'ENTER');
10270: END IF;
10271: FND_MSG_PUB.initialize;
10272:
10273: x_return_status := FND_API.G_RET_STS_SUCCESS;
10274:
10275: -- Update payment transaction statuses (instruction, payments, etc.)

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

10320:
10321: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
10322: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
10323: END IF;
10324: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10325:
10326: x_return_status := FND_API.G_RET_STS_ERROR;
10327:
10328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 10705: FND_MSG_PUB.initialize;

10701: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10702: print_debuginfo(l_module_name, 'ENTER');
10703:
10704: END IF;
10705: FND_MSG_PUB.initialize;
10706:
10707: /*
10708: * Get the status of the provided payment instruction.
10709: */

Line 10740: FND_MSG_PUB.add;

10736:
10737: FND_MESSAGE.SET_TOKEN('INS_ID',
10738: p_instruction_id,
10739: FALSE);
10740: FND_MSG_PUB.add;
10741: x_return_message := FND_MESSAGE.get;
10742:
10743: /*
10744: * Propogate exception.

Line 10785: FND_MSG_PUB.add;

10781:
10782: FND_MESSAGE.SET_TOKEN('BAD_STATUS',
10783: l_instr_status,
10784: FALSE);
10785: FND_MSG_PUB.add;
10786: x_return_message := FND_MESSAGE.get;
10787:
10788: APP_EXCEPTION.RAISE_EXCEPTION;
10789:

Line 10866: FND_MSG_PUB.add;

10862:
10863: FND_MESSAGE.SET_TOKEN('INS_ID',
10864: p_instruction_id,
10865: FALSE);
10866: FND_MSG_PUB.add;
10867: x_return_message := FND_MESSAGE.get;
10868:
10869: /*
10870: * Propagate exception.

Line 10947: FND_MSG_PUB.add;

10943:
10944: FND_MESSAGE.SET_TOKEN('INS_ID',
10945: p_instruction_id,
10946: FALSE);
10947: FND_MSG_PUB.add;
10948: x_return_message := FND_MESSAGE.get;
10949:
10950:
10951: print_debuginfo(l_module_name, 'Extract and '

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

10988: || SQLCODE);
10989: print_debuginfo(l_module_name, 'SQL err msg: '
10990: || SQLERRM);
10991: END IF;
10992: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
10993:
10994: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10995: print_debuginfo(l_module_name, 'Returning failure response .. '
10996: );

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

11263: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
11264: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
11265:
11266: END IF;
11267: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11268: x_return_status := FND_API.G_RET_STS_ERROR;
11269:
11270: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11271: print_debuginfo(l_module_name, 'EXIT');

Line 11341: FND_MSG_PUB.initialize;

11337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11338: print_debuginfo(l_module_name, 'ENTER');
11339:
11340: END IF;
11341: FND_MSG_PUB.initialize;
11342:
11343: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11344: print_debuginfo(l_module_name, 'Input params - '
11345: || 'object id: '

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

11533: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
11534: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
11535:
11536: END IF;
11537: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11538:
11539: ROLLBACK;
11540:
11541: x_return_status := FND_API.G_RET_STS_ERROR;

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

11683: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
11684: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
11685:
11686: END IF;
11687: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11688:
11689: ROLLBACK;
11690:
11691: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11735: FND_MSG_PUB.initialize;

11731: where lookup_type='IBY_PAYMENT_FUNCTIONS';
11732:
11733: begin
11734:
11735: FND_MSG_PUB.initialize;
11736:
11737: -- first check whether the payment function is populated or not
11738: begin
11739: select count(1)

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

11787: || SQLERRM);
11788: print_debuginfo(l_module_name, 'Returning failure response .. '
11789: );
11790: END IF;
11791: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11792: /*
11793: * The error message would have already been set.
11794: * Just set the error status here.
11795: */

Line 11904: FND_MSG_PUB.initialize;

11900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11901: print_debuginfo(l_module_name, 'ENTER');
11902:
11903: END IF;
11904: FND_MSG_PUB.initialize;
11905: populatePaymentFunctions(x_return_status, x_return_message);
11906: x_access_flag:='N';
11907:
11908: /* Initialize return status */

Line 11954: FND_MSG_PUB.add;

11950: end if;
11951:
11952:
11953: FND_MESSAGE.set_name('IBY', l_message_code);
11954: FND_MSG_PUB.add;
11955:
11956: x_return_status := FND_API.G_RET_STS_ERROR;
11957:
11958: FND_MSG_PUB.Count_And_Get(

Line 11958: FND_MSG_PUB.Count_And_Get(

11954: FND_MSG_PUB.add;
11955:
11956: x_return_status := FND_API.G_RET_STS_ERROR;
11957:
11958: FND_MSG_PUB.Count_And_Get(
11959: p_encoded => FND_API.G_FALSE,
11960: p_count => l_msg_count,
11961: p_data => x_return_message
11962: );

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

11976: || SQLERRM);
11977: print_debuginfo(l_module_name, 'Returning failure response .. '
11978: );
11979: END IF;
11980: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
11981: /*
11982: * The error message would have already been set.
11983: * Just set the error status here.
11984: */

Line 12367: FND_MSG_PUB.initialize;

12363:
12364: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12365: print_debuginfo(l_module_name, 'ENTER');
12366: END IF;
12367: FND_MSG_PUB.initialize;
12368:
12369: /*
12370: * STEP 1:
12371: *

Line 12827: FND_MSG_PUB.initialize;

12823: print_debuginfo(l_module_name, 'ENTER');
12824:
12825: END IF;
12826: x_return_status := FND_API.G_RET_STS_SUCCESS;
12827: FND_MSG_PUB.initialize;
12828:
12829: /* set the context for the request set IBY_SECURITY_MASKING_REQ_SET */
12830: l_success := fnd_submit.set_request_set('IBY', 'IBY_SECURITY_MASKING_REQ_SET');
12831: l_phase := 'After set request set.';

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

12869: x_return_status := FND_API.G_RET_STS_ERROR;
12870: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12871: print_debuginfo(l_module_name, 'Exception submit_failed - ' || l_phase);
12872: END IF;
12873: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
12874:
12875: WHEN others THEN
12876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12877: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

12878: print_debuginfo(l_module_name, 'Exception others.');
12879: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
12880: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
12881: END IF;
12882: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
12883:
12884: END submit_masking_req_set;
12885:
12886: -- The procedure to submit a request set

Line 12928: FND_MSG_PUB.initialize;

12924: print_debuginfo(l_module_name, 'ENTER');
12925:
12926: END IF;
12927: x_return_status := FND_API.G_RET_STS_SUCCESS;
12928: FND_MSG_PUB.initialize;
12929:
12930: /* set the context for the request set IBY_SECURITY_DECRYPT_REQ_SET */
12931: l_success := fnd_submit.set_request_set('IBY', 'IBY_SECURITY_DECRYPT_REQ_SET');
12932: l_phase := 'After set request set.';

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

12994: x_return_status := FND_API.G_RET_STS_ERROR;
12995: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12996: print_debuginfo(l_module_name, 'Exception submit_failed - ' || l_phase);
12997: END IF;
12998: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
12999:
13000: WHEN others THEN
13001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13002: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

13003: print_debuginfo(l_module_name, 'Exception others.');
13004: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
13005: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);
13006: END IF;
13007: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
13008:
13009: END submit_decrypt_req_set;
13010:
13011: /*--------------------------------------------------------------------

Line 13125: FND_MSG_PUB.initialize;

13121: print_debuginfo(l_module_name, 'ENTER');
13122: print_debuginfo(l_module_name, 'completion id: ' || p_completion_id);
13123:
13124: END IF;
13125: FND_MSG_PUB.initialize;
13126:
13127: OPEN c_pmt_ids (p_completion_id);
13128: FETCH c_pmt_ids BULK COLLECT INTO l_pmts_list;
13129: CLOSE c_pmt_ids;

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

13173:
13174: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
13175: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
13176: END IF;
13177: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
13178:
13179: END print_completed_pmts;
13180:
13181:

Line 13236: FND_MSG_PUB.initialize;

13232: print_debuginfo(l_module_name, 'ENTER');
13233: print_debuginfo(l_module_name, 'completion id: ' || p_completion_id);
13234:
13235: END IF;
13236: FND_MSG_PUB.initialize;
13237:
13238: OPEN c_doc_ids (p_completion_id);
13239: FETCH c_doc_ids BULK COLLECT INTO l_docs_list;
13240: CLOSE c_doc_ids;

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

13284:
13285: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
13286: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
13287: END IF;
13288: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
13289:
13290: END print_completed_docs;
13291:
13292:

Line 13374: FND_MSG_PUB.initialize;

13370: END IF;
13371: --Initializing the out parameter
13372: x_inaccessible_entities :='N';
13373:
13374: FND_MSG_PUB.initialize;
13375:
13376: /*Initializing security through CE for populating the
13377: ce related global tables*/
13378: CEP_STANDARD.init_security();

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

13479: || SQLERRM);
13480: print_debuginfo(l_module_name, 'Returning failure response .. '
13481: );
13482: END IF;
13483: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
13484: /*
13485: * The error message would have already been set.
13486: * Just set the error status here.
13487: */