APPS.JAI_AP_STND_TAX_PROCESS dependencies on FND_LOG

Line 139: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

135: WHERE invoice_id = pn_invoice_id
136: and default_dist_ccid is not null;
137:
138: ln_line_number NUMBER ;
139: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
140: ln_proc_level NUMBER := FND_LOG.level_procedure;
141: lv_proc_name VARCHAR2 (100) := 'Validate_Item_Dist_Lines';
142: v_num NUMBER;
143:

Line 140: ln_proc_level NUMBER := FND_LOG.level_procedure;

136: and default_dist_ccid is not null;
137:
138: ln_line_number NUMBER ;
139: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
140: ln_proc_level NUMBER := FND_LOG.level_procedure;
141: lv_proc_name VARCHAR2 (100) := 'Validate_Item_Dist_Lines';
142: v_num NUMBER;
143:
144: BEGIN

Line 148: FND_LOG.STRING ( ln_proc_level

144: BEGIN
145:
146: IF ( ln_proc_level >= ln_dbg_level)
147: THEN
148: FND_LOG.STRING ( ln_proc_level
149: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
150: , 'Enter procedure'
151: );
152: FND_LOG.STRING ( ln_proc_level

Line 152: FND_LOG.STRING ( ln_proc_level

148: FND_LOG.STRING ( ln_proc_level
149: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
150: , 'Enter procedure'
151: );
152: FND_LOG.STRING ( ln_proc_level
153: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
154: , 'pn_invoice_id ' || pn_invoice_id
155: );
156: END IF;

Line 172: FND_LOG.STRING ( ln_proc_level

168: --log for debug
169: IF ( ln_proc_level >= ln_dbg_level)
170: THEN
171:
172: FND_LOG.STRING ( ln_proc_level
173: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
174: , 'ln_line_number ' || NVL(ln_line_number,-99)
175: );
176:

Line 177: FND_LOG.STRING ( ln_proc_level

173: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
174: , 'ln_line_number ' || NVL(ln_line_number,-99)
175: );
176:
177: FND_LOG.STRING ( ln_proc_level
178: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
179: , 'Exit Function'
180: );
181: END IF; --( ln_proc_level >= ln_dbg_level )

Line 230: FND_LOG.STRING ( ln_proc_level

226: EXCEPTION
227: WHEN OTHERS THEN
228: IF ( ln_proc_level >= ln_dbg_level)
229: THEN
230: FND_LOG.STRING ( ln_proc_level
231: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
232: || '. Other_Exception '
233: , SQLCODE || ':' || SQLERRM
234: );

Line 277: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

273: WHERE aila.invoice_id = pn_invoice_id
274: AND aila.invoice_type_lookup_code ='PREPAYMENT';
275:
276: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
277: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
278: ln_proc_level NUMBER := FND_LOG.level_procedure;
279: lv_proc_name VARCHAR2 (100) := 'Validate_Prepayment_Invoice';
280: BEGIN
281:

Line 278: ln_proc_level NUMBER := FND_LOG.level_procedure;

274: AND aila.invoice_type_lookup_code ='PREPAYMENT';
275:
276: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
277: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
278: ln_proc_level NUMBER := FND_LOG.level_procedure;
279: lv_proc_name VARCHAR2 (100) := 'Validate_Prepayment_Invoice';
280: BEGIN
281:
282: IF ( ln_proc_level >= ln_dbg_level)

Line 284: FND_LOG.STRING ( ln_proc_level

280: BEGIN
281:
282: IF ( ln_proc_level >= ln_dbg_level)
283: THEN
284: FND_LOG.STRING ( ln_proc_level
285: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
286: , 'Enter procedure'
287: );
288: FND_LOG.STRING ( ln_proc_level

Line 288: FND_LOG.STRING ( ln_proc_level

284: FND_LOG.STRING ( ln_proc_level
285: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
286: , 'Enter procedure'
287: );
288: FND_LOG.STRING ( ln_proc_level
289: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
290: , 'pn_invoice_id ' || pn_invoice_id
291: );
292: END IF;

Line 302: FND_LOG.STRING ( ln_proc_level

298:
299: IF ( ln_proc_level >= ln_dbg_level)
300: THEN
301:
302: FND_LOG.STRING ( ln_proc_level
303: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
304: , 'ln_invoice_id ' || NVL(ln_invoice_id,-99)
305: );
306:

Line 307: FND_LOG.STRING ( ln_proc_level

303: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
304: , 'ln_invoice_id ' || NVL(ln_invoice_id,-99)
305: );
306:
307: FND_LOG.STRING ( ln_proc_level
308: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
309: , 'Exit Function'
310: );
311: END IF; --( ln_proc_level >= ln_dbg_level )

Line 326: FND_LOG.STRING ( ln_proc_level

322: EXCEPTION
323: WHEN OTHERS THEN
324: IF ( ln_proc_level >= ln_dbg_level)
325: THEN
326: FND_LOG.STRING ( ln_proc_level
327: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
328: || '. Other_Exception '
329: , SQLCODE || ':' || SQLERRM
330: );

Line 371: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

367: AND aila.SOURCE = 'INDIA TAX INVOICE'
368: AND aila.invoice_type_lookup_code ='CREDIT';
369:
370: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
371: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
372: ln_proc_level NUMBER := FND_LOG.level_procedure;
373: lv_proc_name VARCHAR2 (100) := 'Validate_3rd_party_cm_Invoice';
374: BEGIN
375:

Line 372: ln_proc_level NUMBER := FND_LOG.level_procedure;

368: AND aila.invoice_type_lookup_code ='CREDIT';
369:
370: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
371: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
372: ln_proc_level NUMBER := FND_LOG.level_procedure;
373: lv_proc_name VARCHAR2 (100) := 'Validate_3rd_party_cm_Invoice';
374: BEGIN
375:
376: IF ( ln_proc_level >= ln_dbg_level)

Line 378: FND_LOG.STRING ( ln_proc_level

374: BEGIN
375:
376: IF ( ln_proc_level >= ln_dbg_level)
377: THEN
378: FND_LOG.STRING ( ln_proc_level
379: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
380: , 'Enter procedure'
381: );
382: FND_LOG.STRING ( ln_proc_level

Line 382: FND_LOG.STRING ( ln_proc_level

378: FND_LOG.STRING ( ln_proc_level
379: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
380: , 'Enter procedure'
381: );
382: FND_LOG.STRING ( ln_proc_level
383: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
384: , 'pn_invoice_id ' || pn_invoice_id
385: );
386: END IF;

Line 396: FND_LOG.STRING ( ln_proc_level

392:
393: IF ( ln_proc_level >= ln_dbg_level)
394: THEN
395:
396: FND_LOG.STRING ( ln_proc_level
397: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
398: , 'ln_invoice_id ' || NVL(ln_invoice_id,-99)
399: );
400:

Line 401: FND_LOG.STRING ( ln_proc_level

397: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
398: , 'ln_invoice_id ' || NVL(ln_invoice_id,-99)
399: );
400:
401: FND_LOG.STRING ( ln_proc_level
402: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
403: , 'Exit Function'
404: );
405: END IF; --( ln_proc_level >= ln_dbg_level )

Line 418: FND_LOG.STRING ( ln_proc_level

414: EXCEPTION
415: WHEN OTHERS THEN
416: IF ( ln_proc_level >= ln_dbg_level)
417: THEN
418: FND_LOG.STRING ( ln_proc_level
419: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
420: || '. Other_Exception '
421: , SQLCODE || ':' || SQLERRM
422: );

Line 459: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

455: , pn_tax_allocation_number IN NUMBER
456: )
457: IS
458:
459: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
460: ln_proc_level NUMBER := FND_LOG.level_procedure;
461: lv_proc_name VARCHAR2 (100) := 'Insert_Tax_Distribution_Lines';
462: BEGIN
463:

Line 460: ln_proc_level NUMBER := FND_LOG.level_procedure;

456: )
457: IS
458:
459: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
460: ln_proc_level NUMBER := FND_LOG.level_procedure;
461: lv_proc_name VARCHAR2 (100) := 'Insert_Tax_Distribution_Lines';
462: BEGIN
463:
464: --log for debug

Line 467: FND_LOG.STRING ( ln_proc_level

463:
464: --log for debug
465: IF ( ln_proc_level >= ln_dbg_level)
466: THEN
467: FND_LOG.STRING ( ln_proc_level
468: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
469: , 'Enter procedure'
470: );
471: FND_LOG.STRING ( ln_proc_level

Line 471: FND_LOG.STRING ( ln_proc_level

467: FND_LOG.STRING ( ln_proc_level
468: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
469: , 'Enter procedure'
470: );
471: FND_LOG.STRING ( ln_proc_level
472: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
473: , 'pn_invoice_id ' || pn_invoice_id
474: );
475: FND_LOG.STRING ( ln_proc_level

Line 475: FND_LOG.STRING ( ln_proc_level

471: FND_LOG.STRING ( ln_proc_level
472: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
473: , 'pn_invoice_id ' || pn_invoice_id
474: );
475: FND_LOG.STRING ( ln_proc_level
476: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
477: , 'pn_invoice_line_number ' || pn_invoice_line_number
478: );
479: FND_LOG.STRING ( ln_proc_level

Line 479: FND_LOG.STRING ( ln_proc_level

475: FND_LOG.STRING ( ln_proc_level
476: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
477: , 'pn_invoice_line_number ' || pn_invoice_line_number
478: );
479: FND_LOG.STRING ( ln_proc_level
480: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
481: , 'pn_item_allocation_number ' || pn_item_allocation_number
482: );
483: FND_LOG.STRING ( ln_proc_level

Line 483: FND_LOG.STRING ( ln_proc_level

479: FND_LOG.STRING ( ln_proc_level
480: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
481: , 'pn_item_allocation_number ' || pn_item_allocation_number
482: );
483: FND_LOG.STRING ( ln_proc_level
484: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
485: , 'pn_tax_allocation_number ' || pn_tax_allocation_number
486: );
487: END IF;

Line 992: FND_LOG.STRING ( ln_proc_level

988: END LOOP; --(i IN (pn_tax_allocation_number+1) .. pn_item_allocation_number)
989:
990: IF ( ln_proc_level >= ln_dbg_level)
991: THEN
992: FND_LOG.STRING ( ln_proc_level
993: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
994: , 'Exit procedure'
995: );
996: END IF; --( ln_proc_level >= ln_dbg_level )

Line 1001: FND_LOG.STRING ( ln_proc_level

997: EXCEPTION
998: WHEN OTHERS THEN
999: IF ( ln_proc_level >= ln_dbg_level)
1000: THEN
1001: FND_LOG.STRING ( ln_proc_level
1002: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1003: || '. Other_Exception '
1004: , SQLCODE || ':' || SQLERRM
1005: );

Line 1037: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1033: , pn_item_allocation_number IN NUMBER
1034: )
1035: IS
1036:
1037: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1038: ln_proc_level NUMBER := FND_LOG.level_procedure;
1039: lv_proc_name VARCHAR2 (100) := 'Delete_Tax_Distribution_Lines';
1040: BEGIN
1041: --log for debug

Line 1038: ln_proc_level NUMBER := FND_LOG.level_procedure;

1034: )
1035: IS
1036:
1037: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1038: ln_proc_level NUMBER := FND_LOG.level_procedure;
1039: lv_proc_name VARCHAR2 (100) := 'Delete_Tax_Distribution_Lines';
1040: BEGIN
1041: --log for debug
1042: IF ( ln_proc_level >= ln_dbg_level)

Line 1044: FND_LOG.STRING ( ln_proc_level

1040: BEGIN
1041: --log for debug
1042: IF ( ln_proc_level >= ln_dbg_level)
1043: THEN
1044: FND_LOG.STRING ( ln_proc_level
1045: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1046: , 'Enter procedure'
1047: );
1048: FND_LOG.STRING ( ln_proc_level

Line 1048: FND_LOG.STRING ( ln_proc_level

1044: FND_LOG.STRING ( ln_proc_level
1045: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1046: , 'Enter procedure'
1047: );
1048: FND_LOG.STRING ( ln_proc_level
1049: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1050: , 'pn_invoice_id ' || pn_invoice_id
1051: );
1052: FND_LOG.STRING ( ln_proc_level

Line 1052: FND_LOG.STRING ( ln_proc_level

1048: FND_LOG.STRING ( ln_proc_level
1049: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1050: , 'pn_invoice_id ' || pn_invoice_id
1051: );
1052: FND_LOG.STRING ( ln_proc_level
1053: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1054: , 'pn_invoice_line_number ' || pn_invoice_line_number
1055: );
1056: FND_LOG.STRING ( ln_proc_level

Line 1056: FND_LOG.STRING ( ln_proc_level

1052: FND_LOG.STRING ( ln_proc_level
1053: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1054: , 'pn_invoice_line_number ' || pn_invoice_line_number
1055: );
1056: FND_LOG.STRING ( ln_proc_level
1057: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1058: , 'pn_item_allocation_number ' || pn_item_allocation_number
1059: );
1060: END IF;

Line 1072: FND_LOG.STRING ( ln_proc_level

1068: AND distribution_line_number > pn_item_allocation_number;
1069:
1070: IF ( ln_proc_level >= ln_dbg_level)
1071: THEN
1072: FND_LOG.STRING ( ln_proc_level
1073: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1074: , 'Exit procedure'
1075: );
1076:

Line 1077: FND_LOG.STRING ( ln_proc_level

1073: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1074: , 'Exit procedure'
1075: );
1076:
1077: FND_LOG.STRING ( ln_proc_level
1078: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1079: , 'Exit procedure'
1080: );
1081: END IF; --( ln_proc_level >= ln_dbg_level )

Line 1087: FND_LOG.STRING ( ln_proc_level

1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF ( ln_proc_level >= ln_dbg_level)
1086: THEN
1087: FND_LOG.STRING ( ln_proc_level
1088: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1089: || '. Other_Exception '
1090: , SQLCODE || ':' || SQLERRM
1091: );

Line 1223: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1219: tax_rec get_tax_cur%ROWTYPE;
1220: ln_dist_total_amount NUMBER;
1221: ln_dist_total_base_amount NUMBER;
1222:
1223: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1224: ln_proc_level NUMBER := FND_LOG.level_procedure;
1225: lv_proc_name VARCHAR2 (100) := 'Allocate_Tax_Dist_Lines';
1226: BEGIN
1227: --log for debug

Line 1224: ln_proc_level NUMBER := FND_LOG.level_procedure;

1220: ln_dist_total_amount NUMBER;
1221: ln_dist_total_base_amount NUMBER;
1222:
1223: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1224: ln_proc_level NUMBER := FND_LOG.level_procedure;
1225: lv_proc_name VARCHAR2 (100) := 'Allocate_Tax_Dist_Lines';
1226: BEGIN
1227: --log for debug
1228: IF ( ln_proc_level >= ln_dbg_level)

Line 1230: FND_LOG.STRING ( ln_proc_level

1226: BEGIN
1227: --log for debug
1228: IF ( ln_proc_level >= ln_dbg_level)
1229: THEN
1230: FND_LOG.STRING ( ln_proc_level
1231: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1232: , 'Enter procedure'
1233: );
1234: FND_LOG.STRING ( ln_proc_level

Line 1234: FND_LOG.STRING ( ln_proc_level

1230: FND_LOG.STRING ( ln_proc_level
1231: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1232: , 'Enter procedure'
1233: );
1234: FND_LOG.STRING ( ln_proc_level
1235: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1236: , 'pn_invoice_id ' || pn_invoice_id
1237: );
1238: FND_LOG.STRING ( ln_proc_level

Line 1238: FND_LOG.STRING ( ln_proc_level

1234: FND_LOG.STRING ( ln_proc_level
1235: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1236: , 'pn_invoice_id ' || pn_invoice_id
1237: );
1238: FND_LOG.STRING ( ln_proc_level
1239: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1240: , 'pn_invoice_item_line_number '
1241: || pn_invoice_item_line_number
1242: );

Line 1445: FND_LOG.STRING ( ln_proc_level

1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: IF ( ln_proc_level >= ln_dbg_level)
1444: THEN
1445: FND_LOG.STRING ( ln_proc_level
1446: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1447: || '. Other_Exception '
1448: , SQLCODE || ':' || SQLERRM
1449: );

Line 1494: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1490: )
1491: );
1492:
1493:
1494: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1495: ln_proc_level NUMBER := FND_LOG.level_procedure;
1496: lv_proc_name VARCHAR2 (100) := 'Get_Service_Tax_Flag';
1497: lv_service_tax_flag VARCHAR2(1);
1498: BEGIN

Line 1495: ln_proc_level NUMBER := FND_LOG.level_procedure;

1491: );
1492:
1493:
1494: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1495: ln_proc_level NUMBER := FND_LOG.level_procedure;
1496: lv_proc_name VARCHAR2 (100) := 'Get_Service_Tax_Flag';
1497: lv_service_tax_flag VARCHAR2(1);
1498: BEGIN
1499: IF ( ln_proc_level >= ln_dbg_level)

Line 1501: FND_LOG.STRING ( ln_proc_level

1497: lv_service_tax_flag VARCHAR2(1);
1498: BEGIN
1499: IF ( ln_proc_level >= ln_dbg_level)
1500: THEN
1501: FND_LOG.STRING ( ln_proc_level
1502: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1503: , 'Enter procedure'
1504: );
1505: FND_LOG.STRING ( ln_proc_level

Line 1505: FND_LOG.STRING ( ln_proc_level

1501: FND_LOG.STRING ( ln_proc_level
1502: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1503: , 'Enter procedure'
1504: );
1505: FND_LOG.STRING ( ln_proc_level
1506: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1507: , 'pn_tax_id ' || to_char(pv_tax_type)
1508: );
1509: END IF; --(ln_proc_level >= ln_dbg_level)

Line 1520: FND_LOG.STRING ( ln_proc_level

1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: IF ( ln_proc_level >= ln_dbg_level)
1519: THEN
1520: FND_LOG.STRING ( ln_proc_level
1521: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1522: || '. Other_Exception '
1523: , SQLCODE || ':' || SQLERRM
1524: );

Line 1558: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1554: )
1555: RETURN VARCHAR2
1556: IS
1557: lv_tax_type VARCHAR2(10) ;
1558: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1559: ln_proc_level NUMBER := FND_LOG.level_procedure;
1560: lv_proc_name VARCHAR2 (100) := 'Get_Tax_Type';
1561: BEGIN
1562: IF ( ln_proc_level >= ln_dbg_level)

Line 1559: ln_proc_level NUMBER := FND_LOG.level_procedure;

1555: RETURN VARCHAR2
1556: IS
1557: lv_tax_type VARCHAR2(10) ;
1558: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1559: ln_proc_level NUMBER := FND_LOG.level_procedure;
1560: lv_proc_name VARCHAR2 (100) := 'Get_Tax_Type';
1561: BEGIN
1562: IF ( ln_proc_level >= ln_dbg_level)
1563: THEN

Line 1564: FND_LOG.STRING ( ln_proc_level

1560: lv_proc_name VARCHAR2 (100) := 'Get_Tax_Type';
1561: BEGIN
1562: IF ( ln_proc_level >= ln_dbg_level)
1563: THEN
1564: FND_LOG.STRING ( ln_proc_level
1565: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1566: , 'Enter procedure'
1567: );
1568: FND_LOG.STRING ( ln_proc_level

Line 1568: FND_LOG.STRING ( ln_proc_level

1564: FND_LOG.STRING ( ln_proc_level
1565: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1566: , 'Enter procedure'
1567: );
1568: FND_LOG.STRING ( ln_proc_level
1569: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1570: , 'pv_modvat_flag ' || pv_modvat_flag
1571: );
1572: FND_LOG.STRING ( ln_proc_level

Line 1572: FND_LOG.STRING ( ln_proc_level

1568: FND_LOG.STRING ( ln_proc_level
1569: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1570: , 'pv_modvat_flag ' || pv_modvat_flag
1571: );
1572: FND_LOG.STRING ( ln_proc_level
1573: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1574: , 'pn_cr_percentage ' || pn_cr_percentage
1575: );
1576: END IF; --(ln_proc_level >= ln_dbg_level)

Line 1600: FND_LOG.STRING ( ln_proc_level

1596:
1597:
1598: IF ( ln_proc_level >= ln_dbg_level)
1599: THEN
1600: FND_LOG.STRING ( ln_proc_level
1601: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1602: , 'lv_tax_type ' || lv_tax_type
1603: );
1604:

Line 1605: FND_LOG.STRING ( ln_proc_level

1601: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1602: , 'lv_tax_type ' || lv_tax_type
1603: );
1604:
1605: FND_LOG.STRING ( ln_proc_level
1606: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1607: , 'Exit procedure'
1608: );
1609: END IF; --( ln_proc_level >= ln_dbg_level )

Line 1616: FND_LOG.STRING ( ln_proc_level

1612: EXCEPTION
1613: WHEN OTHERS THEN
1614: IF ( ln_proc_level >= ln_dbg_level)
1615: THEN
1616: FND_LOG.STRING ( ln_proc_level
1617: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1618: || '. Other_Exception '
1619: , SQLCODE || ':' || SQLERRM
1620: );

Line 1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1731: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1734:
1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1736: ln_proc_level NUMBER := FND_LOG.level_procedure;
1737: lv_proc_name VARCHAR2 (100) := 'Get_Dist_Account_Ccid';
1738: -- Added by Chong.Lei for POT code port begin
1739: --Add by Xiao for POT changes, reg bug#12533434, begin

Line 1736: ln_proc_level NUMBER := FND_LOG.level_procedure;

1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1734:
1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1736: ln_proc_level NUMBER := FND_LOG.level_procedure;
1737: lv_proc_name VARCHAR2 (100) := 'Get_Dist_Account_Ccid';
1738: -- Added by Chong.Lei for POT code port begin
1739: --Add by Xiao for POT changes, reg bug#12533434, begin
1740: ---------------------------------------------------------------

Line 1755: FND_LOG.STRING ( ln_proc_level

1751: BEGIN
1752: --log for debug
1753: IF ( ln_proc_level >= ln_dbg_level)
1754: THEN
1755: FND_LOG.STRING ( ln_proc_level
1756: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1757: , 'Enter procedure'
1758: );
1759: FND_LOG.STRING ( ln_proc_level

Line 1759: FND_LOG.STRING ( ln_proc_level

1755: FND_LOG.STRING ( ln_proc_level
1756: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1757: , 'Enter procedure'
1758: );
1759: FND_LOG.STRING ( ln_proc_level
1760: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1761: , 'pn_organization_id ' || pn_organization_id
1762: );
1763: FND_LOG.STRING ( ln_proc_level

Line 1763: FND_LOG.STRING ( ln_proc_level

1759: FND_LOG.STRING ( ln_proc_level
1760: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1761: , 'pn_organization_id ' || pn_organization_id
1762: );
1763: FND_LOG.STRING ( ln_proc_level
1764: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1765: , 'pn_location_id ' || pn_location_id
1766: );
1767: FND_LOG.STRING ( ln_proc_level

Line 1767: FND_LOG.STRING ( ln_proc_level

1763: FND_LOG.STRING ( ln_proc_level
1764: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1765: , 'pn_location_id ' || pn_location_id
1766: );
1767: FND_LOG.STRING ( ln_proc_level
1768: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1769: , 'pn_organization_id ' || pn_organization_id
1770: );
1771: FND_LOG.STRING ( ln_proc_level

Line 1771: FND_LOG.STRING ( ln_proc_level

1767: FND_LOG.STRING ( ln_proc_level
1768: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1769: , 'pn_organization_id ' || pn_organization_id
1770: );
1771: FND_LOG.STRING ( ln_proc_level
1772: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1773: , 'pn_tax_acct_ccid ' || pn_tax_acct_ccid
1774: );
1775: FND_LOG.STRING ( ln_proc_level

Line 1775: FND_LOG.STRING ( ln_proc_level

1771: FND_LOG.STRING ( ln_proc_level
1772: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1773: , 'pn_tax_acct_ccid ' || pn_tax_acct_ccid
1774: );
1775: FND_LOG.STRING ( ln_proc_level
1776: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1777: , 'pv_tax_type ' || pv_tax_type
1778: );
1779: END IF;

Line 1908: FND_LOG.STRING ( ln_proc_level

1904: END IF; --(lv_recoverable_flag = 'N')
1905:
1906: IF ( ln_proc_level >= ln_dbg_level)
1907: THEN
1908: FND_LOG.STRING ( ln_proc_level
1909: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1910: , 'ln_dist_acct_ccid ' || ln_dist_acct_ccid
1911: );
1912:

Line 1913: FND_LOG.STRING ( ln_proc_level

1909: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1910: , 'ln_dist_acct_ccid ' || ln_dist_acct_ccid
1911: );
1912:
1913: FND_LOG.STRING ( ln_proc_level
1914: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1915: , 'Exit procedure'
1916: );
1917: END IF; --( ln_proc_level >= ln_dbg_level )

Line 1924: FND_LOG.STRING ( ln_proc_level

1920: EXCEPTION
1921: WHEN OTHERS THEN
1922: IF ( ln_proc_level >= ln_dbg_level)
1923: THEN
1924: FND_LOG.STRING ( ln_proc_level
1925: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
1926: || '. Other_Exception '
1927: , SQLCODE || ':' || SQLERRM
1928: );

Line 1958: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

1954: FUNCTION Get_Max_Invoice_Line_Number (pn_invoice_id NUMBER)
1955: RETURN NUMBER
1956: IS
1957: ln_max_line_number NUMBER;
1958: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1959: ln_proc_level NUMBER := FND_LOG.level_procedure;
1960: lv_proc_name VARCHAR2 (100) := 'Get_Max_Invoice_Line_Number';
1961: BEGIN
1962: --log for debug

Line 1959: ln_proc_level NUMBER := FND_LOG.level_procedure;

1955: RETURN NUMBER
1956: IS
1957: ln_max_line_number NUMBER;
1958: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1959: ln_proc_level NUMBER := FND_LOG.level_procedure;
1960: lv_proc_name VARCHAR2 (100) := 'Get_Max_Invoice_Line_Number';
1961: BEGIN
1962: --log for debug
1963: IF ( ln_proc_level >= ln_dbg_level)

Line 1965: FND_LOG.STRING ( ln_proc_level

1961: BEGIN
1962: --log for debug
1963: IF ( ln_proc_level >= ln_dbg_level)
1964: THEN
1965: FND_LOG.STRING ( ln_proc_level
1966: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1967: , 'Enter procedure'
1968: );
1969: FND_LOG.STRING ( ln_proc_level

Line 1969: FND_LOG.STRING ( ln_proc_level

1965: FND_LOG.STRING ( ln_proc_level
1966: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
1967: , 'Enter procedure'
1968: );
1969: FND_LOG.STRING ( ln_proc_level
1970: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1971: , 'pn_invoice_id ' || pn_invoice_id
1972: );
1973: END IF;

Line 1990: FND_LOG.STRING ( ln_proc_level

1986: WHERE invoice_id = pn_invoice_id;
1987:
1988: IF ( ln_proc_level >= ln_dbg_level)
1989: THEN
1990: FND_LOG.STRING ( ln_proc_level
1991: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1992: , 'ln_max_line_number ' || ln_max_line_number
1993: );
1994: FND_LOG.STRING ( ln_proc_level

Line 1994: FND_LOG.STRING ( ln_proc_level

1990: FND_LOG.STRING ( ln_proc_level
1991: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
1992: , 'ln_max_line_number ' || ln_max_line_number
1993: );
1994: FND_LOG.STRING ( ln_proc_level
1995: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
1996: , 'Exit procedure'
1997: );
1998: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2005: FND_LOG.STRING ( ln_proc_level

2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: IF ( ln_proc_level >= ln_dbg_level)
2004: THEN
2005: FND_LOG.STRING ( ln_proc_level
2006: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2007: || '. Other_Exception '
2008: , SQLCODE || ':' || SQLERRM
2009: );

Line 2042: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2038: FUNCTION Get_Max_Doc_Source_Line_Id (pn_invoice_id NUMBER)
2039: RETURN NUMBER
2040: IS
2041: ln_max_line_number NUMBER;
2042: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2043: ln_proc_level NUMBER := FND_LOG.level_procedure;
2044: lv_proc_name VARCHAR2 (100) := 'Get_Max_Doc_Source_Line_Id';
2045: BEGIN
2046: --log for debug

Line 2043: ln_proc_level NUMBER := FND_LOG.level_procedure;

2039: RETURN NUMBER
2040: IS
2041: ln_max_line_number NUMBER;
2042: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2043: ln_proc_level NUMBER := FND_LOG.level_procedure;
2044: lv_proc_name VARCHAR2 (100) := 'Get_Max_Doc_Source_Line_Id';
2045: BEGIN
2046: --log for debug
2047: IF ( ln_proc_level >= ln_dbg_level)

Line 2049: FND_LOG.STRING ( ln_proc_level

2045: BEGIN
2046: --log for debug
2047: IF ( ln_proc_level >= ln_dbg_level)
2048: THEN
2049: FND_LOG.STRING ( ln_proc_level
2050: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2051: , 'Enter procedure'
2052: );
2053: FND_LOG.STRING ( ln_proc_level

Line 2053: FND_LOG.STRING ( ln_proc_level

2049: FND_LOG.STRING ( ln_proc_level
2050: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2051: , 'Enter procedure'
2052: );
2053: FND_LOG.STRING ( ln_proc_level
2054: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2055: , 'pn_invoice_id ' || pn_invoice_id
2056: );
2057: END IF;

Line 2079: FND_LOG.STRING ( ln_proc_level

2075:
2076:
2077: IF ( ln_proc_level >= ln_dbg_level)
2078: THEN
2079: FND_LOG.STRING ( ln_proc_level
2080: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2081: , 'ln_max_line_number ' || ln_max_line_number
2082: );
2083: FND_LOG.STRING ( ln_proc_level

Line 2083: FND_LOG.STRING ( ln_proc_level

2079: FND_LOG.STRING ( ln_proc_level
2080: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2081: , 'ln_max_line_number ' || ln_max_line_number
2082: );
2083: FND_LOG.STRING ( ln_proc_level
2084: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2085: , 'Exit procedure'
2086: );
2087: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2094: FND_LOG.STRING ( ln_proc_level

2090: EXCEPTION
2091: WHEN OTHERS THEN
2092: IF ( ln_proc_level >= ln_dbg_level)
2093: THEN
2094: FND_LOG.STRING ( ln_proc_level
2095: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2096: || '. Other_Exception '
2097: , SQLCODE || ':' || SQLERRM
2098: );

Line 2130: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2126: )
2127: RETURN NUMBER
2128: IS
2129: ln_max_tax_line_num NUMBER;
2130: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2131: ln_proc_level NUMBER := FND_LOG.level_procedure;
2132: lv_proc_name VARCHAR2 (100) := 'Get_Max_Tax_Line_Number';
2133: BEGIN
2134: --log for debug

Line 2131: ln_proc_level NUMBER := FND_LOG.level_procedure;

2127: RETURN NUMBER
2128: IS
2129: ln_max_tax_line_num NUMBER;
2130: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2131: ln_proc_level NUMBER := FND_LOG.level_procedure;
2132: lv_proc_name VARCHAR2 (100) := 'Get_Max_Tax_Line_Number';
2133: BEGIN
2134: --log for debug
2135: IF ( ln_proc_level >= ln_dbg_level)

Line 2137: FND_LOG.STRING ( ln_proc_level

2133: BEGIN
2134: --log for debug
2135: IF ( ln_proc_level >= ln_dbg_level)
2136: THEN
2137: FND_LOG.STRING ( ln_proc_level
2138: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2139: , 'Enter procedure'
2140: );
2141: FND_LOG.STRING ( ln_proc_level

Line 2141: FND_LOG.STRING ( ln_proc_level

2137: FND_LOG.STRING ( ln_proc_level
2138: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2139: , 'Enter procedure'
2140: );
2141: FND_LOG.STRING ( ln_proc_level
2142: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2143: , 'pn_invoice_id ' || pn_invoice_id
2144: );
2145: FND_LOG.STRING ( ln_proc_level

Line 2145: FND_LOG.STRING ( ln_proc_level

2141: FND_LOG.STRING ( ln_proc_level
2142: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2143: , 'pn_invoice_id ' || pn_invoice_id
2144: );
2145: FND_LOG.STRING ( ln_proc_level
2146: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2147: , 'pn_parent_invoice_line_number ' ||
2148: pn_parent_invoice_line_number
2149: );

Line 2173: FND_LOG.STRING ( ln_proc_level

2169: AND source_doc_type = jai_constants.g_ap_standalone_invoice;
2170:
2171: IF ( ln_proc_level >= ln_dbg_level)
2172: THEN
2173: FND_LOG.STRING ( ln_proc_level
2174: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2175: , 'ln_max_tax_line_num ' || ln_max_tax_line_num
2176: );
2177: FND_LOG.STRING ( ln_proc_level

Line 2177: FND_LOG.STRING ( ln_proc_level

2173: FND_LOG.STRING ( ln_proc_level
2174: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2175: , 'ln_max_tax_line_num ' || ln_max_tax_line_num
2176: );
2177: FND_LOG.STRING ( ln_proc_level
2178: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2179: , 'Exit procedure'
2180: );
2181: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2188: FND_LOG.STRING ( ln_proc_level

2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: IF ( ln_proc_level >= ln_dbg_level)
2187: THEN
2188: FND_LOG.STRING ( ln_proc_level
2189: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2190: || '. Other_Exception '
2191: , SQLCODE || ':' || SQLERRM
2192: );

Line 2229: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2225: WHERE code_combination_id = pn_code_combination_id;
2226:
2227: lv_account_type gl_code_combinations.account_type%TYPE;
2228:
2229: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2230: ln_proc_level NUMBER := FND_LOG.level_procedure;
2231: lv_proc_name VARCHAR2 (100) := 'Get_Gl_Account_Type';
2232: BEGIN
2233: --log for debug

Line 2230: ln_proc_level NUMBER := FND_LOG.level_procedure;

2226:
2227: lv_account_type gl_code_combinations.account_type%TYPE;
2228:
2229: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2230: ln_proc_level NUMBER := FND_LOG.level_procedure;
2231: lv_proc_name VARCHAR2 (100) := 'Get_Gl_Account_Type';
2232: BEGIN
2233: --log for debug
2234: IF ( ln_proc_level >= ln_dbg_level)

Line 2236: FND_LOG.STRING ( ln_proc_level

2232: BEGIN
2233: --log for debug
2234: IF ( ln_proc_level >= ln_dbg_level)
2235: THEN
2236: FND_LOG.STRING ( ln_proc_level
2237: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2238: , 'Enter procedure'
2239: );
2240: FND_LOG.STRING ( ln_proc_level

Line 2240: FND_LOG.STRING ( ln_proc_level

2236: FND_LOG.STRING ( ln_proc_level
2237: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2238: , 'Enter procedure'
2239: );
2240: FND_LOG.STRING ( ln_proc_level
2241: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2242: , 'pn_code_combination_id ' || pn_code_combination_id
2243: );
2244: END IF;--( ln_proc_level >= ln_dbg_level )

Line 2254: FND_LOG.STRING ( ln_proc_level

2250: CLOSE get_account_cur;
2251:
2252: IF ( ln_proc_level >= ln_dbg_level)
2253: THEN
2254: FND_LOG.STRING ( ln_proc_level
2255: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2256: , 'lv_account_type ' || lv_account_type
2257: );
2258: FND_LOG.STRING ( ln_proc_level

Line 2258: FND_LOG.STRING ( ln_proc_level

2254: FND_LOG.STRING ( ln_proc_level
2255: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2256: , 'lv_account_type ' || lv_account_type
2257: );
2258: FND_LOG.STRING ( ln_proc_level
2259: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2260: , 'Exit procedure'
2261: );
2262: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2270: FND_LOG.STRING ( ln_proc_level

2266: EXCEPTION
2267: WHEN OTHERS THEN
2268: IF ( ln_proc_level >= ln_dbg_level)
2269: THEN
2270: FND_LOG.STRING ( ln_proc_level
2271: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2272: || '. Other_Exception '
2273: , SQLCODE || ':' || SQLERRM
2274: );

Line 2316: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2312: jai_cmn_vendor_sites
2313: WHERE NVL (vendor_site_id, 0) = pn_vendor_site_id
2314: AND vendor_id = pn_vendor_id;
2315:
2316: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2317: ln_proc_level NUMBER := FND_LOG.level_procedure;
2318: lv_proc_name VARCHAR2 (100) := 'Get_Tax_Cat_Serv_Type';
2319: BEGIN
2320: --log for debug

Line 2317: ln_proc_level NUMBER := FND_LOG.level_procedure;

2313: WHERE NVL (vendor_site_id, 0) = pn_vendor_site_id
2314: AND vendor_id = pn_vendor_id;
2315:
2316: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2317: ln_proc_level NUMBER := FND_LOG.level_procedure;
2318: lv_proc_name VARCHAR2 (100) := 'Get_Tax_Cat_Serv_Type';
2319: BEGIN
2320: --log for debug
2321: IF ( ln_proc_level >= ln_dbg_level)

Line 2323: FND_LOG.STRING ( ln_proc_level

2319: BEGIN
2320: --log for debug
2321: IF ( ln_proc_level >= ln_dbg_level)
2322: THEN
2323: FND_LOG.STRING ( ln_proc_level
2324: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2325: , 'Enter procedure'
2326: );
2327: FND_LOG.STRING ( ln_proc_level

Line 2327: FND_LOG.STRING ( ln_proc_level

2323: FND_LOG.STRING ( ln_proc_level
2324: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2325: , 'Enter procedure'
2326: );
2327: FND_LOG.STRING ( ln_proc_level
2328: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2329: , 'pn_vendor_id ' || pn_vendor_id
2330: );
2331: FND_LOG.STRING ( ln_proc_level

Line 2331: FND_LOG.STRING ( ln_proc_level

2327: FND_LOG.STRING ( ln_proc_level
2328: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2329: , 'pn_vendor_id ' || pn_vendor_id
2330: );
2331: FND_LOG.STRING ( ln_proc_level
2332: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2333: , 'pn_vendor_site_id ' || pn_vendor_site_id
2334: );
2335: END IF;

Line 2347: FND_LOG.STRING ( ln_proc_level

2343: CLOSE get_tax_service_cur;
2344:
2345: IF ( ln_proc_level >= ln_dbg_level)
2346: THEN
2347: FND_LOG.STRING ( ln_proc_level
2348: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2349: , 'xn_tax_category_id ' || xn_tax_category_id
2350: );
2351: FND_LOG.STRING ( ln_proc_level

Line 2351: FND_LOG.STRING ( ln_proc_level

2347: FND_LOG.STRING ( ln_proc_level
2348: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2349: , 'xn_tax_category_id ' || xn_tax_category_id
2350: );
2351: FND_LOG.STRING ( ln_proc_level
2352: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2353: , 'xv_service_type_code ' || xv_service_type_code
2354: );
2355: FND_LOG.STRING ( ln_proc_level

Line 2355: FND_LOG.STRING ( ln_proc_level

2351: FND_LOG.STRING ( ln_proc_level
2352: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2353: , 'xv_service_type_code ' || xv_service_type_code
2354: );
2355: FND_LOG.STRING ( ln_proc_level
2356: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2357: , 'Exit procedure'
2358: );
2359: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2364: FND_LOG.STRING ( ln_proc_level

2360: EXCEPTION
2361: WHEN OTHERS THEN
2362: IF ( ln_proc_level >= ln_dbg_level)
2363: THEN
2364: FND_LOG.STRING ( ln_proc_level
2365: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2366: || '. Other_Exception '
2367: ,SQLCODE || ':' || SQLERRM
2368: );

Line 2407: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2403: , xn_exchange_rate OUT NOCOPY NUMBER
2404: , xn_batch_id OUT NOCOPY NUMBER
2405: )
2406: IS
2407: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2408: ln_proc_level NUMBER := FND_LOG.level_procedure;
2409: lv_proc_name VARCHAR2 (100) := 'Get_Invoice_Header_Infor';
2410:
2411: CURSOR Get_Invoice_Header_Infor_cur IS

Line 2408: ln_proc_level NUMBER := FND_LOG.level_procedure;

2404: , xn_batch_id OUT NOCOPY NUMBER
2405: )
2406: IS
2407: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2408: ln_proc_level NUMBER := FND_LOG.level_procedure;
2409: lv_proc_name VARCHAR2 (100) := 'Get_Invoice_Header_Infor';
2410:
2411: CURSOR Get_Invoice_Header_Infor_cur IS
2412: SELECT

Line 2425: FND_LOG.STRING ( ln_proc_level

2421: BEGIN
2422: --log for debug
2423: IF ( ln_proc_level >= ln_dbg_level)
2424: THEN
2425: FND_LOG.STRING ( ln_proc_level
2426: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2427: , 'Enter procedure'
2428: );
2429: FND_LOG.STRING ( ln_proc_level

Line 2429: FND_LOG.STRING ( ln_proc_level

2425: FND_LOG.STRING ( ln_proc_level
2426: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2427: , 'Enter procedure'
2428: );
2429: FND_LOG.STRING ( ln_proc_level
2430: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2431: , 'pn_invoice_id ' || pn_invoice_id
2432: );
2433: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 2448: FND_LOG.STRING ( ln_proc_level

2444:
2445: --log for debug
2446: IF ( ln_proc_level >= ln_dbg_level)
2447: THEN
2448: FND_LOG.STRING ( ln_proc_level
2449: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2450: , 'xn_vendor_id ' || xn_vendor_id
2451: );
2452: FND_LOG.STRING ( ln_proc_level

Line 2452: FND_LOG.STRING ( ln_proc_level

2448: FND_LOG.STRING ( ln_proc_level
2449: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2450: , 'xn_vendor_id ' || xn_vendor_id
2451: );
2452: FND_LOG.STRING ( ln_proc_level
2453: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2454: , 'xn_vendor_site_id ' || xn_vendor_site_id
2455: );
2456: FND_LOG.STRING ( ln_proc_level

Line 2456: FND_LOG.STRING ( ln_proc_level

2452: FND_LOG.STRING ( ln_proc_level
2453: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2454: , 'xn_vendor_site_id ' || xn_vendor_site_id
2455: );
2456: FND_LOG.STRING ( ln_proc_level
2457: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2458: , 'xv_currency_code ' || xv_currency_code
2459: );
2460: FND_LOG.STRING ( ln_proc_level

Line 2460: FND_LOG.STRING ( ln_proc_level

2456: FND_LOG.STRING ( ln_proc_level
2457: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2458: , 'xv_currency_code ' || xv_currency_code
2459: );
2460: FND_LOG.STRING ( ln_proc_level
2461: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2462: , 'xn_exchange_rate ' || xn_exchange_rate
2463: );
2464: FND_LOG.STRING ( ln_proc_level

Line 2464: FND_LOG.STRING ( ln_proc_level

2460: FND_LOG.STRING ( ln_proc_level
2461: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2462: , 'xn_exchange_rate ' || xn_exchange_rate
2463: );
2464: FND_LOG.STRING ( ln_proc_level
2465: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2466: , 'xn_batch_id ' || xn_batch_id
2467: );
2468: FND_LOG.STRING ( ln_proc_level

Line 2468: FND_LOG.STRING ( ln_proc_level

2464: FND_LOG.STRING ( ln_proc_level
2465: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2466: , 'xn_batch_id ' || xn_batch_id
2467: );
2468: FND_LOG.STRING ( ln_proc_level
2469: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2470: , 'Exit procedure'
2471: );
2472: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2477: FND_LOG.STRING ( ln_proc_level

2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: IF ( ln_proc_level >= ln_dbg_level)
2476: THEN
2477: FND_LOG.STRING ( ln_proc_level
2478: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2479: || '. Other_Exception '
2480: , SQLCODE || ':' || SQLERRM
2481: );

Line 2521: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2517: IS
2518: ln_invoice_id NUMBER := pn_invoice_id;
2519: ln_invoice_line_number NUMBER := pn_line_number;
2520: lv_modified_only_flag VARCHAR2 (1) := pv_modified_only_flag;
2521: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2522: ln_proc_level NUMBER := FND_LOG.level_procedure;
2523: lv_proc_name VARCHAR2 (100) := 'Delete_Tax_Lines';
2524: BEGIN
2525: --log for debug

Line 2522: ln_proc_level NUMBER := FND_LOG.level_procedure;

2518: ln_invoice_id NUMBER := pn_invoice_id;
2519: ln_invoice_line_number NUMBER := pn_line_number;
2520: lv_modified_only_flag VARCHAR2 (1) := pv_modified_only_flag;
2521: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2522: ln_proc_level NUMBER := FND_LOG.level_procedure;
2523: lv_proc_name VARCHAR2 (100) := 'Delete_Tax_Lines';
2524: BEGIN
2525: --log for debug
2526: IF ( ln_proc_level >= ln_dbg_level)

Line 2528: FND_LOG.STRING ( ln_proc_level

2524: BEGIN
2525: --log for debug
2526: IF ( ln_proc_level >= ln_dbg_level)
2527: THEN
2528: FND_LOG.STRING ( ln_proc_level
2529: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2530: , 'Enter procedure'
2531: );
2532: FND_LOG.STRING ( ln_proc_level

Line 2532: FND_LOG.STRING ( ln_proc_level

2528: FND_LOG.STRING ( ln_proc_level
2529: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2530: , 'Enter procedure'
2531: );
2532: FND_LOG.STRING ( ln_proc_level
2533: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2534: , 'pn_invoice_id ' || pn_invoice_id
2535: );
2536: FND_LOG.STRING ( ln_proc_level

Line 2536: FND_LOG.STRING ( ln_proc_level

2532: FND_LOG.STRING ( ln_proc_level
2533: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2534: , 'pn_invoice_id ' || pn_invoice_id
2535: );
2536: FND_LOG.STRING ( ln_proc_level
2537: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2538: , 'pn_line_number '|| pn_line_number
2539: );
2540: FND_LOG.STRING ( ln_proc_level

Line 2540: FND_LOG.STRING ( ln_proc_level

2536: FND_LOG.STRING ( ln_proc_level
2537: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2538: , 'pn_line_number '|| pn_line_number
2539: );
2540: FND_LOG.STRING ( ln_proc_level
2541: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2542: , 'pv_modified_only_flag ' || pv_modified_only_flag
2543: );
2544: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2578: FND_LOG.STRING( ln_proc_level

2574: );
2575: */
2576: IF ( ln_proc_level >= ln_dbg_level)
2577: THEN
2578: FND_LOG.STRING( ln_proc_level
2579: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2580: || '.Delete from jai_cmn_document_taxes'
2581: , SQL%ROWCOUNT||' ROWS DELETED '
2582: );

Line 2610: FND_LOG.STRING( ln_proc_level

2606: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;
2607:
2608: IF ( ln_proc_level >= ln_dbg_level)
2609: THEN
2610: FND_LOG.STRING( ln_proc_level
2611: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2612: || '.Delete from ap_invoice_lines_all'
2613: , SQL%ROWCOUNT||' ROWS DELETED '
2614: );

Line 2639: FND_LOG.STRING( ln_proc_level

2635: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;
2636:
2637: IF ( ln_proc_level >= ln_dbg_level)
2638: THEN
2639: FND_LOG.STRING( ln_proc_level
2640: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2641: || '.Delete from ap_invoice_distributions_all'
2642: , SQL%ROWCOUNT||' ROWS DELETED '
2643: );

Line 2662: FND_LOG.STRING( ln_proc_level

2658: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;
2659:
2660: IF ( ln_proc_level >= ln_dbg_level)
2661: THEN
2662: FND_LOG.STRING( ln_proc_level
2663: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2664: || '.Delete from jai_ap_invoice_lines'
2665: , SQL%ROWCOUNT||' ROWS DELETED '
2666: );

Line 2667: FND_LOG.STRING ( ln_proc_level

2663: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2664: || '.Delete from jai_ap_invoice_lines'
2665: , SQL%ROWCOUNT||' ROWS DELETED '
2666: );
2667: FND_LOG.STRING ( ln_proc_level
2668: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2669: , 'Exit procedure'
2670: );
2671: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2677: FND_LOG.STRING ( ln_proc_level

2673: EXCEPTION
2674: WHEN OTHERS THEN
2675: IF ( ln_proc_level >= ln_dbg_level)
2676: THEN
2677: FND_LOG.STRING ( ln_proc_level
2678: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2679: || '. Other_Exception '
2680: , SQLCODE || ':' || SQLERRM
2681: );

Line 2713: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2709: --===========================================================================
2710: PROCEDURE Delete_Useless_Lines (pn_invoice_id IN NUMBER)
2711: IS
2712: ln_invoice_id NUMBER := pn_invoice_id;
2713: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2714: ln_proc_level NUMBER := FND_LOG.level_procedure;
2715: lv_proc_name VARCHAR2 (100) := 'Delete_Useless_Lines';
2716: BEGIN
2717: --log for debug

Line 2714: ln_proc_level NUMBER := FND_LOG.level_procedure;

2710: PROCEDURE Delete_Useless_Lines (pn_invoice_id IN NUMBER)
2711: IS
2712: ln_invoice_id NUMBER := pn_invoice_id;
2713: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2714: ln_proc_level NUMBER := FND_LOG.level_procedure;
2715: lv_proc_name VARCHAR2 (100) := 'Delete_Useless_Lines';
2716: BEGIN
2717: --log for debug
2718: IF ( ln_proc_level >= ln_dbg_level)

Line 2720: FND_LOG.STRING ( ln_proc_level

2716: BEGIN
2717: --log for debug
2718: IF ( ln_proc_level >= ln_dbg_level)
2719: THEN
2720: FND_LOG.STRING ( ln_proc_level
2721: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2722: , 'Enter procedure'
2723: );
2724: FND_LOG.STRING ( ln_proc_level

Line 2724: FND_LOG.STRING ( ln_proc_level

2720: FND_LOG.STRING ( ln_proc_level
2721: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2722: , 'Enter procedure'
2723: );
2724: FND_LOG.STRING ( ln_proc_level
2725: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2726: , 'pn_invoice_id ' || pn_invoice_id
2727: );
2728: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2864: FND_LOG.STRING ( ln_proc_level

2860:
2861: --log for debug
2862: IF ( ln_proc_level >= ln_dbg_level)
2863: THEN
2864: FND_LOG.STRING ( ln_proc_level
2865: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2866: , 'Exit procedure'
2867: );
2868: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2873: FND_LOG.STRING ( ln_proc_level

2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: IF ( ln_proc_level >= ln_dbg_level)
2872: THEN
2873: FND_LOG.STRING ( ln_proc_level
2874: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2875: || '. Other_Exception '
2876: , SQLCODE || ':' || SQLERRM
2877: );

Line 2915: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

2911: , pn_line_number IN NUMBER
2912: , pn_line_amount IN NUMBER
2913: )
2914: IS
2915: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2916: ln_proc_level NUMBER := FND_LOG.level_procedure;
2917: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Line_Amount';
2918: BEGIN
2919: IF ( ln_proc_level >= ln_dbg_level)

Line 2916: ln_proc_level NUMBER := FND_LOG.level_procedure;

2912: , pn_line_amount IN NUMBER
2913: )
2914: IS
2915: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2916: ln_proc_level NUMBER := FND_LOG.level_procedure;
2917: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Line_Amount';
2918: BEGIN
2919: IF ( ln_proc_level >= ln_dbg_level)
2920: THEN

Line 2921: FND_LOG.STRING ( ln_proc_level

2917: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Line_Amount';
2918: BEGIN
2919: IF ( ln_proc_level >= ln_dbg_level)
2920: THEN
2921: FND_LOG.STRING ( ln_proc_level
2922: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2923: , 'Enter procedure'
2924: );
2925: FND_LOG.STRING ( ln_proc_level

Line 2925: FND_LOG.STRING ( ln_proc_level

2921: FND_LOG.STRING ( ln_proc_level
2922: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
2923: , 'Enter procedure'
2924: );
2925: FND_LOG.STRING ( ln_proc_level
2926: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2927: , 'pn_invoice_id ' || pn_invoice_id
2928: );
2929: FND_LOG.STRING ( ln_proc_level

Line 2929: FND_LOG.STRING ( ln_proc_level

2925: FND_LOG.STRING ( ln_proc_level
2926: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2927: , 'pn_invoice_id ' || pn_invoice_id
2928: );
2929: FND_LOG.STRING ( ln_proc_level
2930: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2931: , 'pn_line_number ' || pn_line_number
2932: );
2933: FND_LOG.STRING ( ln_proc_level

Line 2933: FND_LOG.STRING ( ln_proc_level

2929: FND_LOG.STRING ( ln_proc_level
2930: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2931: , 'pn_line_number ' || pn_line_number
2932: );
2933: FND_LOG.STRING ( ln_proc_level
2934: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
2935: , 'pn_line_amount ' || pn_line_amount
2936: );
2937: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2949: FND_LOG.STRING ( ln_proc_level

2945:
2946: --log for debug
2947: IF ( ln_proc_level >= ln_dbg_level)
2948: THEN
2949: FND_LOG.STRING ( ln_proc_level
2950: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2951: || '.DML (UPDATE jai_ap_invoice_lines)'
2952: ,SQL%ROWCOUNT || ' ROWS UPDATED.'
2953: );

Line 2954: FND_LOG.STRING ( ln_proc_level

2950: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2951: || '.DML (UPDATE jai_ap_invoice_lines)'
2952: ,SQL%ROWCOUNT || ' ROWS UPDATED.'
2953: );
2954: FND_LOG.STRING ( ln_proc_level
2955: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
2956: , 'Exit procedure'
2957: );
2958: END IF; --( ln_proc_level >= ln_dbg_level )

Line 2964: FND_LOG.STRING ( ln_proc_level

2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: IF ( ln_proc_level >= ln_dbg_level)
2963: THEN
2964: FND_LOG.STRING ( ln_proc_level
2965: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
2966: || '. Other_Exception '
2967: , SQLCODE || ':' || SQLERRM
2968: );

Line 3007: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

3003: , pn_currency_code IN VARCHAR2
3004: , pn_tax_category_id IN NUMBER
3005: )
3006: IS
3007: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3008: ln_proc_level NUMBER := FND_LOG.level_procedure;
3009: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Item_Info';
3010: BEGIN
3011: IF ( ln_proc_level >= ln_dbg_level)

Line 3008: ln_proc_level NUMBER := FND_LOG.level_procedure;

3004: , pn_tax_category_id IN NUMBER
3005: )
3006: IS
3007: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3008: ln_proc_level NUMBER := FND_LOG.level_procedure;
3009: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Item_Info';
3010: BEGIN
3011: IF ( ln_proc_level >= ln_dbg_level)
3012: THEN

Line 3013: FND_LOG.STRING ( ln_proc_level

3009: lv_proc_name VARCHAR2 (100) := 'Update_Jai_Item_Info';
3010: BEGIN
3011: IF ( ln_proc_level >= ln_dbg_level)
3012: THEN
3013: FND_LOG.STRING ( ln_proc_level
3014: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
3015: , 'Enter procedure'
3016: );
3017: FND_LOG.STRING ( ln_proc_level

Line 3017: FND_LOG.STRING ( ln_proc_level

3013: FND_LOG.STRING ( ln_proc_level
3014: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
3015: , 'Enter procedure'
3016: );
3017: FND_LOG.STRING ( ln_proc_level
3018: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3019: , 'pn_invoice_id ' || pn_invoice_id
3020: );
3021: FND_LOG.STRING ( ln_proc_level

Line 3021: FND_LOG.STRING ( ln_proc_level

3017: FND_LOG.STRING ( ln_proc_level
3018: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3019: , 'pn_invoice_id ' || pn_invoice_id
3020: );
3021: FND_LOG.STRING ( ln_proc_level
3022: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3023: , 'pn_vndr_site_id ' || pn_vndr_site_id
3024: );
3025: FND_LOG.STRING ( ln_proc_level

Line 3025: FND_LOG.STRING ( ln_proc_level

3021: FND_LOG.STRING ( ln_proc_level
3022: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3023: , 'pn_vndr_site_id ' || pn_vndr_site_id
3024: );
3025: FND_LOG.STRING ( ln_proc_level
3026: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3027: , 'pn_currency_code ' || pn_currency_code
3028: );
3029: FND_LOG.STRING ( ln_proc_level

Line 3029: FND_LOG.STRING ( ln_proc_level

3025: FND_LOG.STRING ( ln_proc_level
3026: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3027: , 'pn_currency_code ' || pn_currency_code
3028: );
3029: FND_LOG.STRING ( ln_proc_level
3030: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3031: , 'pn_tax_category_id ' || pn_tax_category_id
3032: );
3033: END IF; --( ln_proc_level >= ln_dbg_level )

Line 3048: FND_LOG.STRING ( ln_proc_level

3044:
3045: --log for debug
3046: IF ( ln_proc_level >= ln_dbg_level)
3047: THEN
3048: FND_LOG.STRING ( ln_proc_level
3049: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3050: || '.DML (UPDATE jai_ap_invoice_lines)'
3051: ,SQL%ROWCOUNT || ' ROWS UPDATED.'
3052: );

Line 3053: FND_LOG.STRING ( ln_proc_level

3049: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3050: || '.DML (UPDATE jai_ap_invoice_lines)'
3051: ,SQL%ROWCOUNT || ' ROWS UPDATED.'
3052: );
3053: FND_LOG.STRING ( ln_proc_level
3054: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
3055: , 'Exit procedure'
3056: );
3057: END IF; --( ln_proc_level >= ln_dbg_level )

Line 3063: FND_LOG.STRING ( ln_proc_level

3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: IF ( ln_proc_level >= ln_dbg_level)
3062: THEN
3063: FND_LOG.STRING ( ln_proc_level
3064: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
3065: || '. Other_Exception '
3066: , SQLCODE || ':' || SQLERRM
3067: );

Line 3303: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

3299: ln_exchange_rate NUMBER;
3300: lv_service_type_code VARCHAR2 (30);
3301: ln_batch_id NUMBER;
3302: ln_tax_category_id NUMBER;
3303: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3304: ln_proc_level NUMBER := FND_LOG.level_procedure;
3305: lv_proc_name VARCHAR2 (100) := 'Populate_Stnd_Inv_Taxes';
3306: ln_supplier_id NUMBER;
3307: l_chk_del_flag VARCHAR2(1) ;

Line 3304: ln_proc_level NUMBER := FND_LOG.level_procedure;

3300: lv_service_type_code VARCHAR2 (30);
3301: ln_batch_id NUMBER;
3302: ln_tax_category_id NUMBER;
3303: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3304: ln_proc_level NUMBER := FND_LOG.level_procedure;
3305: lv_proc_name VARCHAR2 (100) := 'Populate_Stnd_Inv_Taxes';
3306: ln_supplier_id NUMBER;
3307: l_chk_del_flag VARCHAR2(1) ;
3308: ln_tax_line_no NUMBER; -- Added by eric ma for the bug 6898716 on Mar 19,2008

Line 3418: FND_LOG.STRING ( ln_proc_level

3414: BEGIN
3415: --log for debug
3416: IF ( ln_proc_level >= ln_dbg_level)
3417: THEN
3418: FND_LOG.STRING ( ln_proc_level
3419: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
3420: , 'Enter procedure'
3421: );
3422: FND_LOG.STRING ( ln_proc_level

Line 3422: FND_LOG.STRING ( ln_proc_level

3418: FND_LOG.STRING ( ln_proc_level
3419: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
3420: , 'Enter procedure'
3421: );
3422: FND_LOG.STRING ( ln_proc_level
3423: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3424: , 'pn_invoice_id ' || pn_invoice_id
3425: );
3426: FND_LOG.STRING ( ln_proc_level

Line 3426: FND_LOG.STRING ( ln_proc_level

3422: FND_LOG.STRING ( ln_proc_level
3423: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3424: , 'pn_invoice_id ' || pn_invoice_id
3425: );
3426: FND_LOG.STRING ( ln_proc_level
3427: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3428: , 'pn_line_number ' || pn_line_number
3429: );
3430: FND_LOG.STRING ( ln_proc_level

Line 3430: FND_LOG.STRING ( ln_proc_level

3426: FND_LOG.STRING ( ln_proc_level
3427: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3428: , 'pn_line_number ' || pn_line_number
3429: );
3430: FND_LOG.STRING ( ln_proc_level
3431: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3432: , 'pn_vendor_site_id ' || pn_vendor_site_id
3433: );
3434: FND_LOG.STRING ( ln_proc_level

Line 3434: FND_LOG.STRING ( ln_proc_level

3430: FND_LOG.STRING ( ln_proc_level
3431: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3432: , 'pn_vendor_site_id ' || pn_vendor_site_id
3433: );
3434: FND_LOG.STRING ( ln_proc_level
3435: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3436: , 'pv_currency ' || pv_currency
3437: );
3438: FND_LOG.STRING ( ln_proc_level

Line 3438: FND_LOG.STRING ( ln_proc_level

3434: FND_LOG.STRING ( ln_proc_level
3435: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3436: , 'pv_currency ' || pv_currency
3437: );
3438: FND_LOG.STRING ( ln_proc_level
3439: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3440: , 'pn_line_amount ' || pn_line_amount
3441: );
3442: FND_LOG.STRING ( ln_proc_level

Line 3442: FND_LOG.STRING ( ln_proc_level

3438: FND_LOG.STRING ( ln_proc_level
3439: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3440: , 'pn_line_amount ' || pn_line_amount
3441: );
3442: FND_LOG.STRING ( ln_proc_level
3443: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3444: , 'pn_tax_category_id ' || pn_tax_category_id
3445: );
3446: FND_LOG.STRING ( ln_proc_level

Line 3446: FND_LOG.STRING ( ln_proc_level

3442: FND_LOG.STRING ( ln_proc_level
3443: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3444: , 'pn_tax_category_id ' || pn_tax_category_id
3445: );
3446: FND_LOG.STRING ( ln_proc_level
3447: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3448: , 'pv_tax_modified ' || pv_tax_modified
3449: );
3450: FND_LOG.STRING ( ln_proc_level

Line 3450: FND_LOG.STRING ( ln_proc_level

3446: FND_LOG.STRING ( ln_proc_level
3447: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3448: , 'pv_tax_modified ' || pv_tax_modified
3449: );
3450: FND_LOG.STRING ( ln_proc_level
3451: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3452: , 'pn_old_tax_category_id ' || pn_old_tax_category_id
3453: );
3454: END IF; --( ln_proc_level >= ln_dbg_level)

Line 3472: FND_LOG.STRING ( ln_proc_level

3468: FETCH cur_credit_memo_check INTO v_invoice_amount, v_invoice_source;
3469: CLOSE cur_credit_memo_check;
3470: IF ( ln_proc_level >= ln_dbg_level)
3471: THEN
3472: FND_LOG.STRING ( ln_proc_level
3473: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3474: , 'v_invoice_amount ' || v_invoice_amount||'-v_invoice_source:'||v_invoice_source
3475: );
3476: END IF;

Line 3480: FND_LOG.STRING ( ln_proc_level

3476: END IF;
3477: IF NVL(v_invoice_amount, 0) < 0 AND v_invoice_source = 'INDIA TDS' THEN
3478: IF ( ln_proc_level >= ln_dbg_level)
3479: THEN
3480: FND_LOG.STRING ( ln_proc_level
3481: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
3482: , 'Invoice is TDS Credit Memo so not defaulting Service tax'
3483: );
3484: END IF;

Line 3600: FND_LOG.STRING ( ln_proc_level

3596: --modified by eric ma on Mar 19 ,2008 for the bug 6898716 ,end
3597: THEN
3598: IF ( ln_proc_level >= ln_dbg_level)
3599: THEN
3600: FND_LOG.STRING ( ln_proc_level
3601: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3602: , 'Case 1'
3603: );
3604: END IF;-- ( ln_proc_level >= ln_dbg_level)

Line 3642: FND_LOG.STRING ( ln_proc_level

3638: )
3639: THEN
3640: IF ( ln_proc_level >= ln_dbg_level)
3641: THEN
3642: FND_LOG.STRING ( ln_proc_level
3643: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3644: , 'Case 2'
3645: );
3646: END IF;-- ( ln_proc_level >= ln_dbg_level)

Line 3753: FND_LOG.STRING ( ln_proc_level

3749: THEN
3750:
3751: IF ( ln_proc_level >= ln_dbg_level)
3752: THEN
3753: FND_LOG.STRING ( ln_proc_level
3754: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3755: , 'Case 3'
3756: );
3757: END IF; -- ( ln_proc_level >= ln_dbg_level)

Line 3830: FND_LOG.STRING ( ln_proc_level

3826: --insert into eric_log values ( 2.5,'Case 5',sysdate);
3827:
3828: IF ( ln_proc_level >= ln_dbg_level)
3829: THEN
3830: FND_LOG.STRING ( ln_proc_level
3831: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3832: , 'Case 5'
3833: );
3834: END IF; -- ( ln_proc_level >= ln_dbg_level)

Line 3861: FND_LOG.STRING ( ln_proc_level

3857: LOOP
3858:
3859: IF ( ln_proc_level >= ln_dbg_level)
3860: THEN
3861: FND_LOG.STRING ( ln_proc_level
3862: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3863: , 'Case 6'
3864: );
3865: END IF;-- ( ln_proc_level >= ln_dbg_level)

Line 3967: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes', 'ELSE ...');

3963: ELSE -- (Validate_Item_Dist_Lines not passed or Validate_3rd_party_cm_Invoice(ln_std_invoice_id) passed)
3964:
3965: --insert into eric_log values ( 1.20,'Error : Item_Dist_Lines_not_Validated or 3rd_party_cm_Invoice_validated',sysdate);
3966: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 begin
3967: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes', 'ELSE ...');
3968: --Added by Chong for ZX investigation 20120816 start
3969: ---------------------------------------------------------------------------
3970: FOR diff_inv_lines_rec IN diff_inv_lines_cur
3971: LOOP

Line 4015: FND_LOG.STRING ( ln_proc_level

4011:
4012: --log for debug
4013: IF ( ln_proc_level >= ln_dbg_level)
4014: THEN
4015: FND_LOG.STRING ( ln_proc_level
4016: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
4017: , 'Exit procedure'
4018: );
4019: END IF; --( ln_proc_level >= ln_dbg_level )

Line 4024: FND_LOG.STRING ( ln_proc_level

4020: EXCEPTION
4021: WHEN OTHERS THEN
4022: IF ( ln_proc_level >= ln_dbg_level)
4023: THEN
4024: FND_LOG.STRING ( ln_proc_level
4025: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
4026: || '. Other_Exception '
4027: , SQLCODE || ':' || SQLERRM
4028: );

Line 4040: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes', substr(SQLERRM,1,1900));

4036: --If unexcepted error here, we should raise error to AP workbench and display error message.
4037: --Added by Chong for ZX investigation 20120816 start
4038: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
4039: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes: ' || substr(SQLERRM,1,1900));
4040: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes', substr(SQLERRM,1,1900));
4041: app_exception.raise_exception;
4042: --Added by Chong for ZX investigation 20120816 end
4043: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
4044: END Populate_Stnd_Inv_Taxes;

Line 4095: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

4091: ln_line_number NUMBER := pn_line_number;
4092: lv_currency_code VARCHAR2 (15) := pv_currency_code;
4093: ln_tax_category_id NUMBER := pn_tax_category_id;
4094: ln_vendor_id NUMBER := pn_vendor_id;
4095: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4096: ln_proc_level NUMBER := FND_LOG.level_procedure;
4097: lv_proc_name VARCHAR2 (100) := 'Default_Calculate_Taxes';
4098: ln_user_id NUMBER := fnd_global.user_id;
4099: ln_login_id NUMBER := fnd_global.login_id;

Line 4096: ln_proc_level NUMBER := FND_LOG.level_procedure;

4092: lv_currency_code VARCHAR2 (15) := pv_currency_code;
4093: ln_tax_category_id NUMBER := pn_tax_category_id;
4094: ln_vendor_id NUMBER := pn_vendor_id;
4095: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4096: ln_proc_level NUMBER := FND_LOG.level_procedure;
4097: lv_proc_name VARCHAR2 (100) := 'Default_Calculate_Taxes';
4098: ln_user_id NUMBER := fnd_global.user_id;
4099: ln_login_id NUMBER := fnd_global.login_id;
4100: BEGIN

Line 4104: FND_LOG.STRING ( ln_proc_level

4100: BEGIN
4101: --log for debug
4102: IF ( ln_proc_level >= ln_dbg_level)
4103: THEN
4104: FND_LOG.STRING ( ln_proc_level
4105: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4106: , 'Enter procedure'
4107: );
4108: FND_LOG.STRING ( ln_proc_level

Line 4108: FND_LOG.STRING ( ln_proc_level

4104: FND_LOG.STRING ( ln_proc_level
4105: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4106: , 'Enter procedure'
4107: );
4108: FND_LOG.STRING ( ln_proc_level
4109: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4110: , 'pn_invoice_id ' || pn_invoice_id
4111: );
4112: FND_LOG.STRING ( ln_proc_level

Line 4112: FND_LOG.STRING ( ln_proc_level

4108: FND_LOG.STRING ( ln_proc_level
4109: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4110: , 'pn_invoice_id ' || pn_invoice_id
4111: );
4112: FND_LOG.STRING ( ln_proc_level
4113: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4114: , 'pn_line_number ' || pn_line_number
4115: );
4116: FND_LOG.STRING ( ln_proc_level

Line 4116: FND_LOG.STRING ( ln_proc_level

4112: FND_LOG.STRING ( ln_proc_level
4113: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4114: , 'pn_line_number ' || pn_line_number
4115: );
4116: FND_LOG.STRING ( ln_proc_level
4117: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4118: , 'pv_currency_code ' || pv_currency_code
4119: );
4120: FND_LOG.STRING ( ln_proc_level

Line 4120: FND_LOG.STRING ( ln_proc_level

4116: FND_LOG.STRING ( ln_proc_level
4117: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4118: , 'pv_currency_code ' || pv_currency_code
4119: );
4120: FND_LOG.STRING ( ln_proc_level
4121: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4122: , 'pn_tax_category_id ' || pn_tax_category_id
4123: );
4124: FND_LOG.STRING ( ln_proc_level

Line 4124: FND_LOG.STRING ( ln_proc_level

4120: FND_LOG.STRING ( ln_proc_level
4121: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4122: , 'pn_tax_category_id ' || pn_tax_category_id
4123: );
4124: FND_LOG.STRING ( ln_proc_level
4125: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4126: , 'pv_tax_modified ' || pv_tax_modified
4127: );
4128: FND_LOG.STRING ( ln_proc_level

Line 4128: FND_LOG.STRING ( ln_proc_level

4124: FND_LOG.STRING ( ln_proc_level
4125: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4126: , 'pv_tax_modified ' || pv_tax_modified
4127: );
4128: FND_LOG.STRING ( ln_proc_level
4129: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4130: , 'pn_vendor_id ' || pn_vendor_id
4131: );
4132: FND_LOG.STRING ( ln_proc_level

Line 4132: FND_LOG.STRING ( ln_proc_level

4128: FND_LOG.STRING ( ln_proc_level
4129: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4130: , 'pn_vendor_id ' || pn_vendor_id
4131: );
4132: FND_LOG.STRING ( ln_proc_level
4133: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4134: , 'pn_vendor_site_id ' || pn_vendor_site_id
4135: );
4136: END IF; --( ln_proc_level >= ln_dbg_level )

Line 4169: FND_LOG.STRING ( ln_proc_level

4165:
4166: --log for debug
4167: IF ( ln_proc_level >= ln_dbg_level)
4168: THEN
4169: FND_LOG.STRING ( ln_proc_level
4170: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
4171: , 'Exit procedure'
4172: );
4173: END IF; --( ln_proc_level >= ln_dbg_level )

Line 4178: FND_LOG.STRING ( ln_proc_level

4174: EXCEPTION
4175: WHEN OTHERS THEN
4176: IF ( ln_proc_level >= ln_dbg_level)
4177: THEN
4178: FND_LOG.STRING ( ln_proc_level
4179: , GV_MODULE_PREFIX || '.' || lv_proc_name
4180: || '. Other_Exception '
4181: , SQLCODE || ':' || SQLERRM
4182: );

Line 4222: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

4218: WHERE
4219: tax_id = pn_tax_id;
4220:
4221: lv_inclusive_tax_flag VARCHAR2(1);
4222: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4223: ln_proc_level NUMBER := FND_LOG.level_procedure;
4224: lv_proc_name VARCHAR2 (100) := 'Check_Inclusive_Tax';
4225: BEGIN
4226: OPEN get_inclusive_tax_flag;

Line 4223: ln_proc_level NUMBER := FND_LOG.level_procedure;

4219: tax_id = pn_tax_id;
4220:
4221: lv_inclusive_tax_flag VARCHAR2(1);
4222: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4223: ln_proc_level NUMBER := FND_LOG.level_procedure;
4224: lv_proc_name VARCHAR2 (100) := 'Check_Inclusive_Tax';
4225: BEGIN
4226: OPEN get_inclusive_tax_flag;
4227: FETCH get_inclusive_tax_flag

Line 4235: FND_LOG.STRING ( ln_proc_level

4231:
4232: --log for debug
4233: IF ( ln_proc_level >= ln_dbg_level)
4234: THEN
4235: FND_LOG.STRING ( ln_proc_level
4236: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4237: , 'Enter procedure'
4238: );
4239: FND_LOG.STRING ( ln_proc_level

Line 4239: FND_LOG.STRING ( ln_proc_level

4235: FND_LOG.STRING ( ln_proc_level
4236: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4237: , 'Enter procedure'
4238: );
4239: FND_LOG.STRING ( ln_proc_level
4240: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4241: , 'pn_tax_id ' || pn_tax_id
4242: );
4243: END IF;

Line 4247: FND_LOG.STRING ( ln_proc_level

4243: END IF;
4244: --log for debug
4245: IF ( ln_proc_level >= ln_dbg_level)
4246: THEN
4247: FND_LOG.STRING ( ln_proc_level
4248: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
4249: , 'Exit FUNCTION'
4250: );
4251: END IF; --( ln_proc_level >= ln_dbg_level )

Line 4264: FND_LOG.STRING ( ln_proc_level

4260: EXCEPTION
4261: WHEN OTHERS THEN
4262: IF ( ln_proc_level >= ln_dbg_level)
4263: THEN
4264: FND_LOG.STRING ( ln_proc_level
4265: , GV_MODULE_PREFIX || '.' || lv_proc_name
4266: || '. Other_Exception '
4267: , SQLCODE || ':' || SQLERRM
4268: );

Line 4305: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

4301: IS
4302: ln_count NUMBER;
4303: lv_pr_processed_flag VARCHAR2 (1) DEFAULT NULL;
4304:
4305: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4306: ln_proc_level NUMBER := FND_LOG.level_procedure;
4307: lv_proc_name VARCHAR2 (100) := 'Get_Pr_Processed_Flag';
4308: BEGIN
4309: --log for debug

Line 4306: ln_proc_level NUMBER := FND_LOG.level_procedure;

4302: ln_count NUMBER;
4303: lv_pr_processed_flag VARCHAR2 (1) DEFAULT NULL;
4304:
4305: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4306: ln_proc_level NUMBER := FND_LOG.level_procedure;
4307: lv_proc_name VARCHAR2 (100) := 'Get_Pr_Processed_Flag';
4308: BEGIN
4309: --log for debug
4310: IF ( ln_proc_level >= ln_dbg_level)

Line 4312: FND_LOG.STRING ( ln_proc_level

4308: BEGIN
4309: --log for debug
4310: IF ( ln_proc_level >= ln_dbg_level)
4311: THEN
4312: FND_LOG.STRING ( ln_proc_level
4313: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4314: , 'Enter procedure'
4315: );
4316: FND_LOG.STRING ( ln_proc_level

Line 4316: FND_LOG.STRING ( ln_proc_level

4312: FND_LOG.STRING ( ln_proc_level
4313: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
4314: , 'Enter procedure'
4315: );
4316: FND_LOG.STRING ( ln_proc_level
4317: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4318: , 'pn_source_doc_id ' || pn_source_doc_id
4319: );
4320: FND_LOG.STRING ( ln_proc_level

Line 4320: FND_LOG.STRING ( ln_proc_level

4316: FND_LOG.STRING ( ln_proc_level
4317: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4318: , 'pn_source_doc_id ' || pn_source_doc_id
4319: );
4320: FND_LOG.STRING ( ln_proc_level
4321: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4322: , 'pn_source_parent_line_no ' || pn_source_parent_line_no
4323: );
4324: FND_LOG.STRING ( ln_proc_level

Line 4324: FND_LOG.STRING ( ln_proc_level

4320: FND_LOG.STRING ( ln_proc_level
4321: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4322: , 'pn_source_parent_line_no ' || pn_source_parent_line_no
4323: );
4324: FND_LOG.STRING ( ln_proc_level
4325: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4326: , 'pn_tax_id ' || pn_tax_id
4327: );
4328: END IF;--( ln_proc_level >= ln_dbg_level)

Line 4351: FND_LOG.STRING ( ln_proc_level

4347: END IF;
4348:
4349: IF ( ln_proc_level >= ln_dbg_level)
4350: THEN
4351: FND_LOG.STRING ( ln_proc_level
4352: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4353: , 'lv_pr_processed_flag ' || lv_pr_processed_flag
4354: );
4355: FND_LOG.STRING ( ln_proc_level

Line 4355: FND_LOG.STRING ( ln_proc_level

4351: FND_LOG.STRING ( ln_proc_level
4352: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
4353: , 'lv_pr_processed_flag ' || lv_pr_processed_flag
4354: );
4355: FND_LOG.STRING ( ln_proc_level
4356: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
4357: , 'Exit FUNCTION'
4358: );
4359: END IF; --( ln_proc_level >= ln_dbg_level )

Line 4366: FND_LOG.STRING ( ln_proc_level

4362: EXCEPTION
4363: WHEN OTHERS THEN
4364: IF ( ln_proc_level >= ln_dbg_level)
4365: THEN
4366: FND_LOG.STRING ( ln_proc_level
4367: , GV_MODULE_PREFIX || '.' || lv_proc_name
4368: || '. Other_Exception '
4369: , SQLCODE || ':' || SQLERRM
4370: );

Line 4826: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

4822: lv_asset_book_type_code
4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4824: ln_asset_category_id
4825: ap_invoice_distributions_all.asset_category_id%TYPE;
4826: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4827: ln_proc_level NUMBER := FND_LOG.level_procedure;
4828: lv_proc_name VARCHAR2 (100):= 'Create_Tax_Lines';
4829: ln_user_id NUMBER := fnd_global.user_id;
4830: ln_login_id NUMBER := fnd_global.login_id;

Line 4827: ln_proc_level NUMBER := FND_LOG.level_procedure;

4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4824: ln_asset_category_id
4825: ap_invoice_distributions_all.asset_category_id%TYPE;
4826: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4827: ln_proc_level NUMBER := FND_LOG.level_procedure;
4828: lv_proc_name VARCHAR2 (100):= 'Create_Tax_Lines';
4829: ln_user_id NUMBER := fnd_global.user_id;
4830: ln_login_id NUMBER := fnd_global.login_id;
4831:

Line 5224: FND_LOG.STRING ( ln_proc_level

5220:
5221: --log for debug
5222: IF ( ln_proc_level >= ln_dbg_level)
5223: THEN
5224: FND_LOG.STRING ( ln_proc_level
5225: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
5226: , 'Enter procedure'
5227: );
5228: FND_LOG.STRING ( ln_proc_level

Line 5228: FND_LOG.STRING ( ln_proc_level

5224: FND_LOG.STRING ( ln_proc_level
5225: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.begin'
5226: , 'Enter procedure'
5227: );
5228: FND_LOG.STRING ( ln_proc_level
5229: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5230: , 'pn_invoice_id ' || pn_invoice_id
5231: );
5232: FND_LOG.STRING ( ln_proc_level

Line 5232: FND_LOG.STRING ( ln_proc_level

5228: FND_LOG.STRING ( ln_proc_level
5229: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5230: , 'pn_invoice_id ' || pn_invoice_id
5231: );
5232: FND_LOG.STRING ( ln_proc_level
5233: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5234: , 'pn_line_number ' || pn_line_number
5235: );
5236: FND_LOG.STRING ( ln_proc_level

Line 5236: FND_LOG.STRING ( ln_proc_level

5232: FND_LOG.STRING ( ln_proc_level
5233: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5234: , 'pn_line_number ' || pn_line_number
5235: );
5236: FND_LOG.STRING ( ln_proc_level
5237: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5238: , 'pv_tax_modified ' || pv_tax_modified
5239: );
5240: FND_LOG.STRING ( ln_proc_level

Line 5240: FND_LOG.STRING ( ln_proc_level

5236: FND_LOG.STRING ( ln_proc_level
5237: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5238: , 'pv_tax_modified ' || pv_tax_modified
5239: );
5240: FND_LOG.STRING ( ln_proc_level
5241: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5242: , 'pn_organization_id ' || pn_organization_id
5243: );
5244: FND_LOG.STRING ( ln_proc_level

Line 5244: FND_LOG.STRING ( ln_proc_level

5240: FND_LOG.STRING ( ln_proc_level
5241: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5242: , 'pn_organization_id ' || pn_organization_id
5243: );
5244: FND_LOG.STRING ( ln_proc_level
5245: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5246: , 'pn_location_id ' || pn_location_id
5247: );
5248: FND_LOG.STRING ( ln_proc_level

Line 5248: FND_LOG.STRING ( ln_proc_level

5244: FND_LOG.STRING ( ln_proc_level
5245: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5246: , 'pn_location_id ' || pn_location_id
5247: );
5248: FND_LOG.STRING ( ln_proc_level
5249: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5250: , 'pv_currency ' || pv_currency
5251: );
5252: FND_LOG.STRING ( ln_proc_level

Line 5252: FND_LOG.STRING ( ln_proc_level

5248: FND_LOG.STRING ( ln_proc_level
5249: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5250: , 'pv_currency ' || pv_currency
5251: );
5252: FND_LOG.STRING ( ln_proc_level
5253: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.parameters'
5254: , 'pn_tax_category_id ' || pn_tax_category_id
5255: );
5256: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5299: FND_LOG.STRING ( ln_proc_level

5295:
5296: --log for debug
5297: IF ( ln_proc_level >= ln_dbg_level)
5298: THEN
5299: FND_LOG.STRING ( ln_proc_level
5300: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.debug Info.'
5301: , 'Item Loop of First Time '
5302: );
5303: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5464: FND_LOG.STRING ( ln_proc_level

5460:
5461: --log for debug
5462: IF ( ln_proc_level >= ln_dbg_level)
5463: THEN
5464: FND_LOG.STRING ( ln_proc_level
5465: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ap_invoice_lines_rec.line_number'
5466: , ap_invoice_lines_rec.line_number
5467: );
5468:

Line 5469: FND_LOG.STRING ( ln_proc_level

5465: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ap_invoice_lines_rec.line_number'
5466: , ap_invoice_lines_rec.line_number
5467: );
5468:
5469: FND_LOG.STRING ( ln_proc_level
5470: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.lv_tax_type'
5471: , lv_tax_type
5472: );
5473: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5550: FND_LOG.STRING ( ln_proc_level

5546:
5547: --log for debug
5548: IF ( ln_proc_level >= ln_dbg_level)
5549: THEN
5550: FND_LOG.STRING ( ln_proc_level
5551: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_recur_tax_amt'
5552: , ln_recur_tax_amt
5553: );
5554:

Line 5555: FND_LOG.STRING ( ln_proc_level

5551: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_recur_tax_amt'
5552: , ln_recur_tax_amt
5553: );
5554:
5555: FND_LOG.STRING ( ln_proc_level
5556: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_recur_func_tax_amt'
5557: , ln_recur_func_tax_amt
5558: );
5559: FND_LOG.STRING ( ln_proc_level

Line 5559: FND_LOG.STRING ( ln_proc_level

5555: FND_LOG.STRING ( ln_proc_level
5556: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_recur_func_tax_amt'
5557: , ln_recur_func_tax_amt
5558: );
5559: FND_LOG.STRING ( ln_proc_level
5560: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_nrecur_tax_amt'
5561: , ln_nrecur_tax_amt
5562: );
5563: FND_LOG.STRING ( ln_proc_level

Line 5563: FND_LOG.STRING ( ln_proc_level

5559: FND_LOG.STRING ( ln_proc_level
5560: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_nrecur_tax_amt'
5561: , ln_nrecur_tax_amt
5562: );
5563: FND_LOG.STRING ( ln_proc_level
5564: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.ln_nrecur_func_tax_amt'
5565: , ln_nrecur_func_tax_amt
5566: );
5567: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5578: FND_LOG.STRING ( ln_proc_level

5574:
5575: --log for debug
5576: IF ( ln_proc_level >= ln_dbg_level)
5577: THEN
5578: FND_LOG.STRING ( ln_proc_level
5579: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.i'
5580: , i
5581: );
5582: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5701: FND_LOG.STRING ( ln_proc_level

5697:
5698: --log for debug
5699: IF ( ln_proc_level >= ln_dbg_level)
5700: THEN
5701: FND_LOG.STRING ( ln_proc_level
5702: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.debug Info.'
5703: , 'Item Loop of Second Time '
5704: );
5705: END IF; --( ln_proc_level >= ln_dbg_level )

Line 5869: FND_LOG.STRING ( ln_proc_level

5865: --insert into eric_log values (7.82,'lv_insert_jai_inv_sql executed for item line number :'|| ap_invoice_lines_rec.line_number,sysdate);
5866: --log for debug
5867: IF ( ln_proc_level >= ln_dbg_level)
5868: THEN
5869: FND_LOG.STRING ( ln_proc_level
5870: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5871: || '.debug Info.'
5872: , 'Table jai_ap_invoice_lines inserted '
5873: );

Line 5916: FND_LOG.STRING ( ln_proc_level

5912:
5913: --log for debug
5914: IF ( ln_proc_level >= ln_dbg_level)
5915: THEN
5916: FND_LOG.STRING ( ln_proc_level
5917: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5918: || '.debug Info.'
5919: , 'Table ap_invoice_lines_all inserted '
5920: );

Line 6113: FND_LOG.STRING ( ln_proc_level

6109: --insert into eric_log values (7.84,'lv_insert_ap_inv_dist_ln_sql executed for item line number :'|| ap_invoice_lines_rec.line_number,sysdate);
6110: --log for debug
6111: IF ( ln_proc_level >= ln_dbg_level)
6112: THEN
6113: FND_LOG.STRING ( ln_proc_level
6114: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
6115: || '.debug Info.'
6116: , 'Table ap_distribution_lines_all inserted '
6117: );

Line 6686: FND_LOG.STRING ( ln_proc_level

6682:
6683: --log for debug
6684: IF ( ln_proc_level >= ln_dbg_level)
6685: THEN
6686: FND_LOG.STRING ( ln_proc_level
6687: , GV_MODULE_PREFIX ||'.'|| lv_proc_name || '.end'
6688: , 'Exit procedure'
6689: );
6690: END IF; --( ln_proc_level >= ln_dbg_level )

Line 6696: FND_LOG.STRING ( ln_proc_level

6692: EXCEPTION
6693: WHEN OTHERS THEN
6694: IF ( ln_proc_level >= ln_dbg_level)
6695: THEN
6696: FND_LOG.STRING ( ln_proc_level
6697: , GV_MODULE_PREFIX|| '.'|| lv_proc_name
6698: || '. Other_Exception '
6699: , SQLCODE || ':' || SQLERRM
6700: );