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

Line 933: fnd_message.set_name ('PN', 'PN_ALL_ACNT_DIST_MSG');

929:
930: IF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'Y' AND
931: (l_exp_cnt = 0 OR l_acc_cnt = 0) THEN
932:
933: fnd_message.set_name ('PN', 'PN_ALL_ACNT_DIST_MSG');
934: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
935: RAISE BAD_ITEM_EXCEPTION;
936:
937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND

Line 934: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

930: IF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'Y' AND
931: (l_exp_cnt = 0 OR l_acc_cnt = 0) THEN
932:
933: fnd_message.set_name ('PN', 'PN_ALL_ACNT_DIST_MSG');
934: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
935: RAISE BAD_ITEM_EXCEPTION;
936:
937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND
938: l_exp_cnt = 0 THEN

Line 940: fnd_message.set_name ('PN', 'PN_EXP_DIST_MSG');

936:
937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND
938: l_exp_cnt = 0 THEN
939:
940: fnd_message.set_name ('PN', 'PN_EXP_DIST_MSG');
941: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
942: RAISE BAD_ITEM_EXCEPTION;
943:
944: END IF;

Line 941: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND
938: l_exp_cnt = 0 THEN
939:
940: fnd_message.set_name ('PN', 'PN_EXP_DIST_MSG');
941: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
942: RAISE BAD_ITEM_EXCEPTION;
943:
944: END IF;
945:

Line 949: fnd_message.set_name ('PN', 'PN_CONV_RATE_REQD');

945:
946: ELSIF UPPER(exp_ap_cache(l_index).conv_rate_type) = 'USER' AND
947: exp_ap_cache(l_index).conv_rate IS NULL THEN
948:
949: fnd_message.set_name ('PN', 'PN_CONV_RATE_REQD');
950: pnp_debug_pkg.put_log_msg(fnd_message.get);
951: RAISE BAD_ITEM_EXCEPTION;
952:
953: ELSIF l_grpby_INVOICENUM THEN

Line 950: pnp_debug_pkg.put_log_msg(fnd_message.get);

946: ELSIF UPPER(exp_ap_cache(l_index).conv_rate_type) = 'USER' AND
947: exp_ap_cache(l_index).conv_rate IS NULL THEN
948:
949: fnd_message.set_name ('PN', 'PN_CONV_RATE_REQD');
950: pnp_debug_pkg.put_log_msg(fnd_message.get);
951: RAISE BAD_ITEM_EXCEPTION;
952:
953: ELSIF l_grpby_INVOICENUM THEN
954: IF exp_ap_cache(l_index).pn_ap_invoice_num IS NOT NULL THEN

Line 959: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');

955: FOR i IN c_inv_num(exp_ap_cache(l_index).pn_ap_invoice_num,
956: exp_ap_cache(l_index).pn_vendor_id,
957: exp_ap_cache(l_index).org_id)
958: LOOP
959: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
960: pnp_debug_pkg.put_log_msg(fnd_message.get);
961: RAISE BAD_ITEM_EXCEPTION;
962: END LOOP;
963: FOR i IN c_inv_num_itf(exp_ap_cache(l_index).pn_ap_invoice_num,

Line 960: pnp_debug_pkg.put_log_msg(fnd_message.get);

956: exp_ap_cache(l_index).pn_vendor_id,
957: exp_ap_cache(l_index).org_id)
958: LOOP
959: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
960: pnp_debug_pkg.put_log_msg(fnd_message.get);
961: RAISE BAD_ITEM_EXCEPTION;
962: END LOOP;
963: FOR i IN c_inv_num_itf(exp_ap_cache(l_index).pn_ap_invoice_num,
964: exp_ap_cache(l_index).pn_vendor_id,

Line 967: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');

963: FOR i IN c_inv_num_itf(exp_ap_cache(l_index).pn_ap_invoice_num,
964: exp_ap_cache(l_index).pn_vendor_id,
965: exp_ap_cache(l_index).org_id)
966: LOOP
967: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
968: pnp_debug_pkg.put_log_msg(fnd_message.get);
969: RAISE BAD_ITEM_EXCEPTION;
970: END LOOP;
971: END IF;

Line 968: pnp_debug_pkg.put_log_msg(fnd_message.get);

964: exp_ap_cache(l_index).pn_vendor_id,
965: exp_ap_cache(l_index).org_id)
966: LOOP
967: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
968: pnp_debug_pkg.put_log_msg(fnd_message.get);
969: RAISE BAD_ITEM_EXCEPTION;
970: END LOOP;
971: END IF;
972: END IF;

