DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_DEBUG

Line 8: PA_DEBUG.g_err_stage := p_msg;

4: PROCEDURE print_msg(p_msg varchar2) IS
5: BEGIN
6: --dbms_output.put_line('Log:'||p_msg);
7: --r_debug.r_msg('Log:'||p_msg);
8: PA_DEBUG.g_err_stage := p_msg;
9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
10: NULL;
11:
12: END print_msg;

Line 9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

5: BEGIN
6: --dbms_output.put_line('Log:'||p_msg);
7: --r_debug.r_msg('Log:'||p_msg);
8: PA_DEBUG.g_err_stage := p_msg;
9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
10: NULL;
11:
12: END print_msg;
13:

Line 468: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

464: END Validate_changeamt ;
465:
466:
467: BEGIN
468: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
469: l_debug_mode := NVL(l_debug_mode, 'N');
470: --x_PO_HEADER_ID := 44878;
471: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
472:

Line 471: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

467: BEGIN
468: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
469: l_debug_mode := NVL(l_debug_mode, 'N');
470: --x_PO_HEADER_ID := 44878;
471: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
472:
473: /** reset the return status and error msg code **/
474: x_return_status := 'S';
475: x_error_msg_code := NULL;

Line 598: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

594:
595:
596:
597: BEGIN
598: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
599: l_debug_mode := NVL(l_debug_mode, 'N');
600:
601: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
602:

Line 601: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

597: BEGIN
598: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
599: l_debug_mode := NVL(l_debug_mode, 'N');
600:
601: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
602:
603: -- initialize the error stack
604: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');
605:

Line 604: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');

600:
601: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
602:
603: -- initialize the error stack
604: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');
605:
606: /** clear the message stack **/
607: fnd_msg_pub.INITIALIZE;
608:

Line 829: pa_debug.reset_err_stack;

825:
826:
827: END IF;
828:
829: pa_debug.reset_err_stack;
830: EXCEPTION
831: when others then
832: x_return_status := 'U';
833: x_msg_count := 1;

Line 835: pa_debug.reset_err_stack;

831: when others then
832: x_return_status := 'U';
833: x_msg_count := 1;
834: x_msg_data := SQLCODE||SQLERRM;
835: pa_debug.reset_err_stack;
836: RAISE;
837:
838: END validate_insert_SI;
839:

Line 905: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

901:
902:
903:
904: BEGIN
905: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
906: l_debug_mode := NVL(l_debug_mode, 'N');
907:
908: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
909:

Line 908: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

904: BEGIN
905: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
906: l_debug_mode := NVL(l_debug_mode, 'N');
907:
908: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
909:
910: -- initialize the error stack
911: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');
912:

Line 911: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');

907:
908: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
909:
910: -- initialize the error stack
911: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');
912:
913: /** clear the message stack **/
914: fnd_msg_pub.INITIALIZE;
915:

Line 1252: pa_debug.reset_err_stack;

1248: x_msg_count := l_msg_count;
1249: x_msg_data := null;
1250: End if;
1251: END IF; -- end of p_callingModule
1252: pa_debug.reset_err_stack;
1253: EXCEPTION
1254: when others then
1255: x_return_status := 'U';
1256: x_msg_count := 1;

Line 1258: pa_debug.reset_err_stack;

1254: when others then
1255: x_return_status := 'U';
1256: x_msg_count := 1;
1257: x_msg_data := SQLCODE||SQLERRM;
1258: pa_debug.reset_err_stack;
1259: RAISE;
1260: END validateSI;
1261:
1262: PROCEDURE deleteSIrecord(P_CALLING_MODE IN varchar2

Line 1271: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1267: ,X_MSG_COUNT IN OUT NOCOPY number ) IS
1268:
1269: l_debug_mode varchar2(1) := 'N';
1270: BEGIN
1271: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1272: l_debug_mode := NVL(l_debug_mode, 'N');
1273:
1274: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1275:

Line 1274: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1270: BEGIN
1271: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1272: l_debug_mode := NVL(l_debug_mode, 'N');
1273:
1274: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1275:
1276: -- initialize the error stack
1277: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');
1278: IF l_debug_mode = 'Y' THEN

Line 1277: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');

1273:
1274: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1275:
1276: -- initialize the error stack
1277: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');
1278: IF l_debug_mode = 'Y' THEN
1279: print_msg('inside deleteSIrecord api P_CALLING_MODE['||P_CALLING_MODE||']p_ROWID['||p_ROWID||
1280: '] P_CI_TRANSACTION_ID['||P_CI_TRANSACTION_ID||']');
1281: End If;

Line 1296: pa_debug.reset_err_stack;

