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.PON_EMD_AR_INTEGRATION_GRP dependencies on FND_MSG_PUB

Line 246: FND_MSG_PUB.initialize();

242: END IF;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean(p_init_msg_list) THEN
246: FND_MSG_PUB.initialize();
247: END IF;
248:
249: --Call to AR API
250: l_progress := 100;

Line 393: FND_MSG_PUB.ADD;

389: print_log('x_return_status: '||x_return_status);
390:
391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: FND_MESSAGE.SET_NAME('PON','EMD_DEPOSIT_CREATION_FAILED');
393: FND_MSG_PUB.ADD;
394: RETURN;
395: END IF;
396:
397: IF (x_new_trx_number IS null) THEN

Line 400: FND_MSG_PUB.ADD;

396:
397: IF (x_new_trx_number IS null) THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: FND_MESSAGE.SET_NAME('PON','EMD_DEPOSIT_CREATION_FAILED');
400: FND_MSG_PUB.ADD;
401: RETURN;
402: END IF;
403:
404: --Setting out parameters

Line 530: FND_MSG_PUB.initialize();

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean(p_init_msg_list) THEN
530: FND_MSG_PUB.initialize();
531: END IF;
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533: --Call to AR create_cash API
534: l_progress := 100;

Line 610: FND_MSG_PUB.ADD;

606:
607: --Setting out parameters
608: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
609: FND_MESSAGE.SET_NAME('PON','RECEIPT_CRE_AND_APPLY_FAILED');
610: FND_MSG_PUB.ADD;
611: RETURN;
612: END IF;
613:
614: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 688: FND_MSG_PUB.initialize();

684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: IF FND_API.to_Boolean(p_init_msg_list) THEN
688: FND_MSG_PUB.initialize();
689: END IF;
690:
691:
692: l_cash_receipt_id := p_in_rec.cash_receipt_id;

Line 734: FND_MSG_PUB.ADD;

730: print_log('x_return_status: '||x_return_status);
731:
732: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
733: FND_MESSAGE.SET_NAME('PON','UNAPPLY_EMD_RECEIPT_FAILED');
734: FND_MSG_PUB.ADD;
735: RETURN;
736: END IF;
737: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
738: x_out_rec.receipt_id := l_cash_receipt_id;

Line 841: FND_MSG_PUB.initialize();

837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:
840: IF FND_API.to_Boolean(p_init_msg_list) THEN
841: FND_MSG_PUB.initialize();
842: END IF;
843:
844: x_return_status := fnd_api.g_ret_sts_success;
845:

Line 879: FND_MSG_PUB.ADD;

875: WHEN No_Data_Found THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877: fnd_message.set_name('PON','REC_ACT_OF_REFUND_TYPE_NOT_DEF');
878: fnd_message.set_token('ORG',l_organization_name);
879: FND_MSG_PUB.ADD;
880: RETURN;
881: END;
882: ELSIF(l_applied_payment_schedule_id = -6 ) THEN
883: BEGIN

Line 894: FND_MSG_PUB.ADD;

890: WHEN No_Data_Found THEN
891: x_return_status := fnd_api.g_ret_sts_error;
892: fnd_message.set_name('PON','REC_ACT_FOR_CCREFUND_NOT_DEF');
893: fnd_message.set_token('ORG',l_organization_name);
894: FND_MSG_PUB.ADD;
895: RETURN;
896: END;
897: END IF;
898:

Line 965: FND_MSG_PUB.ADD;

961:
962: IF(l_application_ref_id IS null) THEN
963: x_return_status := fnd_api.g_ret_sts_error;
964: FND_MESSAGE.SET_NAME('PON','EMD_REFUND_TRX_FAILED');
965: FND_MSG_PUB.ADD;
966: RETURN;
967: END IF;
968: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
969: x_out_rec.application_ref_id := l_application_ref_id;

Line 1073: FND_MSG_PUB.initialize();

1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:
1072: IF FND_API.to_Boolean(p_init_msg_list) THEN
1073: FND_MSG_PUB.initialize();
1074: END IF;
1075: x_return_status := fnd_api.g_ret_sts_success;
1076:
1077: l_customer_trx_id := p_in_rec.customer_trx_id;

Line 1118: FND_MSG_PUB.ADD;

1114: WHEN No_Data_Found THEN
1115: x_return_status := fnd_api.g_ret_sts_success;
1116: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_DEF');
1117: FND_MESSAGE.SET_TOKEN('BATCH_SOURCE_ID',To_Char(p_in_rec.batch_source_id));
1118: FND_MSG_PUB.ADD;
1119: RETURN;
1120: END;
1121:
1122: print_log('l_batch_source_name: '||l_batch_source_name);

Line 1204: FND_MSG_PUB.ADD;

1200: x_out_rec.cm_customer_trx_id := x_cm_customer_trx_id;
1201: ELSE
1202: x_return_status := fnd_api.g_ret_sts_error;
1203: FND_MESSAGE.SET_NAME('PON','CM_CREATION_FAILED');
1204: FND_MSG_PUB.ADD;
1205: RETURN;
1206: END IF;
1207: ELSE
1208: FND_MESSAGE.SET_NAME('PON','CM_CREATION_FAILED');

Line 1209: FND_MSG_PUB.ADD;

1205: RETURN;
1206: END IF;
1207: ELSE
1208: FND_MESSAGE.SET_NAME('PON','CM_CREATION_FAILED');
1209: FND_MSG_PUB.ADD;
1210: RETURN;
1211: END IF;
1212:
1213: IF FND_API.To_Boolean( p_commit ) THEN

Line 1277: FND_MSG_PUB.initialize();

1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: IF FND_API.to_Boolean(p_init_msg_list) THEN
1277: FND_MSG_PUB.initialize();
1278: END IF;
1279:
1280: x_return_status := fnd_api.g_ret_sts_success;
1281:

Line 1327: FND_MSG_PUB.ADD;

1323:
1324: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1325: FND_MESSAGE.SET_NAME('PON','CUST_ACC_CRE_FAILED');
1326: FND_MESSAGE.SET_TOKEN('SUPPLIER',p_in_rec.party_name);
1327: FND_MSG_PUB.ADD;
1328: RETURN;
1329: END IF;
1330:
1331: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1402: FND_MSG_PUB.initialize();

1398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1399: END IF;
1400:
1401: IF FND_API.to_Boolean(p_init_msg_list) THEN
1402: FND_MSG_PUB.initialize();
1403: END IF;
1404:
1405: /* Initializing l_cust_account_site_rec */
1406: l_cust_acct_site_rec.cust_account_id := p_in_rec.cust_account_id;

Line 1426: FND_MSG_PUB.ADD;

1422: IF (x_site_return_status = fnd_api.g_ret_sts_error) THEN
1423: x_return_status := fnd_api.g_ret_sts_error;
1424: FND_MESSAGE.SET_NAME('PON','CUST_ACC_SITE_CRE_FAILED');
1425: FND_MESSAGE.SET_TOKEN('SUPPLIER',p_in_rec.party_name);
1426: FND_MSG_PUB.ADD;
1427: RETURN;
1428: END IF;
1429:
1430:

Line 1462: FND_MSG_PUB.ADD;

1458: IF (x_site_return_status = fnd_api.g_ret_sts_error) THEN
1459: x_return_status := fnd_api.g_ret_sts_error;
1460: FND_MESSAGE.SET_NAME('PON','CUST_ACC_SITE_USG_CRE_FAILED');
1461: FND_MESSAGE.SET_TOKEN('SUPPLIER',p_in_rec.party_name);
1462: FND_MSG_PUB.ADD;
1463: RETURN;
1464: END IF;
1465:
1466: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1597: FND_MSG_PUB.initialize();

1593: update_trx_status_lookup_code(l_emd_transactions_info.emd_transaction_id);
1594: print_log('After updating errored record status to receiving');
1595: END IF;
1596:
1597: FND_MSG_PUB.initialize();
1598:
1599: SAVEPOINT pon_emd_deposit_transaction;
1600: x_return_status := FND_API.G_RET_STS_SUCCESS;
1601: print_log('Started emd deposit transaction Processing of emd transaction id:

Line 1617: FND_MSG_PUB.ADD;

1613: WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MESSAGE.SET_NAME('PON','ORG_CONTEXT_CANNOT_SET');
1616: FND_MESSAGE.SET_TOKEN('ORG_ID',To_Char(l_org_id));
1617: FND_MSG_PUB.ADD;
1618: RAISE SETUP_EXCEPTION;
1619: END;
1620:
1621: l_progress := 110;

Line 1643: FND_MSG_PUB.ADD;

1639: IF NOT l_found THEN
1640: CLOSE pon_emd_fin_parameters;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: FND_MESSAGE.SET_NAME('PON','PON_EMD_FIN_PARAMS_NOT_SETUP');
1643: FND_MSG_PUB.ADD;
1644: RAISE SETUP_EXCEPTION;
1645: ELSE
1646: CLOSE pon_emd_fin_parameters;
1647: END IF;

Line 1687: FND_MSG_PUB.ADD;

1683: CLOSE payment_type_info;
1684: x_return_status := FND_API.G_RET_STS_ERROR;
1685: FND_MESSAGE.SET_NAME('PON','EMD_PAYMENT_TYPE_NOT_SETUP');
1686: FND_MESSAGE.SET_TOKEN('PTYPE_CODE',l_emd_transactions_info.payment_type_code);
1687: FND_MSG_PUB.ADD;
1688: RAISE SETUP_EXCEPTION;
1689: END IF;
1690: print_log('After executing cursor payment_type_info');
1691: print_log('x_return_status: '||x_return_status);

Line 2016: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2012: EXCEPTION
2013: WHEN No_Data_Found THEN
2014: print_log('inside no data found exception');
2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2017: p_count => x_msg_count,
2018: p_data => x_msg_data);
2019: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2020: l_searched := fnd_msg_pub.delete_msg;

Line 2019: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2017: p_count => x_msg_count,
2018: p_data => x_msg_data);
2019: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2020: l_searched := fnd_msg_pub.delete_msg;
2021: print_log('x_msg_count: '||x_msg_count);
2022: IF (x_msg_count > 1) THEN
2023: l_count := x_msg_count;

Line 2020: l_searched := fnd_msg_pub.delete_msg;

2016: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2017: p_count => x_msg_count,
2018: p_data => x_msg_data);
2019: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2020: l_searched := fnd_msg_pub.delete_msg;
2021: print_log('x_msg_count: '||x_msg_count);
2022: IF (x_msg_count > 1) THEN
2023: l_count := x_msg_count;
2024: x_msg_data := NULL;

Line 2027: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2023: l_count := x_msg_count;
2024: x_msg_data := NULL;
2025: LOOP
2026: IF nvl(l_count, 0) > 0 THEN
2027: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2028: x_msg_data := x_msg_data ||' '|| l_msg_data;
2029: l_count := nvl(l_count, 0) - 1;
2030: ELSE
2031: EXIT;

Line 2042: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2038: x_msg_data);
2039: WHEN TRANSACTION_EXCEPTION THEN
2040: print_log('inside trx exception');
2041: x_return_status := FND_API.G_RET_STS_ERROR;
2042: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2043: p_count => x_msg_count,
2044: p_data => x_msg_data);
2045: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2046: l_searched := fnd_msg_pub.delete_msg;

Line 2045: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2041: x_return_status := FND_API.G_RET_STS_ERROR;
2042: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2043: p_count => x_msg_count,
2044: p_data => x_msg_data);
2045: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2046: l_searched := fnd_msg_pub.delete_msg;
2047: print_log('x_msg_count: '||x_msg_count);
2048: IF (x_msg_count > 1) THEN
2049: l_count := x_msg_count;

Line 2046: l_searched := fnd_msg_pub.delete_msg;

2042: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2043: p_count => x_msg_count,
2044: p_data => x_msg_data);
2045: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2046: l_searched := fnd_msg_pub.delete_msg;
2047: print_log('x_msg_count: '||x_msg_count);
2048: IF (x_msg_count > 1) THEN
2049: l_count := x_msg_count;
2050: x_msg_data := NULL;

Line 2053: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2049: l_count := x_msg_count;
2050: x_msg_data := NULL;
2051: LOOP
2052: IF nvl(l_count, 0) > 0 THEN
2053: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2054: x_msg_data := x_msg_data ||' '|| l_msg_data;
2055: l_count := nvl(l_count, 0) - 1;
2056: ELSE
2057: EXIT;

Line 2070: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2066:
2067: WHEN SETUP_EXCEPTION THEN
2068: print_log('inside setup exception');
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data);
2073: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2074: l_searched := fnd_msg_pub.delete_msg;

Line 2073: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data);
2073: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2074: l_searched := fnd_msg_pub.delete_msg;
2075: print_log('x_msg_count: '||x_msg_count);
2076: IF (x_msg_count > 1) THEN
2077: l_count := x_msg_count;

Line 2074: l_searched := fnd_msg_pub.delete_msg;

2070: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data);
2073: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2074: l_searched := fnd_msg_pub.delete_msg;
2075: print_log('x_msg_count: '||x_msg_count);
2076: IF (x_msg_count > 1) THEN
2077: l_count := x_msg_count;
2078: x_msg_data := NULL;

Line 2081: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2077: l_count := x_msg_count;
2078: x_msg_data := NULL;
2079: LOOP
2080: IF nvl(l_count, 0) > 0 THEN
2081: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2082: x_msg_data := x_msg_data ||' '|| l_msg_data;
2083: l_count := nvl(l_count, 0) - 1;
2084: ELSE
2085: EXIT;

Line 2096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2092: x_msg_data);
2093: WHEN OTHERS THEN
2094: print_log('inside others exception');
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2097: p_count => x_msg_count,
2098: p_data => x_msg_data);
2099: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2100: l_searched := fnd_msg_pub.delete_msg;

Line 2099: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2097: p_count => x_msg_count,
2098: p_data => x_msg_data);
2099: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2100: l_searched := fnd_msg_pub.delete_msg;
2101: print_log('x_msg_count: '||x_msg_count);
2102: IF (x_msg_count > 1) THEN
2103: l_count := x_msg_count;

Line 2100: l_searched := fnd_msg_pub.delete_msg;

2096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2097: p_count => x_msg_count,
2098: p_data => x_msg_data);
2099: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2100: l_searched := fnd_msg_pub.delete_msg;
2101: print_log('x_msg_count: '||x_msg_count);
2102: IF (x_msg_count > 1) THEN
2103: l_count := x_msg_count;
2104: x_msg_data := NULL;

Line 2107: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2103: l_count := x_msg_count;
2104: x_msg_data := NULL;
2105: LOOP
2106: IF nvl(l_count, 0) > 0 THEN
2107: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2108: x_msg_data := x_msg_data ||' '|| l_msg_data;
2109: l_count := nvl(l_count, 0) - 1;
2110: ELSE
2111: EXIT;

Line 2248: FND_MSG_PUB.initialize();

2244: update_trx_status_lookup_code(l_emd_transactions_info.emd_transaction_id);
2245: print_log('After updating errored record status to refunding');
2246: END IF;
2247:
2248: FND_MSG_PUB.initialize();
2249:
2250: SAVEPOINT pon_emd_refund_transaction;
2251:
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2268: FND_MSG_PUB.ADD;

2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: FND_MESSAGE.SET_NAME('PON','ORG_CONTEXT_CANNOT_SET');
2267: FND_MESSAGE.SET_TOKEN('ORG_ID',To_Char(l_org_id));
2268: FND_MSG_PUB.ADD;
2269: RAISE SETUP_EXCEPTION;
2270: END;
2271:
2272: l_progress := 110;

Line 2294: FND_MSG_PUB.ADD;

2290: IF NOT l_found THEN
2291: CLOSE pon_emd_fin_parameters;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: FND_MESSAGE.SET_NAME('PON','PON_EMD_FIN_PARAMS_NOT_SETUP');
2294: FND_MSG_PUB.ADD;
2295: RAISE SETUP_EXCEPTION;
2296: ELSE
2297: CLOSE pon_emd_fin_parameters;
2298: END IF;

Line 2329: FND_MSG_PUB.ADD;

2325: l_progress := 140;
2326: print_log('l_emd_transactions_info.parent_emd_transaction_id:'||l_emd_transactions_info.parent_emd_transaction_id);
2327: IF (l_emd_transactions_info.parent_emd_transaction_id IS NULL) THEN
2328: FND_MESSAGE.SET_NAME('PON','PARENT_EMD_TRX_ID_NULL');
2329: FND_MSG_PUB.ADD;
2330: RAISE TRANSACTION_EXCEPTION;
2331: ELSE
2332: BEGIN
2333: print_log('Begin getTrxInfoFromParentTrx');

Line 2381: FND_MSG_PUB.ADD;

2377: CLOSE payment_type_info;
2378: x_return_status := FND_API.G_RET_STS_ERROR;
2379: FND_MESSAGE.SET_NAME('PON','EMD_PAYMENT_TYPE_NOT_SETUP');
2380: FND_MESSAGE.SET_TOKEN('PTYPE_CODE',l_deposit_payment_type_code);
2381: FND_MSG_PUB.ADD;
2382: RAISE SETUP_EXCEPTION;
2383: END IF;
2384: print_log('After executing cursor payment_type_info');
2385: print_log('x_return_status: '||x_return_status);

Line 2637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2633: EXCEPTION
2634: WHEN No_Data_Found THEN
2635: print_log('inside no data found exception');
2636: x_return_status := FND_API.G_RET_STS_ERROR;
2637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data);
2640: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2641: l_searched := fnd_msg_pub.delete_msg;

Line 2640: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2636: x_return_status := FND_API.G_RET_STS_ERROR;
2637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data);
2640: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2641: l_searched := fnd_msg_pub.delete_msg;
2642: print_log('x_msg_count: '||x_msg_count);
2643: IF (x_msg_count > 1) THEN
2644: l_count := x_msg_count;

Line 2641: l_searched := fnd_msg_pub.delete_msg;

2637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data);
2640: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2641: l_searched := fnd_msg_pub.delete_msg;
2642: print_log('x_msg_count: '||x_msg_count);
2643: IF (x_msg_count > 1) THEN
2644: l_count := x_msg_count;
2645: x_msg_data := NULL;

Line 2648: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2644: l_count := x_msg_count;
2645: x_msg_data := NULL;
2646: LOOP
2647: IF nvl(l_count, 0) > 0 THEN
2648: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2649: x_msg_data := x_msg_data ||' '|| l_msg_data;
2650: l_count := nvl(l_count, 0) - 1;
2651: ELSE
2652: EXIT;

Line 2663: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2659: x_msg_data);
2660: WHEN TRANSACTION_EXCEPTION THEN
2661: print_log('inside trx exception');
2662: x_return_status := FND_API.G_RET_STS_ERROR;
2663: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2667: l_searched := fnd_msg_pub.delete_msg;

Line 2666: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2662: x_return_status := FND_API.G_RET_STS_ERROR;
2663: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2667: l_searched := fnd_msg_pub.delete_msg;
2668: print_log('x_msg_count: '||x_msg_count);
2669: IF (x_msg_count > 1) THEN
2670: l_count := x_msg_count;

Line 2667: l_searched := fnd_msg_pub.delete_msg;

2663: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2667: l_searched := fnd_msg_pub.delete_msg;
2668: print_log('x_msg_count: '||x_msg_count);
2669: IF (x_msg_count > 1) THEN
2670: l_count := x_msg_count;
2671: x_msg_data := NULL;

Line 2674: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2670: l_count := x_msg_count;
2671: x_msg_data := NULL;
2672: LOOP
2673: IF nvl(l_count, 0) > 0 THEN
2674: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2675: x_msg_data := x_msg_data ||' '|| l_msg_data;
2676: l_count := nvl(l_count, 0) - 1;
2677: ELSE
2678: EXIT;

Line 2689: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2685: x_msg_data);
2686: WHEN SETUP_EXCEPTION THEN
2687: print_log('inside setup exception');
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2690: p_count => x_msg_count,
2691: p_data => x_msg_data);
2692: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2693: l_searched := fnd_msg_pub.delete_msg;

Line 2692: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2690: p_count => x_msg_count,
2691: p_data => x_msg_data);
2692: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2693: l_searched := fnd_msg_pub.delete_msg;
2694: print_log('x_msg_count: '||x_msg_count);
2695: IF (x_msg_count > 1) THEN
2696: l_count := x_msg_count;

Line 2693: l_searched := fnd_msg_pub.delete_msg;

2689: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2690: p_count => x_msg_count,
2691: p_data => x_msg_data);
2692: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2693: l_searched := fnd_msg_pub.delete_msg;
2694: print_log('x_msg_count: '||x_msg_count);
2695: IF (x_msg_count > 1) THEN
2696: l_count := x_msg_count;
2697: x_msg_data := NULL;

Line 2700: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2696: l_count := x_msg_count;
2697: x_msg_data := NULL;
2698: LOOP
2699: IF nvl(l_count, 0) > 0 THEN
2700: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2701: x_msg_data := x_msg_data ||' '|| l_msg_data;
2702: l_count := nvl(l_count, 0) - 1;
2703: ELSE
2704: EXIT;

Line 2715: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2711: x_msg_data);
2712: WHEN OTHERS THEN
2713: print_log('inside others exception');
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2716: p_count => x_msg_count,
2717: p_data => x_msg_data);
2718: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2719: l_searched := fnd_msg_pub.delete_msg;

Line 2718: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2716: p_count => x_msg_count,
2717: p_data => x_msg_data);
2718: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2719: l_searched := fnd_msg_pub.delete_msg;
2720: print_log('x_msg_count: '||x_msg_count);
2721: IF (x_msg_count > 1) THEN
2722: l_count := x_msg_count;

Line 2719: l_searched := fnd_msg_pub.delete_msg;

2715: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2716: p_count => x_msg_count,
2717: p_data => x_msg_data);
2718: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
2719: l_searched := fnd_msg_pub.delete_msg;
2720: print_log('x_msg_count: '||x_msg_count);
2721: IF (x_msg_count > 1) THEN
2722: l_count := x_msg_count;
2723: x_msg_data := NULL;

Line 2726: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

2722: l_count := x_msg_count;
2723: x_msg_data := NULL;
2724: LOOP
2725: IF nvl(l_count, 0) > 0 THEN
2726: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
2727: x_msg_data := x_msg_data ||' '|| l_msg_data;
2728: l_count := nvl(l_count, 0) - 1;
2729: ELSE
2730: EXIT;

Line 2869: FND_MSG_PUB.initialize();

2865: update_trx_status_lookup_code(l_emd_transactions_info.emd_transaction_id);
2866: print_log('After updating errored record status to forfeiting');
2867: END IF;
2868:
2869: FND_MSG_PUB.initialize();
2870:
2871: SAVEPOINT pon_emd_forfeit_transaction;
2872: x_return_status := FND_API.G_RET_STS_SUCCESS;
2873:

Line 2891: FND_MSG_PUB.ADD;

2887: WHEN OTHERS THEN
2888: x_return_status := FND_API.G_RET_STS_ERROR;
2889: FND_MESSAGE.SET_NAME('PON','ORG_CONTEXT_CANNOT_SET');
2890: FND_MESSAGE.SET_TOKEN('ORG_ID',To_Char(l_org_id));
2891: FND_MSG_PUB.ADD;
2892: RAISE SETUP_EXCEPTION;
2893: END;
2894:
2895: l_progress := 110;

Line 2918: FND_MSG_PUB.ADD;

2914: IF NOT l_found THEN
2915: CLOSE pon_emd_fin_parameters;
2916: x_return_status := FND_API.G_RET_STS_ERROR;
2917: FND_MESSAGE.SET_NAME('PON','PON_EMD_FIN_PARAMS_NOT_SETUP');
2918: FND_MSG_PUB.ADD;
2919: RAISE SETUP_EXCEPTION;
2920: ELSE
2921: CLOSE pon_emd_fin_parameters;
2922: END IF;

Line 2951: FND_MSG_PUB.ADD;

2947:
2948: l_progress := 140;
2949: IF (l_emd_transactions_info.parent_emd_transaction_id IS NULL) THEN
2950: FND_MESSAGE.SET_NAME('PON','PARENT_EMD_TRX_ID_NULL');
2951: FND_MSG_PUB.ADD;
2952: RAISE TRANSACTION_EXCEPTION;
2953: ELSE
2954: BEGIN
2955: getTrxInfoFromParentTrx(l_emd_transactions_info.parent_emd_transaction_id,

Line 3002: FND_MSG_PUB.ADD;

2998: CLOSE payment_type_info;
2999: x_return_status := FND_API.G_RET_STS_ERROR;
3000: FND_MESSAGE.SET_NAME('PON','EMD_PAYMENT_TYPE_NOT_SETUP');
3001: FND_MESSAGE.SET_TOKEN('PTYPE_CODE',l_deposit_payment_type_code);
3002: FND_MSG_PUB.ADD;
3003: RAISE SETUP_EXCEPTION;
3004: END IF;
3005:
3006: print_log('After executing cursor payment_type_info');

Line 3141: FND_MSG_PUB.ADD;

3137: EXCEPTION
3138: WHEN No_Data_Found THEN
3139: FND_MESSAGE.SET_NAME('PON','INV_TRX_TYPE_NOT_FOUND_IN_AR');
3140: FND_MESSAGE.SET_TOKEN('INV_TRX_TYPE_ID',To_Char(l_pon_emd_fin_parameters.RA_TRX_TYPE_ID));
3141: FND_MSG_PUB.ADD;
3142: x_return_status := FND_API.G_RET_STS_ERROR;
3143: WHEN OTHERS THEN
3144: FND_MESSAGE.SET_NAME('PON','INV_TRX_TYPE_NOT_FOUND_IN_AR');
3145: FND_MESSAGE.SET_TOKEN('INV_TRX_TYPE_ID',To_Char(l_pon_emd_fin_parameters.RA_TRX_TYPE_ID));

Line 3146: FND_MSG_PUB.ADD;

3142: x_return_status := FND_API.G_RET_STS_ERROR;
3143: WHEN OTHERS THEN
3144: FND_MESSAGE.SET_NAME('PON','INV_TRX_TYPE_NOT_FOUND_IN_AR');
3145: FND_MESSAGE.SET_TOKEN('INV_TRX_TYPE_ID',To_Char(l_pon_emd_fin_parameters.RA_TRX_TYPE_ID));
3146: FND_MSG_PUB.ADD;
3147: x_return_status := FND_API.G_RET_STS_ERROR;
3148: END;
3149: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3150: RAISE SETUP_EXCEPTION;

Line 3220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3216: EXCEPTION
3217: WHEN No_Data_Found THEN
3218: print_log('inside no data found');
3219: x_return_status := FND_API.G_RET_STS_ERROR;
3220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3224: l_searched := fnd_msg_pub.delete_msg;

Line 3223: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

3219: x_return_status := FND_API.G_RET_STS_ERROR;
3220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3224: l_searched := fnd_msg_pub.delete_msg;
3225: print_log('x_msg_count: '||x_msg_count);
3226: IF (x_msg_count > 1) THEN
3227: l_count := x_msg_count;

Line 3224: l_searched := fnd_msg_pub.delete_msg;

3220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3224: l_searched := fnd_msg_pub.delete_msg;
3225: print_log('x_msg_count: '||x_msg_count);
3226: IF (x_msg_count > 1) THEN
3227: l_count := x_msg_count;
3228: x_msg_data := NULL;

Line 3231: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

3227: l_count := x_msg_count;
3228: x_msg_data := NULL;
3229: LOOP
3230: IF nvl(l_count, 0) > 0 THEN
3231: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
3232: x_msg_data := x_msg_data ||' '|| l_msg_data;
3233: l_count := nvl(l_count, 0) - 1;
3234: ELSE
3235: EXIT;

Line 3246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3242: x_msg_data);
3243: WHEN TRANSACTION_EXCEPTION THEN
3244: print_log('inside trx exception');
3245: x_return_status := FND_API.G_RET_STS_ERROR;
3246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3247: p_count => x_msg_count,
3248: p_data => x_msg_data);
3249: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3250: l_searched := fnd_msg_pub.delete_msg;

Line 3249: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

3245: x_return_status := FND_API.G_RET_STS_ERROR;
3246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3247: p_count => x_msg_count,
3248: p_data => x_msg_data);
3249: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3250: l_searched := fnd_msg_pub.delete_msg;
3251: print_log('x_msg_count: '||x_msg_count);
3252: IF (x_msg_count > 1) THEN
3253: l_count := x_msg_count;

Line 3250: l_searched := fnd_msg_pub.delete_msg;

3246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3247: p_count => x_msg_count,
3248: p_data => x_msg_data);
3249: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3250: l_searched := fnd_msg_pub.delete_msg;
3251: print_log('x_msg_count: '||x_msg_count);
3252: IF (x_msg_count > 1) THEN
3253: l_count := x_msg_count;
3254: x_msg_data := NULL;

Line 3257: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

3253: l_count := x_msg_count;
3254: x_msg_data := NULL;
3255: LOOP
3256: IF nvl(l_count, 0) > 0 THEN
3257: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
3258: x_msg_data := x_msg_data ||' '|| l_msg_data;
3259: l_count := nvl(l_count, 0) - 1;
3260: ELSE
3261: EXIT;

Line 3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3268: x_msg_data);
3269: WHEN SETUP_EXCEPTION THEN
3270: print_log('inside setup exception');
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3276: l_searched := fnd_msg_pub.delete_msg;

Line 3275: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3276: l_searched := fnd_msg_pub.delete_msg;
3277: print_log('x_msg_count: '||x_msg_count);
3278: IF (x_msg_count > 1) THEN
3279: l_count := x_msg_count;

Line 3276: l_searched := fnd_msg_pub.delete_msg;

3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3276: l_searched := fnd_msg_pub.delete_msg;
3277: print_log('x_msg_count: '||x_msg_count);
3278: IF (x_msg_count > 1) THEN
3279: l_count := x_msg_count;
3280: x_msg_data := NULL;

Line 3283: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

3279: l_count := x_msg_count;
3280: x_msg_data := NULL;
3281: LOOP
3282: IF nvl(l_count, 0) > 0 THEN
3283: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
3284: x_msg_data := x_msg_data ||' '|| l_msg_data;
3285: l_count := nvl(l_count, 0) - 1;
3286: ELSE
3287: EXIT;

Line 3298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3294: x_msg_data);
3295: WHEN OTHERS THEN
3296: print_log('inside others exception');
3297: x_return_status := FND_API.G_RET_STS_ERROR;
3298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3299: p_count => x_msg_count,
3300: p_data => x_msg_data);
3301: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3302: l_searched := fnd_msg_pub.delete_msg;

Line 3301: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');

3297: x_return_status := FND_API.G_RET_STS_ERROR;
3298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3299: p_count => x_msg_count,
3300: p_data => x_msg_data);
3301: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3302: l_searched := fnd_msg_pub.delete_msg;
3303: print_log('x_msg_count: '||x_msg_count);
3304: IF (x_msg_count > 1) THEN
3305: l_count := x_msg_count;

Line 3302: l_searched := fnd_msg_pub.delete_msg;

3298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3299: p_count => x_msg_count,
3300: p_data => x_msg_data);
3301: fnd_msg_pub.set_search_name('AR','AR_DAPI_SOLD_CUST_DFT');
3302: l_searched := fnd_msg_pub.delete_msg;
3303: print_log('x_msg_count: '||x_msg_count);
3304: IF (x_msg_count > 1) THEN
3305: l_count := x_msg_count;
3306: x_msg_data := NULL;

Line 3309: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

3305: l_count := x_msg_count;
3306: x_msg_data := NULL;
3307: LOOP
3308: IF nvl(l_count, 0) > 0 THEN
3309: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
3310: x_msg_data := x_msg_data ||' '|| l_msg_data;
3311: l_count := nvl(l_count, 0) - 1;
3312: ELSE
3313: EXIT;

Line 3421: FND_MSG_PUB.ADD;

3417: WHEN No_Data_Found THEN
3418: x_return_status := fnd_api.g_ret_sts_error;
3419: FND_MESSAGE.SET_NAME('PON','SUPPLIER_SITE_NOT_FOUND');
3420:
3421: FND_MSG_PUB.ADD;
3422: RETURN;
3423: END;
3424:
3425: ELSE

Line 3701: FND_MSG_PUB.ADD;

3697: x_response);
3698: END IF;
3699: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3700: FND_MESSAGE.set_name( 'PON', 'BANK_CREATION_FAILED' );
3701: FND_MSG_PUB.ADD;
3702: RETURN;
3703: END IF;
3704:
3705: IF ((x_return_status =FND_API.G_RET_STS_SUCCESS) AND (x_bank_id IS NOT NULL) AND (x_branch_id IS NULL)) THEN

Line 3723: FND_MSG_PUB.ADD;

3719: END IF;
3720: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3721: FND_MESSAGE.set_name( 'PON', 'BANK_BRANCH_CREATION_FAILED' );
3722: FND_MESSAGE.SET_TOKEN('BANK',p_bank_name);
3723: FND_MSG_PUB.ADD;
3724: RETURN;
3725: END IF;
3726: IF ((x_return_status =FND_API.G_RET_STS_SUCCESS)
3727: AND (x_bank_id IS NOT NULL)

Line 3759: FND_MSG_PUB.ADD;

3755: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3756: FND_MESSAGE.set_name( 'PON', 'BANK_ACCOUNT_CREATION_FAILED' );
3757: FND_MESSAGE.SET_TOKEN('BANK', p_bank_name);
3758: FND_MESSAGE.SET_TOKEN('BRANCH',p_bank_branch_name);
3759: FND_MSG_PUB.ADD;
3760: RETURN;
3761: END IF;
3762:
3763: l_payer.Payment_Function := 'CUSTOMER_PAYMENT';

Line 4023: FND_MSG_PUB.ADD;

4019: Nvl(l_expiry_date,Trunc(SYSDATE)) < Trunc(SYSDATE)) THEN
4020: x_return_status := fnd_api.g_ret_sts_error;
4021: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_EXPIRED' );
4022: FND_MESSAGE.SET_TOKEN('CCNUM',To_Char(p_credit_card_num));
4023: FND_MSG_PUB.ADD;
4024: RETURN;
4025: END IF;
4026:
4027: IF (Nvl(l_card_exists,'N') = 'N') THEN

Line 4111: FND_MSG_PUB.ADD;

4107: IF (x_result_code = iby_creditcard_pkg.G_RC_INVALID_CCNUMBER) THEN
4108: x_return_status := fnd_api.g_ret_sts_error;
4109: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_NUMBER_NOT_VALID' );
4110: FND_MESSAGE.SET_TOKEN('CCNUM',l_card_number);
4111: FND_MSG_PUB.ADD;
4112: RETURN;
4113: ELSIF (x_result_code = iby_creditcard_pkg.G_RC_INVALID_CCEXPIRY) THEN
4114: x_return_status := fnd_api.g_ret_sts_error;
4115: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_EXPIRED' );

Line 4117: FND_MSG_PUB.ADD;

4113: ELSIF (x_result_code = iby_creditcard_pkg.G_RC_INVALID_CCEXPIRY) THEN
4114: x_return_status := fnd_api.g_ret_sts_error;
4115: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_EXPIRED' );
4116: FND_MESSAGE.SET_TOKEN('CCNUM',l_card_number);
4117: FND_MSG_PUB.ADD;
4118: RETURN;
4119: ELSIF (x_result_code = iby_creditcard_pkg.G_RC_INVALID_CARD_ISSUER) THEN
4120: x_return_status := fnd_api.g_ret_sts_error;
4121: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_ISSUER_NOT_VALID' );

Line 4123: FND_MSG_PUB.ADD;

4119: ELSIF (x_result_code = iby_creditcard_pkg.G_RC_INVALID_CARD_ISSUER) THEN
4120: x_return_status := fnd_api.g_ret_sts_error;
4121: FND_MESSAGE.set_name( 'PON', 'CREDIT_CARD_ISSUER_NOT_VALID' );
4122: FND_MESSAGE.SET_NAME('CCISSUER',l_issuer);
4123: FND_MSG_PUB.ADD;
4124: RETURN;
4125: END IF;
4126: END IF;
4127:

Line 4283: FND_MSG_PUB.ADD;

4279:
4280: EXCEPTION
4281: WHEN No_Data_Found THEN
4282: FND_MESSAGE.SET_NAME('PON','DEPOSIT_TRX_NOT_FOUND');
4283: FND_MSG_PUB.ADD;
4284: x_return_status := fnd_api.g_ret_sts_error;
4285: END getTrxInfoFromParentTrx;
4286:
4287: -----------------------------------------------------------------------

Line 4348: FND_MSG_PUB.ADD;

4344: WHEN NO_DATA_FOUND THEN
4345: x_return_status := FND_API.G_RET_STS_ERROR;
4346: FND_MESSAGE.SET_NAME('PON','RECEIPT_NOT_CRE_FOR_DEPOSIT');
4347: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM',p_parent_trx_number);
4348: FND_MSG_PUB.ADD;
4349: x_receipt_num := NULL;
4350: x_cash_receipt_id := NULL;
4351: x_receipt_status := NULL;
4352: RETURN;

Line 4375: FND_MSG_PUB.ADD;

4371: x_return_status := FND_API.G_RET_STS_ERROR;
4372: FND_MESSAGE.SET_NAME('PON','RECEIPT_NOT_CLEARED');
4373: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM',p_parent_trx_number);
4374: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_receipt_num);
4375: FND_MSG_PUB.ADD;
4376: x_receipt_num := NULL;
4377: x_cash_receipt_id := NULL;
4378: x_receipt_status := NULL;
4379: RETURN;

Line 4439: FND_MSG_PUB.ADD;

4435: EXCEPTION
4436: WHEN no_data_found THEN
4437: FND_MESSAGE.SET_NAME('PON','NEGOTIATION_NOT_FOUND');
4438: FND_MESSAGE.SET_TOKEN('AUCTION',l_document_num);
4439: FND_MSG_PUB.ADD;
4440: x_return_status := FND_API.G_RET_STS_ERROR;
4441: END;
4442:
4443: IF (l_auction_status <> 'ACTIVE') THEN

Line 4448: FND_MSG_PUB.ADD;

4444: IF (p_transaction_type_code NOT IN (G_EMD_FORFEIT,G_EMD_REFUND))
4445: THEN
4446: FND_MESSAGE.SET_NAME('PON','NEGOTIATION_NOT_ACTIVE');
4447: FND_MESSAGE.SET_TOKEN('AUCTION',l_document_num);
4448: FND_MSG_PUB.ADD;
4449: x_return_status := FND_API.G_RET_STS_ERROR;
4450: END IF;
4451: END IF;
4452:

Line 4457: FND_MSG_PUB.ADD;

4453:
4454: IF (p_emd_transaction_rec.transaction_date IS NULL ) THEN
4455: x_return_status := FND_API.G_RET_STS_ERROR;
4456: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_IS_NULL' );
4457: FND_MSG_PUB.ADD;
4458: RETURN;
4459: END IF;
4460: /*
4461: Relaxing the validation after discussing with PM

Line 4467: FND_MSG_PUB.ADD;

4463: IF (p_emd_transaction_rec.emd_due_date IS NOT null) THEN
4464: IF NOT (p_emd_transaction_rec.transaction_date <= p_emd_transaction_rec.emd_due_date) THEN
4465: x_return_status := FND_API.G_RET_STS_ERROR;
4466: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_EXC_EMD_DUE_DATE' );
4467: FND_MSG_PUB.ADD;
4468: RETURN;
4469: END IF;
4470: END IF;
4471: END IF;

Line 4478: FND_MSG_PUB.ADD;

4474: IF (p_emd_transaction_rec.emd_amount IS null) THEN
4475: x_return_status := FND_API.G_RET_STS_ERROR;
4476: FND_MESSAGE.set_name( 'PON', 'EMD_AMT_NULL_ON_NEG' );
4477: FND_MESSAGE.SET_TOKEN('AUCTION',l_document_num);
4478: FND_MSG_PUB.ADD;
4479: RETURN;
4480: END IF;
4481: END IF;
4482:

Line 4491: FND_MSG_PUB.ADD;

4487: IF NOT (arp_util.is_gl_date_valid(p_emd_transaction_rec.transaction_date)) THEN
4488: x_return_status := FND_API.G_RET_STS_ERROR;
4489: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_GL_PERIOD_O_F' );
4490: FND_MESSAGE.set_token('TRX_DATE',TO_CHAR(p_emd_transaction_rec.transaction_date));
4491: FND_MSG_PUB.ADD;
4492: RETURN;
4493: END IF;
4494:
4495: EXCEPTION

Line 4500: FND_MSG_PUB.ADD;

4496: WHEN No_Data_Found THEN
4497: x_return_status := FND_API.G_RET_STS_ERROR;
4498: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_GL_PERIOD_O_F' );
4499: FND_MESSAGE.set_token('TRX_DATE',TO_CHAR(p_emd_transaction_rec.transaction_date));
4500: FND_MSG_PUB.ADD;
4501: RETURN;
4502: WHEN OTHERS THEN
4503: x_return_status := FND_API.G_RET_STS_ERROR;
4504: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_GL_PERIOD_O_F' );

Line 4506: FND_MSG_PUB.ADD;

4502: WHEN OTHERS THEN
4503: x_return_status := FND_API.G_RET_STS_ERROR;
4504: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_GL_PERIOD_O_F' );
4505: FND_MESSAGE.set_token('TRX_DATE',TO_CHAR(p_emd_transaction_rec.transaction_date));
4506: FND_MSG_PUB.ADD;
4507: RETURN;
4508: END;
4509: -- Checking AP open period also in the case of refund.
4510: IF (p_transaction_type_code = G_EMD_REFUND) THEN

Line 4526: FND_MSG_PUB.ADD;

4522: WHEN No_Data_Found THEN
4523: x_return_status := FND_API.G_RET_STS_ERROR;
4524: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_AP_PERIOD_O_F' );
4525: FND_MESSAGE.set_token('TRX_DATE',TO_CHAR(p_emd_transaction_rec.transaction_date));
4526: FND_MSG_PUB.ADD;
4527: RETURN;
4528: WHEN OTHERS THEN
4529: x_return_status := FND_API.G_RET_STS_ERROR;
4530: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_AP_PERIOD_O_F' );

Line 4532: FND_MSG_PUB.ADD;

4528: WHEN OTHERS THEN
4529: x_return_status := FND_API.G_RET_STS_ERROR;
4530: FND_MESSAGE.set_name( 'PON', 'TRX_DATE_NOT_IN_AP_PERIOD_O_F' );
4531: FND_MESSAGE.set_token('TRX_DATE',TO_CHAR(p_emd_transaction_rec.transaction_date));
4532: FND_MSG_PUB.ADD;
4533: RETURN;
4534: END;
4535: END IF;
4536:

Line 4643: FND_MSG_PUB.ADD;

4639: IF (Nvl(p_emd_fin_integration,'N') <> 'Y') THEN
4640: x_return_status := fnd_api.g_ret_sts_error;
4641: FND_MESSAGE.SET_NAME('PON','PON_EMD_FIN_INTG_NOT_ENABLED');
4642: FND_MESSAGE.SET_TOKEN('ORG', l_organization_name);
4643: FND_MSG_PUB.ADD;
4644: RETURN;
4645: END IF;
4646:
4647: IF (p_ra_trx_type_id = NULL) THEN

Line 4650: FND_MSG_PUB.ADD;

4646:
4647: IF (p_ra_trx_type_id = NULL) THEN
4648: x_return_status := fnd_api.g_ret_sts_error;
4649: FND_MESSAGE.SET_NAME('PON','TRX_TYPE_NOT_IN_DEFINED_SETUP');
4650: FND_MSG_PUB.ADD;
4651: RETURN;
4652: END IF;
4653: print_log('p_transaction_type_code:'||p_transaction_type_code);
4654: IF (p_transaction_type_code = G_EMD_DEPOSIT) THEN

Line 4695: FND_MSG_PUB.ADD;

4691: EXCEPTION
4692: WHEN No_Data_Found THEN
4693: x_return_status := fnd_api.g_ret_sts_error;
4694: FND_MESSAGE.SET_NAME('PON','RA_TRX_TYPE_NOT_FOUND_IN_AR');
4695: FND_MSG_PUB.ADD;
4696: RETURN;
4697: END;
4698:
4699: IF NOT((Trunc(SYSDATE) >= l_start_date) AND

Line 4704: FND_MSG_PUB.ADD;

4700: (Trunc(SYSDATE) < Nvl(l_end_date,Trunc(SYSDATE + 1)))) THEN
4701: x_return_status := fnd_api.g_ret_sts_error;
4702: FND_MESSAGE.SET_NAME('PON','RA_TRX_TYPE_NOT_ACTIVE');
4703: FND_MESSAGE.set_token('TRX_TYPE',l_deposit_trx_name);
4704: FND_MSG_PUB.ADD;
4705: RETURN;
4706: END IF;
4707: IF( (Nvl(l_post_to_gl,'N') <> 'Y') OR
4708: (Nvl(l_accounting_affect_flag,'N') <> 'Y') OR

Line 4724: FND_MSG_PUB.ADD;

4720:
4721: x_return_status := fnd_api.g_ret_sts_error;
4722: FND_MESSAGE.SET_NAME('PON','TRX_TYPE_INFO_NOT_VALID');
4723: FND_MESSAGE.set_token('TRX_TYPE',l_deposit_trx_name);
4724: FND_MSG_PUB.ADD;
4725: RETURN;
4726: END IF;
4727: ELSIF (p_transaction_type_code = G_EMD_REFUND) THEN
4728: SELECT CREDIT_MEMO_TYPE_ID

Line 4737: FND_MSG_PUB.ADD;

4733: print_log('l_credit_memo_type_id:'||l_credit_memo_type_id);
4734: IF (l_credit_memo_type_id IS NULL) THEN
4735: x_return_status := fnd_api.g_ret_sts_error;
4736: FND_MESSAGE.SET_NAME('PON','CM_TYPE_NOT_IN_DEP_TRX_TYPE');
4737: FND_MSG_PUB.ADD;
4738: RETURN;
4739: ELSE
4740: SELECT TYPE,
4741: POST_TO_GL,

Line 4777: FND_MSG_PUB.ADD;

4773: (Trunc(SYSDATE) < Nvl(l_end_date,Trunc(SYSDATE + 1)))) THEN
4774: x_return_status := fnd_api.g_ret_sts_error;
4775: FND_MESSAGE.SET_NAME('PON','RA_TRX_TYPE_NOT_ACTIVE');
4776: FND_MESSAGE.set_token('TRX_TYPE',l_cm_trx_name);
4777: FND_MSG_PUB.ADD;
4778: RETURN;
4779: END IF;
4780:
4781: IF((Nvl(l_post_to_gl,'N') <> 'Y') OR

Line 4796: FND_MSG_PUB.ADD;

4792:
4793: x_return_status := fnd_api.g_ret_sts_error;
4794: FND_MESSAGE.SET_NAME('PON','CM_TRX_TYPE_INFO_NOT_VALID');
4795: FND_MESSAGE.set_token('TRX_TYPE',l_cm_trx_name);
4796: FND_MSG_PUB.ADD;
4797: RETURN;
4798: END IF;
4799: END IF;
4800: ELSIF (p_transaction_type_code = G_EMD_FORFEIT) THEN

Line 4810: FND_MSG_PUB.ADD;

4806:
4807: IF (l_subsequent_trx_type_id IS NULL) THEN
4808: x_return_status := fnd_api.g_ret_sts_error;
4809: FND_MESSAGE.SET_NAME('PON','INV_TYP_NOT_IN_DEP_TRX_TYP');
4810: FND_MSG_PUB.ADD;
4811: RETURN;
4812: ELSE
4813: SELECT TYPE,
4814: POST_TO_GL,

Line 4850: FND_MSG_PUB.ADD;

4846: (Trunc(SYSDATE) < Nvl(l_end_date,Trunc(SYSDATE + 1)))) THEN
4847: x_return_status := fnd_api.g_ret_sts_error;
4848: FND_MESSAGE.SET_NAME('PON','RA_TRX_TYPE_NOT_ACTIVE');
4849: FND_MESSAGE.set_token('TRX_TYPE',l_invoice_trx_name);
4850: FND_MSG_PUB.ADD;
4851: RETURN;
4852: END IF;
4853:
4854: IF((Nvl(l_post_to_gl,'N') <> 'Y') OR

Line 4869: FND_MSG_PUB.ADD;

4865:
4866: x_return_status := fnd_api.g_ret_sts_error;
4867: FND_MESSAGE.SET_NAME('PON','INV_TRX_TYPE_INFO_NOT_VALID');
4868: FND_MESSAGE.set_token('TRX_TYPE',l_invoice_trx_name);
4869: FND_MSG_PUB.ADD;
4870: RETURN;
4871: END IF;
4872: END IF;
4873: END IF;

Line 4886: FND_MSG_PUB.ADD;

4882:
4883: IF (l_ra_batch_source_id IS NULL) THEN
4884: x_return_status := fnd_api.g_ret_sts_error;
4885: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOUR_NOT_IN_SETUP');
4886: FND_MSG_PUB.ADD;
4887: RETURN;
4888: ELSE
4889: BEGIN
4890: SELECT NAME,

Line 4911: FND_MSG_PUB.ADD;

4907: EXCEPTION
4908: WHEN No_Data_Found THEN
4909: x_return_status := fnd_api.g_ret_sts_error;
4910: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_DEF');
4911: FND_MSG_PUB.ADD;
4912: RETURN;
4913: END;
4914: print_log('End of Select block');
4915:

Line 4928: FND_MSG_PUB.ADD;

4924: IF (l_batch_source_status <> 'A') THEN
4925: x_return_status := fnd_api.g_ret_sts_error;
4926: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_ACTIVE');
4927: fnd_message.set_token('BATCH_SOURCE',l_batch_source_name);
4928: FND_MSG_PUB.ADD;
4929: RETURN;
4930: END IF;
4931:
4932: IF ( (Nvl(l_auto_batch_numbering_flag,'N') <> 'Y') OR

Line 4943: FND_MSG_PUB.ADD;

4939: ) THEN
4940: x_return_status := fnd_api.g_ret_sts_error;
4941: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_INFO_NOT_VALID');
4942: FND_MESSAGE.SET_TOKEN('BATCH_SOURCE',l_batch_source_name);
4943: FND_MSG_PUB.ADD;
4944: RETURN;
4945: END IF;
4946: IF (l_credit_memo_batch_source_id IS NOT NULL AND
4947: l_credit_memo_batch_source_id <> l_ra_batch_source_id) THEN

Line 4968: FND_MSG_PUB.ADD;

4964: EXCEPTION
4965: WHEN No_Data_Found THEN
4966: x_return_status := fnd_api.g_ret_sts_error;
4967: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_DEF');
4968: FND_MSG_PUB.ADD;
4969: RETURN;
4970: END;
4971:
4972: IF (l_cr_batch_source_status <> 'A') THEN

Line 4976: FND_MSG_PUB.ADD;

4972: IF (l_cr_batch_source_status <> 'A') THEN
4973: x_return_status := fnd_api.g_ret_sts_error;
4974: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_ACTIVE');
4975: fnd_message.set_token('BATCH_SOURCE',l_credit_batch_source_name);
4976: FND_MSG_PUB.ADD;
4977: RETURN;
4978: END IF;
4979: IF ((Nvl(l_cr_auto_batch_numbering_flag,'N') <> 'Y') OR
4980: (Nvl(l_cr_auto_trx_numbering_flag,'N') <> 'Y') OR

Line 4986: FND_MSG_PUB.ADD;

4982: (l_cr_batch_source_type <> 'INV')) THEN
4983: x_return_status := fnd_api.g_ret_sts_error;
4984: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_INFO_NOT_VALID');
4985: FND_MESSAGE.SET_TOKEN('BATCH_SOURCE',l_credit_batch_source_name);
4986: FND_MSG_PUB.ADD;
4987: RETURN;
4988: END IF;
4989: END IF;
4990: END IF;

Line 4999: FND_MSG_PUB.ADD;

4995:
4996: IF (p_memo_line_id IS NULL) THEN
4997: x_return_status := fnd_api.g_ret_sts_error;
4998: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_NOT_IN_SETUP');
4999: FND_MSG_PUB.ADD;
5000: RETURN;
5001: ELSE
5002: BEGIN
5003: SELECT NAME,

Line 5020: FND_MSG_PUB.ADD;

5016: EXCEPTION
5017: WHEN No_Data_Found THEN
5018: x_return_status := fnd_api.g_ret_sts_error;
5019: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_NOT_DEF_IN_AR');
5020: FND_MSG_PUB.ADD;
5021: RETURN;
5022: END;
5023:
5024: IF NOT ((Trunc(SYSDATE) >= l_memo_line_start_date) AND

Line 5029: FND_MSG_PUB.ADD;

5025: (Trunc(SYSDATE) < Nvl(l_memo_line_end_date,Trunc(SYSDATE+1)))) THEN
5026: x_return_status := fnd_api.g_ret_sts_error;
5027: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_TYPE_NOT_ACTIVE');
5028: FND_MESSAGE.set_token('MEMO_LINE',l_memo_line_name);
5029: FND_MSG_PUB.ADD;
5030: RETURN;
5031: END IF;
5032:
5033: IF (l_memo_line_type <> 'LINE' OR

Line 5038: FND_MSG_PUB.ADD;

5034: l_memo_line_rev_acc IS NULL) THEN
5035: x_return_status := fnd_api.g_ret_sts_error;
5036: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_INFO_NOT_VALID');
5037: FND_MESSAGE.set_token('MEMO_LINE',l_memo_line_name);
5038: FND_MSG_PUB.ADD;
5039: RETURN;
5040: END IF;
5041: END IF;
5042: END IF;

Line 5048: FND_MSG_PUB.ADD;

5044: IF (p_transaction_type_code in (G_EMD_FORFEIT)) THEN
5045: IF (p_memo_line_invoice_id IS NULL) THEN
5046: x_return_status := fnd_api.g_ret_sts_error;
5047: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_NOT_IN_SETUP');
5048: FND_MSG_PUB.ADD;
5049: RETURN;
5050: ELSE
5051: BEGIN
5052: SELECT NAME,

Line 5069: FND_MSG_PUB.ADD;

5065: EXCEPTION
5066: WHEN No_Data_Found THEN
5067: x_return_status := fnd_api.g_ret_sts_error;
5068: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_NOT_DEF_IN_AR');
5069: FND_MSG_PUB.ADD;
5070: RETURN;
5071: END;
5072:
5073: IF NOT ((Trunc(SYSDATE) >= l_memo_line_start_date) AND

Line 5078: FND_MSG_PUB.ADD;

5074: (Trunc(SYSDATE) < Nvl(l_memo_line_end_date,Trunc(SYSDATE+1)))) THEN
5075: x_return_status := fnd_api.g_ret_sts_error;
5076: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_TYPE_NOT_ACTIVE');
5077: FND_MESSAGE.set_token('MEMO_LINE',l_memo_line_name);
5078: FND_MSG_PUB.ADD;
5079: RETURN;
5080: END IF;
5081:
5082: IF (l_memo_line_type <> 'LINE' OR

Line 5087: FND_MSG_PUB.ADD;

5083: l_memo_line_rev_acc IS NULL) THEN
5084: x_return_status := fnd_api.g_ret_sts_error;
5085: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_INFO_NOT_VALID');
5086: FND_MESSAGE.set_token('MEMO_LINE',l_memo_line_name);
5087: FND_MSG_PUB.ADD;
5088: RETURN;
5089: END IF;
5090: END IF;
5091: END IF;

Line 5097: FND_MSG_PUB.ADD;

5093: IF (p_transaction_type_code IN (G_EMD_DEPOSIT,G_EMD_FORFEIT)) THEN
5094: IF (p_payment_terms_id IS NULL) THEN
5095: x_return_status := fnd_api.g_ret_sts_error;
5096: FND_MESSAGE.SET_NAME('PON','PAYMENT_TERM_NOT_IN_SETUP');
5097: FND_MSG_PUB.ADD;
5098: RETURN;
5099: ELSE
5100: BEGIN
5101: SELECT rt.NAME,

Line 5122: FND_MSG_PUB.ADD;

5118: EXCEPTION
5119: WHEN No_Data_Found THEN
5120: x_return_status := fnd_api.g_ret_sts_error;
5121: FND_MESSAGE.SET_NAME('PON','PAYMENT_TERM_NOT_DEF_IN_AR');
5122: FND_MSG_PUB.ADD;
5123: RETURN;
5124: END;
5125: IF NOT ((Trunc(SYSDATE) >= l_term_start_date) AND
5126: (Trunc(SYSDATE) < Nvl(l_term_end_Date,Trunc(SYSDATE+1)))) THEN

Line 5130: FND_MSG_PUB.ADD;

5126: (Trunc(SYSDATE) < Nvl(l_term_end_Date,Trunc(SYSDATE+1)))) THEN
5127: x_return_status := fnd_api.g_ret_sts_error;
5128: FND_MESSAGE.SET_NAME('PON','PAYMENT_TERM_NOT_ACTIVE');
5129: FND_MESSAGE.set_token('PAYMENT_TERM',l_term_name);
5130: FND_MSG_PUB.ADD;
5131: RETURN;
5132: END IF;
5133: END IF;
5134: END IF;

Line 5192: FND_MSG_PUB.ADD;

5188: IF (p_receipt_method_id IS NULL) THEN
5189: x_return_status := fnd_api.g_ret_sts_error;
5190: FND_MESSAGE.SET_NAME('PON','REC_METH_NOT_DEF_FOR_PAY_TYP');
5191: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',p_payment_type_code);
5192: FND_MSG_PUB.ADD;
5193: RETURN;
5194: ELSE
5195: BEGIN
5196: SELECT RM.NAME,

Line 5215: FND_MSG_PUB.ADD;

5211: WHEN No_Data_Found THEN
5212: x_return_status := fnd_api.g_ret_sts_error;
5213: FND_MESSAGE.SET_NAME('PON','RECEIPT_METH_NOT_DEF_IN_AR');
5214: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',p_payment_type_code);
5215: FND_MSG_PUB.ADD;
5216: RETURN;
5217: END;
5218:
5219: IF NOT ((Trunc(SYSDATE) >= l_rm_start_date) AND

Line 5224: FND_MSG_PUB.ADD;

5220: (Trunc(SYSDATE) < Nvl(l_rm_end_date,Trunc(SYSDATE+1)))) THEN
5221: x_return_status := fnd_api.g_ret_sts_error;
5222: FND_MESSAGE.SET_NAME('PON','RECEIPT_METHOD_NOT_ACTIVE');
5223: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5224: FND_MSG_PUB.ADD;
5225: RETURN;
5226: END IF;
5227:
5228: IF (p_payment_type_code IN (G_CASH,G_DEMAND_DRAFT,G_CHECK)) THEN

Line 5233: FND_MSG_PUB.ADD;

5229: IF (l_receipt_creation_method <> 'MANUAL') THEN
5230: x_return_status := fnd_api.g_ret_sts_error;
5231: FND_MESSAGE.SET_NAME('PON','RECEIPT_CRE_METH_NOT_VALID');
5232: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5233: FND_MSG_PUB.ADD;
5234: RETURN;
5235: END IF;
5236:
5237: IF (l_payment_channal_code IS NOT NULL) THEN

Line 5242: FND_MSG_PUB.ADD;

5238: x_return_status := fnd_api.g_ret_sts_error;
5239: FND_MESSAGE.SET_NAME('PON','PAY_METH_FOR_NOT_VALID');
5240: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',l_payment_type_name);
5241: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5242: FND_MSG_PUB.ADD;
5243: RETURN;
5244: END IF;
5245: ELSIF (p_payment_type_code = 'BANK_EFT_XFER') THEN
5246: IF (l_receipt_creation_method <> 'AUTOMATIC') THEN

Line 5250: FND_MSG_PUB.ADD;

5246: IF (l_receipt_creation_method <> 'AUTOMATIC') THEN
5247: x_return_status := fnd_api.g_ret_sts_error;
5248: FND_MESSAGE.SET_NAME('PON','RECEIPT_CRE_METH_NOT_VALID');
5249: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5250: FND_MSG_PUB.ADD;
5251: RETURN;
5252: END IF;
5253:
5254: IF (l_payment_channal_code <> G_BANK_ACCT_XFER) THEN

Line 5259: FND_MSG_PUB.ADD;

5255: x_return_status := fnd_api.g_ret_sts_error;
5256: FND_MESSAGE.SET_NAME('PON','PAY_METH_NOT_VALID');
5257: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',l_payment_type_name);
5258: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5259: FND_MSG_PUB.ADD;
5260: RETURN;
5261: END IF;
5262: ELSIF (p_payment_type_code = G_CREDIT_CARD) THEN
5263: IF (l_receipt_creation_method <> 'AUTOMATIC') THEN

Line 5267: FND_MSG_PUB.ADD;

5263: IF (l_receipt_creation_method <> 'AUTOMATIC') THEN
5264: x_return_status := fnd_api.g_ret_sts_error;
5265: FND_MESSAGE.SET_NAME('PON','RECEIPT_CRE_METH_NOT_VALID');
5266: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5267: FND_MSG_PUB.ADD;
5268: RETURN;
5269: END IF;
5270:
5271: IF (l_payment_channal_code <> G_CREDIT_CARD) THEN

Line 5276: FND_MSG_PUB.ADD;

5272: x_return_status := fnd_api.g_ret_sts_error;
5273: FND_MESSAGE.SET_NAME('PON','PAY_METH_NOT_VALID');
5274: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',l_payment_type_name);
5275: FND_MESSAGE.set_token('RECEIPT_METHOD',l_receipt_method_name);
5276: FND_MSG_PUB.ADD;
5277: RETURN;
5278: END IF;
5279: END IF;
5280: END IF;

Line 5287: FND_MSG_PUB.ADD;

5283: IF ((p_payment_type_code <> G_CREDIT_CARD) AND
5284: (p_refund_payment_method IS NULL)) THEN
5285: x_return_status := fnd_api.g_ret_sts_error;
5286: FND_MESSAGE.SET_NAME('PON','REF_PAY_METH_NOT_IN_SETUP');
5287: FND_MSG_PUB.ADD;
5288: RETURN;
5289: END IF;
5290: IF (p_refund_payment_method IS NOT NULL) THEN
5291: BEGIN

Line 5302: FND_MSG_PUB.ADD;

5298: x_return_status := fnd_api.g_ret_sts_error;
5299: FND_MESSAGE.SET_NAME('PON','REF_PAY_METH_NOT_VALID');
5300: FND_MESSAGE.SET_TOKEN('PAYMENT_TYPE',l_payment_type_name);
5301: FND_MESSAGE.SET_TOKEN('PAY_METHOD',l_refund_payment_method_name);
5302: FND_MSG_PUB.ADD;
5303: RETURN;
5304: END;
5305: END IF;
5306: END IF;

Line 5347: FND_MSG_PUB.ADD;

5343: if (l_return_value) THEN
5344: if l_status <> 'I' then
5345: x_return_status := fnd_api.g_ret_sts_error;
5346: FND_MESSAGE.SET_NAME('PON','AR_NOT_INSTALLED');
5347: FND_MSG_PUB.ADD;
5348: RETURN;
5349: end if;
5350: else
5351: x_return_status := fnd_api.g_ret_sts_error;

Line 5353: FND_MSG_PUB.ADD;

5349: end if;
5350: else
5351: x_return_status := fnd_api.g_ret_sts_error;
5352: FND_MESSAGE.SET_NAME('PON','AR_NOT_INSTALLED');
5353: FND_MSG_PUB.ADD;
5354: RETURN;
5355: end if;
5356: EXCEPTION
5357: WHEN OTHERS THEN

Line 5360: FND_MSG_PUB.ADD;

5356: EXCEPTION
5357: WHEN OTHERS THEN
5358: x_return_status := fnd_api.g_ret_sts_error;
5359: FND_MESSAGE.SET_NAME('PON','AR_NOT_INSTALLED');
5360: FND_MSG_PUB.ADD;
5361: RETURN;
5362: END;
5363: -- Validate AP Installation
5364: BEGIN

Line 5376: FND_MSG_PUB.ADD;

5372: if (l_return_value) THEN
5373: if l_status <> 'I' then
5374: x_return_status := fnd_api.g_ret_sts_error;
5375: FND_MESSAGE.SET_NAME('PON','AP_NOT_INSTALLED');
5376: FND_MSG_PUB.ADD;
5377: RETURN;
5378: end if;
5379: else
5380: x_return_status := fnd_api.g_ret_sts_error;

Line 5382: FND_MSG_PUB.ADD;

5378: end if;
5379: else
5380: x_return_status := fnd_api.g_ret_sts_error;
5381: FND_MESSAGE.SET_NAME('PON','AP_NOT_INSTALLED');
5382: FND_MSG_PUB.ADD;
5383: RETURN;
5384: end if;
5385: EXCEPTION
5386: WHEN OTHERS THEN

Line 5389: FND_MSG_PUB.ADD;

5385: EXCEPTION
5386: WHEN OTHERS THEN
5387: x_return_status := fnd_api.g_ret_sts_error;
5388: FND_MESSAGE.SET_NAME('PON','AP_NOT_INSTALLED');
5389: FND_MSG_PUB.ADD;
5390: RETURN;
5391: END;
5392:
5393: -- Validate IBY Installation

Line 5406: FND_MSG_PUB.ADD;

5402: if (l_return_value) then
5403: if l_status <> 'I' then
5404: x_return_status := fnd_api.g_ret_sts_error;
5405: FND_MESSAGE.SET_NAME('PON','IBY_NOT_INSTALLED');
5406: FND_MSG_PUB.ADD;
5407: RETURN;
5408: end if;
5409: else
5410: x_return_status := fnd_api.g_ret_sts_error;

Line 5412: FND_MSG_PUB.ADD;

5408: end if;
5409: else
5410: x_return_status := fnd_api.g_ret_sts_error;
5411: FND_MESSAGE.SET_NAME('PON','IBY_NOT_INSTALLED');
5412: FND_MSG_PUB.ADD;
5413: RETURN;
5414: end if;
5415: EXCEPTION
5416: WHEN OTHERS THEN

Line 5419: FND_MSG_PUB.ADD;

5415: EXCEPTION
5416: WHEN OTHERS THEN
5417: x_return_status := fnd_api.g_ret_sts_error;
5418: FND_MESSAGE.SET_NAME('PON','IBY_NOT_INSTALLED');
5419: FND_MSG_PUB.ADD;
5420: RETURN;
5421: END;
5422:
5423: -- Validate IBY Installation

Line 5436: FND_MSG_PUB.ADD;

5432: if (l_return_value) then
5433: if l_status <> 'I' then
5434: x_return_status := fnd_api.g_ret_sts_error;
5435: FND_MESSAGE.SET_NAME('PON','GL_NOT_INSTALLED');
5436: FND_MSG_PUB.ADD;
5437: RETURN;
5438: end if;
5439: else
5440: x_return_status := fnd_api.g_ret_sts_error;

Line 5442: FND_MSG_PUB.ADD;

5438: end if;
5439: else
5440: x_return_status := fnd_api.g_ret_sts_error;
5441: FND_MESSAGE.SET_NAME('PON','GL_NOT_INSTALLED');
5442: FND_MSG_PUB.ADD;
5443: RETURN;
5444: end if;
5445: EXCEPTION
5446: WHEN OTHERS THEN

Line 5449: FND_MSG_PUB.ADD;

5445: EXCEPTION
5446: WHEN OTHERS THEN
5447: x_return_status := fnd_api.g_ret_sts_error;
5448: FND_MESSAGE.SET_NAME('PON','GL_NOT_INSTALLED');
5449: FND_MSG_PUB.ADD;
5450: RETURN;
5451: END;
5452:
5453: END verify_finance_installation;

Line 5610: FND_MSG_PUB.ADD;

5606: WHEN No_Data_Found THEN
5607: x_return_status := fnd_api.g_ret_sts_success;
5608: FND_MESSAGE.SET_NAME('PON','TRX_BATCH_SOURCE_NOT_DEF');
5609: FND_MESSAGE.SET_TOKEN('BATCH_SOURCE_ID',To_Char(p_in_rec.batch_source_id));
5610: FND_MSG_PUB.ADD;
5611: RETURN;
5612: END;
5613:
5614: BEGIN

Line 5626: FND_MSG_PUB.ADD;

5622: EXCEPTION
5623: WHEN No_Data_Found THEN
5624: x_return_status := fnd_api.g_ret_sts_error;
5625: FND_MESSAGE.SET_NAME('PON','MEMO_LINE_NOT_DEF_IN_AR');
5626: FND_MSG_PUB.ADD;
5627: RETURN;
5628: END;
5629:
5630: BEGIN

Line 5815: FND_MSG_PUB.add;

5811: COMMIT;
5812: IF l_conc_req_id = 0 THEN
5813: print_log('l_conc_req_id'||l_conc_req_id);
5814: FND_MESSAGE.set_name('PON','AR_AUTO_INVOICE_SUBMIT_FAILED'); /*Concurrent program submission failed!!!!!*/
5815: FND_MSG_PUB.add;
5816: x_return_status := fnd_api.g_ret_sts_error;
5817:
5818: IF (p_in_rec.emd_trx_group_id IS NOT NULL) THEN
5819: DELETE FROM ra_interface_lines_all

Line 5847: FND_MSG_PUB.add;

5843: dev_request_status IN ('CANCELLED','ERROR','TERMINATED') THEN
5844: print_log('Dev status phase is not Completed');
5845: FND_MESSAGE.set_name('PON','AR_AUTO_INVOICE_JOB_FAILED');
5846: FND_MESSAGE.set_token('REQUEST_ID',l_conc_req_id);
5847: FND_MSG_PUB.add;
5848: x_return_status := fnd_api.g_ret_sts_error;
5849: IF (p_in_rec.emd_trx_group_id IS NOT NULL) THEN
5850: DELETE FROM ra_interface_lines_all
5851: WHERE INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'

Line 5959: FND_MSG_PUB.ADD;

5955: END IF;
5956: x_return_status := fnd_api.g_ret_sts_error;
5957: FND_MESSAGE.set_name('PON','AR_AUTO_INVOICE_JOB_FAILED');
5958: FND_MESSAGE.set_token('REQUEST_ID',l_conc_req_id);
5959: FND_MSG_PUB.ADD;
5960: END IF;
5961: END IF;
5962: print_log('x_return_status: '||x_return_status);
5963: END IF;

Line 6032: FND_MSG_PUB.add;

6028: COMMIT;
6029: IF (l_conc_req_id = 0) THEN
6030: print_log('post_emd_transactions l_conc_req_id'||l_conc_req_id);
6031: fnd_message.set_name ('PON','PON_EMD_CONC_SUBMIT_FAILED');
6032: FND_MSG_PUB.add;
6033: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6034: p_count => x_msg_count,
6035: p_data => x_msg_data);
6036: print_log('x_msg_count: '||x_msg_count);

Line 6033: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6029: IF (l_conc_req_id = 0) THEN
6030: print_log('post_emd_transactions l_conc_req_id'||l_conc_req_id);
6031: fnd_message.set_name ('PON','PON_EMD_CONC_SUBMIT_FAILED');
6032: FND_MSG_PUB.add;
6033: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6034: p_count => x_msg_count,
6035: p_data => x_msg_data);
6036: print_log('x_msg_count: '||x_msg_count);
6037: IF (x_msg_count > 1) THEN

Line 6042: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

6038: l_count := x_msg_count;
6039: x_msg_data := NULL;
6040: LOOP
6041: IF nvl(l_count, 0) > 0 THEN
6042: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
6043: x_msg_data := x_msg_data ||' '|| l_msg_data;
6044: l_count := nvl(l_count, 0) - 1;
6045: ELSE
6046: EXIT;

Line 6142: FND_MSG_PUB.add;

6138: COMMIT;
6139: IF (l_conc_req_id = 0) THEN
6140: print_log('post_emd_transactions l_conc_req_id'||l_conc_req_id);
6141: fnd_message.set_name ('PON','PON_EMD_CONC_SUBMIT_FAILED');
6142: FND_MSG_PUB.add;
6143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6144: p_count => x_msg_count,
6145: p_data => x_msg_data);
6146: print_log('x_msg_count: '||x_msg_count);

Line 6143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6139: IF (l_conc_req_id = 0) THEN
6140: print_log('post_emd_transactions l_conc_req_id'||l_conc_req_id);
6141: fnd_message.set_name ('PON','PON_EMD_CONC_SUBMIT_FAILED');
6142: FND_MSG_PUB.add;
6143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6144: p_count => x_msg_count,
6145: p_data => x_msg_data);
6146: print_log('x_msg_count: '||x_msg_count);
6147: IF (x_msg_count > 1) THEN

Line 6152: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);

6148: l_count := x_msg_count;
6149: x_msg_data := NULL;
6150: LOOP
6151: IF nvl(l_count, 0) > 0 THEN
6152: l_msg_data := FND_MSG_PUB.Get(l_count, FND_API.G_FALSE);
6153: x_msg_data := x_msg_data ||' '|| l_msg_data;
6154: l_count := nvl(l_count, 0) - 1;
6155: ELSE
6156: EXIT;