Line 976: fnd_message.set_name ('PN','PN_EXPAP_ERR');

972: END IF;
973:
974: EXCEPTION
975: WHEN BAD_ITEM_EXCEPTION THEN
976: fnd_message.set_name ('PN','PN_EXPAP_ERR');
977: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
978: pnp_debug_pkg.put_log_msg(fnd_message.get);
979:
980: l_error_ctr := l_error_ctr + 1;

Line 977: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);

973:
974: EXCEPTION
975: WHEN BAD_ITEM_EXCEPTION THEN
976: fnd_message.set_name ('PN','PN_EXPAP_ERR');
977: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
978: pnp_debug_pkg.put_log_msg(fnd_message.get);
979:
980: l_error_ctr := l_error_ctr + 1;
981:

Line 978: pnp_debug_pkg.put_log_msg(fnd_message.get);

974: EXCEPTION
975: WHEN BAD_ITEM_EXCEPTION THEN
976: fnd_message.set_name ('PN','PN_EXPAP_ERR');
977: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
978: pnp_debug_pkg.put_log_msg(fnd_message.get);
979:
980: l_error_ctr := l_error_ctr + 1;
981:
982: exp_ap_cache.DELETE(l_index);

Line 986: fnd_message.set_name ('PN','PN_EXPAP_ERR');

982: exp_ap_cache.DELETE(l_index);
983: l_index := l_index - 1;
984:
985: WHEN OTHERS THEN
986: fnd_message.set_name ('PN','PN_EXPAP_ERR');
987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
988: pnp_debug_pkg.put_log_msg(fnd_message.get);
989:
990: pnp_debug_pkg.put_log_msg(SQLERRM);

Line 987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);

983: l_index := l_index - 1;
984:
985: WHEN OTHERS THEN
986: fnd_message.set_name ('PN','PN_EXPAP_ERR');
987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
988: pnp_debug_pkg.put_log_msg(fnd_message.get);
989:
990: pnp_debug_pkg.put_log_msg(SQLERRM);
991: RAISE;

Line 988: pnp_debug_pkg.put_log_msg(fnd_message.get);

984:
985: WHEN OTHERS THEN
986: fnd_message.set_name ('PN','PN_EXPAP_ERR');
987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
988: pnp_debug_pkg.put_log_msg(fnd_message.get);
989:
990: pnp_debug_pkg.put_log_msg(SQLERRM);
991: RAISE;
992: END;

Line 1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');

1297: inserted_inv_t(l_temp_count).invoice_id := l_invoice_id;
1298: inserted_inv_t(l_temp_count).invoice_num := l_invoice_num;
1299: inserted_inv_t(l_temp_count).items_proc := l_next - l_start;
1300:
1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1302: fnd_message.set_token('INV_ID',l_invoice_id);

1298: inserted_inv_t(l_temp_count).invoice_num := l_invoice_num;
1299: inserted_inv_t(l_temp_count).items_proc := l_next - l_start;
1300:
1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:

Line 1303: fnd_message.set_token('INV_NUM',l_invoice_num);

1299: inserted_inv_t(l_temp_count).items_proc := l_next - l_start;
1300:
1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:
1307: PNP_DEBUG_PKG.put_log_msg(' ');

Line 1304: fnd_message.set_token('AMT',l_header_amount);

1300:
1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:
1307: PNP_DEBUG_PKG.put_log_msg(' ');
1308: -- now for the distributions

Line 1305: pnp_debug_pkg.put_log_msg(fnd_message.get);

1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:
1307: PNP_DEBUG_PKG.put_log_msg(' ');
1308: -- now for the distributions
1309:

Line 1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');

1455: ,exp_ap_cache(item).pn_tax_classification_code
1456: ,l_tax_code_override_flag)
1457: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1458:
1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);

Line 1460: fnd_message.set_token('INV_ID',l_invoice_id);

1456: ,l_tax_code_override_flag)
1457: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1458:
1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

Line 1461: fnd_message.set_token('NUM',l_invoice_num);

1457: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1458:
1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1462: fnd_message.set_token('ID',l_invoice_line_id);

1458:
1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);
1466:

Line 1463: fnd_message.set_token('AMT',l_line_amount);

1459: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);
1466:
1467: END LOOP; -- for accrual_tab

Line 1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

1460: fnd_message.set_token('INV_ID',l_invoice_id);
1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);
1466:
1467: END LOOP; -- for accrual_tab
1468:

Line 1465: pnp_debug_pkg.put_log_msg(fnd_message.get);

1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);
1466:
1467: END LOOP; -- for accrual_tab
1468:
1469: END IF; -- accrual entered if normalized

Line 1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');

1544: ,exp_ap_cache(item).pn_tax_classification_code /*--Bug 6392393--*/
1545: ,l_tax_code_override_flag)
1546: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1547:
1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);

Line 1549: fnd_message.set_token('INV_ID',l_invoice_id);

1545: ,l_tax_code_override_flag)
1546: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1547:
1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

Line 1550: fnd_message.set_token('NUM',l_invoice_num);

1546: RETURNING invoice_line_id, amount INTO l_invoice_line_id, l_line_amount;
1547:
1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1551: fnd_message.set_token('ID',l_invoice_line_id);

1547:
1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);
1555:

Line 1552: fnd_message.set_token('AMT',l_line_amount);

1548: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);
1555:
1556: END LOOP;

Line 1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

1549: fnd_message.set_token('INV_ID',l_invoice_id);
1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);
1555:
1556: END LOOP;
1557:

Line 1554: pnp_debug_pkg.put_log_msg(fnd_message.get);

1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);
1555:
1556: END LOOP;
1557:
1558: END IF; -- expense a/c

Line 1574: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');

1570: export_group_id = p_group_id
1571: WHERE payment_item_id = exp_ap_cache(item).pn_payment_item_id;
1572:
1573: IF (SQL%NOTFOUND) then
1574: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
1575: errbuf := fnd_message.get;
1576: pnp_debug_pkg.put_log_msg(errbuf);
1577: ROLLBACK;
1578: retcode := 2;

Line 1575: errbuf := fnd_message.get;

1571: WHERE payment_item_id = exp_ap_cache(item).pn_payment_item_id;
1572:
1573: IF (SQL%NOTFOUND) then
1574: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
1575: errbuf := fnd_message.get;
1576: pnp_debug_pkg.put_log_msg(errbuf);
1577: ROLLBACK;
1578: retcode := 2;
1579: RETURN;

Line 1596: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');

1592: last_update_date = l_last_update_date
1593: WHERE payment_schedule_id = exp_ap_cache(item).pn_payment_schedule_id;
1594:
1595: IF (SQL%NOTFOUND) then
1596: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
1597: errbuf := fnd_message.get;
1598: pnp_debug_pkg.put_log_msg(errbuf);
1599: ROLLBACK;
1600: retcode := 2;

Line 1597: errbuf := fnd_message.get;

1593: WHERE payment_schedule_id = exp_ap_cache(item).pn_payment_schedule_id;
1594:
1595: IF (SQL%NOTFOUND) then
1596: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
1597: errbuf := fnd_message.get;
1598: pnp_debug_pkg.put_log_msg(errbuf);
1599: ROLLBACK;
1600: retcode := 2;
1601: RETURN;

Line 1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');

1614: FOR i IN exists_msg LOOP
1615: l_msg_exists := TRUE;
1616: END LOOP;
1617: IF l_msg_exists THEN
1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1619: fnd_message.set_token('INV_NUM',l_invoice_num);
1620: pnp_debug_pkg.put_log_msg(fnd_message.get);
1621: ELSE
1622: pnp_debug_pkg.put_log_msg

Line 1619: fnd_message.set_token('INV_NUM',l_invoice_num);

1615: l_msg_exists := TRUE;
1616: END LOOP;
1617: IF l_msg_exists THEN
1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1619: fnd_message.set_token('INV_NUM',l_invoice_num);
1620: pnp_debug_pkg.put_log_msg(fnd_message.get);
1621: ELSE
1622: pnp_debug_pkg.put_log_msg
1623: ('The system is unable to group and process items with invoice number '||

Line 1620: pnp_debug_pkg.put_log_msg(fnd_message.get);

1616: END LOOP;
1617: IF l_msg_exists THEN
1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1619: fnd_message.set_token('INV_NUM',l_invoice_num);
1620: pnp_debug_pkg.put_log_msg(fnd_message.get);
1621: ELSE
1622: pnp_debug_pkg.put_log_msg
1623: ('The system is unable to group and process items with invoice number '||
1624: l_invoice_num||

Line 1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');

1844: ,'Y')--For Bug 9068811
1845: RETURNING invoice_id, invoice_num, invoice_amount
1846: INTO l_invoice_id, l_invoice_num, l_header_amount;
1847:
1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1849: fnd_message.set_token('INV_ID',l_invoice_id);

1845: RETURNING invoice_id, invoice_num, invoice_amount
1846: INTO l_invoice_id, l_invoice_num, l_header_amount;
1847:
1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:

Line 1850: fnd_message.set_token('INV_NUM',l_invoice_num);

1846: INTO l_invoice_id, l_invoice_num, l_header_amount;
1847:
1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:
1854: PNP_DEBUG_PKG.put_log_msg(' ');

Line 1851: fnd_message.set_token('AMT',l_header_amount);

1847:
1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:
1854: PNP_DEBUG_PKG.put_log_msg(' ');
1855: /* Create a line for accrual amount if the term is normalized */

Line 1852: pnp_debug_pkg.put_log_msg(fnd_message.get);

1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:
1854: PNP_DEBUG_PKG.put_log_msg(' ');
1855: /* Create a line for accrual amount if the term is normalized */
1856:

Line 1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');

1919: ,l_tax_code_override_flag)
1920: RETURNING invoice_line_id, amount
1921: INTO l_invoice_line_id, l_line_amount;
1922:
1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);

Line 1924: fnd_message.set_token('INV_ID',l_invoice_id);

1920: RETURNING invoice_line_id, amount
1921: INTO l_invoice_line_id, l_line_amount;
1922:
1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

Line 1925: fnd_message.set_token('NUM',l_invoice_num);

1921: INTO l_invoice_line_id, l_line_amount;
1922:
1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1926: fnd_message.set_token('ID',l_invoice_line_id);

1922:
1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);
1930:

Line 1927: fnd_message.set_token('AMT',l_line_amount);

1923: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);
1930:
1931: END LOOP; -- for accrual_tab

Line 1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

1924: fnd_message.set_token('INV_ID',l_invoice_id);
1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);
1930:
1931: END LOOP; -- for accrual_tab
1932: END IF; -- accrual entered if normalized

Line 1929: pnp_debug_pkg.put_log_msg(fnd_message.get);

1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);
1930:
1931: END LOOP; -- for accrual_tab
1932: END IF; -- accrual entered if normalized
1933:

Line 2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');

2008: ,l_tax_code_override_flag)
2009: RETURNING invoice_line_id, amount
2010: INTO l_invoice_line_id, l_line_amount;
2011:
2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);

Line 2013: fnd_message.set_token('INV_ID',l_invoice_id);

2009: RETURNING invoice_line_id, amount
2010: INTO l_invoice_line_id, l_line_amount;
2011:
2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

Line 2014: fnd_message.set_token('NUM',l_invoice_num);

2010: INTO l_invoice_line_id, l_line_amount;
2011:
2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2015: fnd_message.set_token('ID',l_invoice_line_id);

2011:
2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);
2019:

Line 2016: fnd_message.set_token('AMT',l_line_amount);

2012: fnd_message.set_name('PN','PN_EXPAP_LINE_PARAM');
2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);
2019:
2020: END LOOP;

Line 2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);

2013: fnd_message.set_token('INV_ID',l_invoice_id);
2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);
2019:
2020: END LOOP;
2021: END IF; -- expense a/c

Line 2018: pnp_debug_pkg.put_log_msg(fnd_message.get);

2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);
2019:
2020: END LOOP;
2021: END IF; -- expense a/c
2022:

Line 2037: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');

2033: export_group_id = p_group_id
2034: WHERE payment_item_id = exp_ap_cache(item).pn_payment_item_id;
2035:
2036: IF (SQL%NOTFOUND) then
2037: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
2038: errbuf := fnd_message.get;
2039: rollback;
2040: retcode := 2;
2041: RETURN;

Line 2038: errbuf := fnd_message.get;

2034: WHERE payment_item_id = exp_ap_cache(item).pn_payment_item_id;
2035:
2036: IF (SQL%NOTFOUND) then
2037: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
2038: errbuf := fnd_message.get;
2039: rollback;
2040: retcode := 2;
2041: RETURN;
2042: END IF;

Line 2058: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');

2054: last_update_date = l_last_update_date
2055: WHERE payment_schedule_id = exp_ap_cache(item).pn_payment_schedule_id;
2056:
2057: IF (SQL%NOTFOUND) then
2058: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
2059: errbuf := fnd_message.get;
2060: rollback;
2061: retcode := 2;
2062: return;

Line 2059: errbuf := fnd_message.get;

2055: WHERE payment_schedule_id = exp_ap_cache(item).pn_payment_schedule_id;
2056:
2057: IF (SQL%NOTFOUND) then
2058: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
2059: errbuf := fnd_message.get;
2060: rollback;
2061: retcode := 2;
2062: return;
2063: END IF;

Line 2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');

2580: COMMIT;
2581:
2582: pnp_debug_pkg.put_log_msg('
2583: ===========================================================================');
2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');

Line 2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));

2581:
2582: pnp_debug_pkg.put_log_msg('
2583: ===========================================================================');
2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);

Line 2586: pnp_debug_pkg.put_log_msg(fnd_message.get);

2582: pnp_debug_pkg.put_log_msg('
2583: ===========================================================================');
2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');

2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');

Line 2589: fnd_message.set_token ('NUM',l_error_ctr);

2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);

Line 2590: pnp_debug_pkg.put_log_msg(fnd_message.get);

2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');

2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('

Line 2593: fnd_message.set_token ('NUM',l_total_ctr);

2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('
2597: ===========================================================================');

Line 2594: pnp_debug_pkg.put_log_msg(fnd_message.get);

2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('
2597: ===========================================================================');
2598: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');

Line 2612: -- fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_PROBLEM');

2608: retcode := 2;
2609: ROLLBACK;
2610:
2611: WHEN OTHERS THEN
2612: -- fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_PROBLEM');
2613: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2614: errbuf := SQLERRM;
2615: retcode := 2;
2616: ROLLBACK;