1292:
1293: End if;
1294:
1295:
1296: pa_debug.reset_err_stack;
1297: EXCEPTION
1298: when others then
1299: IF l_debug_mode = 'Y' THEN
1300: print_msg('deleteSIrecord Error:'||sqlcode||sqlerrm);

Line 1324: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1320:
1321: l_debug_mode varchar2(1) := 'N';
1322:
1323: BEGIN
1324: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1325: l_debug_mode := NVL(l_debug_mode, 'N');
1326:
1327: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1328:

Line 1327: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1323: BEGIN
1324: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1325: l_debug_mode := NVL(l_debug_mode, 'N');
1326:
1327: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1328:
1329: IF l_debug_mode = 'Y' THEN
1330: print_msg('Inside Merge_suppliers Api params p_from_ci_item_id['||p_from_ci_item_id||
1331: ']p_to_ci_item_id['||p_to_ci_item_id||']' );

Line 1408: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1404:
1405: l_debug_mode varchar2(1) := 'N';
1406:
1407: BEGIN
1408: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1409: l_debug_mode := NVL(l_debug_mode, 'N');
1410:
1411: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1412:

Line 1411: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1407: BEGIN
1408: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1409: l_debug_mode := NVL(l_debug_mode, 'N');
1410:
1411: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1412:
1413: -- initialize the error stack
1414: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1415: IF l_debug_mode = 'Y' THEN

Line 1414: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');

1410:
1411: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1412:
1413: -- initialize the error stack
1414: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1415: IF l_debug_mode = 'Y' THEN
1416: print_msg('Inside DELETE_IMPACT api p_ci_id['||p_ci_id||']' );
1417: End If;
1418:

Line 1430: pa_debug.reset_err_stack;

1426: commit;
1427:
1428: End if;
1429:
1430: pa_debug.reset_err_stack;
1431: EXCEPTION
1432: when others then
1433: IF l_debug_mode = 'Y' THEN
1434: print_msg('sqlerror:'||sqlcode||sqlerrm);

Line 1439: pa_debug.reset_err_stack;

1435: End If;
1436: x_return_status := 'U';
1437: x_msg_count := 1;
1438: x_msg_data := SQLCODE||SQLERRM;
1439: pa_debug.reset_err_stack;
1440: RAISE;
1441:
1442: END DELETE_IMPACT;
1443:

Line 1466: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1462: l_msg_index_out Number;
1463: l_debug_mode varchar2(1) := 'N';
1464:
1465: BEGIN
1466: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1467: l_debug_mode := NVL(l_debug_mode, 'N');
1468:
1469: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1470:

Line 1469: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1465: BEGIN
1466: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1467: l_debug_mode := NVL(l_debug_mode, 'N');
1468:
1469: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1470:
1471: -- initialize the error stack
1472: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1473:

Line 1472: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');

1468:
1469: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1470:
1471: -- initialize the error stack
1472: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1473:
1474: /** clear the message stack **/
1475: fnd_msg_pub.INITIALIZE;
1476:

Line 1515: pa_debug.reset_err_stack;

1511: );
1512:
1513: End if;
1514: -- Reset the error stack
1515: pa_debug.reset_err_stack;
1516:
1517: EXCEPTION
1518:
1519: WHEN OTHERS THEN

Line 1526: pa_debug.reset_err_stack;

1522: End If;
1523: x_return_status := 'U';
1524: x_msg_count := 1;
1525: x_msg_data := SQLCODE||SQLERRM;
1526: pa_debug.reset_err_stack;
1527: RAISE;
1528:
1529: END IS_SI_DELETE_OK;
1530:

Line 1643: pa_debug.reset_err_stack;

1639:
1640: x_return_status := 'U';
1641: x_msg_count := 1;
1642: x_msg_data := SQLCODE||SQLERRM;
1643: pa_debug.reset_err_stack;
1644: RAISE;
1645:
1646: end GET_Original_Ci_ID;
1647:

Line 1700: pa_debug.reset_err_stack;

1696:
1697: x_return_status := 'U';
1698: x_msg_count := 1;
1699: x_msg_data := SQLCODE||SQLERRM;
1700: pa_debug.reset_err_stack;
1701: RAISE;
1702:
1703: end GET_RESOURCE_LIST_ID;
1704:

Line 1732: pa_debug.reset_err_stack;

1728: WHEN OTHERS THEN
1729: x_return_status := 'U';
1730: x_msg_count := 1;
1731: x_msg_data := SQLCODE||SQLERRM;
1732: pa_debug.reset_err_stack;
1733: RAISE;
1734:
1735: end GET_TOTAL_COST;
1736: