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.PO_LOG dependencies on FND_LOG

Line 163: fnd_log_repository.init;

159: fnd_profile.put('AFLOG_ENABLED', 'Y');
160: fnd_profile.put('AFLOG_MODULE', '%');
161: fnd_profile.put('AFLOG_LEVEL','1');
162: fnd_profile.put('AFLOG_FILENAME', '');
163: fnd_log_repository.init;
164:
165: Do not ship any code with these calls! Shipping code that internally
166: hard codes Log Properties is a severe P1 bug.
167: ...

Line 236: from fnd_log_messages

232:
233: After the code was executed, the messages were inspected like so:
234:
235: select module,message_text,timestamp, log_sequence
236: from fnd_log_messages
237: where log_sequence
238: between
239: ( select max(log_sequence)
240: from fnd_log_messages

Line 240: from fnd_log_messages

236: from fnd_log_messages
237: where log_sequence
238: between
239: ( select max(log_sequence)
240: from fnd_log_messages
241: where module = 'po.plsql.SBULL.TEST.BEGIN'
242: )
243: and
244: ( select max(log_sequence)

Line 245: from fnd_log_messages

241: where module = 'po.plsql.SBULL.TEST.BEGIN'
242: )
243: and
244: ( select max(log_sequence)
245: from fnd_log_messages
246: where module = 'po.plsql.SBULL.TEST.END'
247: )
248: order by log_sequence
249: ;

Line 323: -- This procedure updates the FND Logging profile options and the cached

319: --Function:
320: --
321: -- *** DO NOT USE IN PRODUCTION CODE! ***
322: --
323: -- This procedure updates the FND Logging profile options and the cached
324: -- values in this package to enable logging for the current responsibility
325: -- for the session.
326: --
327: -- This should only be used while trying to debug a problem, as a

Line 361: FND_LOG_REPOSITORY.init();

357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
359:
360: -- Refresh the FND cache.
361: FND_LOG_REPOSITORY.init();
362:
363: -- Refresh the PO cache.
364: refresh_log_flags();
365:

Line 394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

390: l_current_log_level NUMBER;
391: BEGIN
392:
393: IF (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') THEN
394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);

Line 395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);

391: BEGIN
392:
393: IF (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') THEN
394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);

Line 396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);

392:
393: IF (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') THEN
394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);
400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);

Line 397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);

393: IF (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') THEN
394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);
400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);
401: ELSE

Line 398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);

394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);
400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);
401: ELSE
402: d_stmt := FALSE;

Line 399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);

395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);
400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);
401: ELSE
402: d_stmt := FALSE;
403: d_proc := FALSE;

Line 400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);

396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);
398: d_exc := (l_current_log_level <= FND_LOG.LEVEL_EXCEPTION);
399: d_error := (l_current_log_level <= FND_LOG.LEVEL_ERROR);
400: d_unexp := (l_current_log_level <= FND_LOG.LEVEL_UNEXPECTED);
401: ELSE
402: d_stmt := FALSE;
403: d_proc := FALSE;
404: d_event := FALSE;

Line 491: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

487: , p_message_text IN VARCHAR2
488: )
489: IS
490: BEGIN
491: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.string(p_log_level,p_module_base||p_module_suffix,p_message_text);
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN

Line 492: FND_LOG.string(p_log_level,p_module_base||p_module_suffix,p_message_text);

488: )
489: IS
490: BEGIN
491: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.string(p_log_level,p_module_base||p_module_suffix,p_message_text);
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN
496: NULL;

Line 572: x_log_level := FND_LOG.LEVEL_PROCEDURE;

568: WHEN c_PROC_RETURN THEN D_RETURN||D_MODULE_SEPARATOR||x_module_suffix
569: WHEN c_PROC_RAISE THEN D_RAISE||D_MODULE_SEPARATOR||x_module_suffix
570: ELSE x_module_suffix
571: END;
572: x_log_level := FND_LOG.LEVEL_PROCEDURE;
573: END IF;
574: END decode_level_suffix;
575:
576: ----------------------------------------------------------------------

Line 839: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),p_message_text);

835: , p_message_text IN VARCHAR2 DEFAULT NULL
836: )
837: IS
838: BEGIN
839: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),p_message_text);
840: END stmt;
841:
842: PROCEDURE stmt(
843: p_module_base IN VARCHAR2

Line 850: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

846: , p_variable_value IN VARCHAR2
847: )
848: IS
849: BEGIN
850: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
851: var_to_string(p_variable_name,p_variable_value));
852: END stmt;
853:
854: PROCEDURE stmt(

Line 862: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

858: , p_variable_value IN NUMBER
859: )
860: IS
861: BEGIN
862: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
863: var_to_string(p_variable_name,p_variable_value));
864: END stmt;
865:
866: PROCEDURE stmt(

Line 874: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

870: , p_variable_value IN DATE
871: )
872: IS
873: BEGIN
874: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
875: var_to_string(p_variable_name,p_variable_value));
876: END stmt;
877:
878: PROCEDURE stmt(

Line 886: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

882: , p_variable_value IN BOOLEAN
883: )
884: IS
885: BEGIN
886: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
887: var_to_string(p_variable_name,p_variable_value));
888: END stmt;
889:
890: PROCEDURE stmt(

Line 898: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

894: , p_variable_value IN PO_TBL_NUMBER
895: )
896: IS
897: BEGIN
898: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
899: p_variable_name,p_variable_value);
900: END stmt;
901:
902: PROCEDURE stmt(

Line 910: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

906: , p_variable_value IN PO_TBL_DATE
907: )
908: IS
909: BEGIN
910: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
911: p_variable_name,p_variable_value);
912: END stmt;
913:
914: PROCEDURE stmt(

Line 922: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

918: , p_variable_value IN PO_TBL_VARCHAR1
919: )
920: IS
921: BEGIN
922: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
923: p_variable_name,p_variable_value);
924: END stmt;
925:
926: PROCEDURE stmt(

Line 934: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

930: , p_variable_value IN PO_TBL_VARCHAR5
931: )
932: IS
933: BEGIN
934: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
935: p_variable_name,p_variable_value);
936: END stmt;
937:
938: PROCEDURE stmt(

Line 946: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

942: , p_variable_value IN PO_TBL_VARCHAR30
943: )
944: IS
945: BEGIN
946: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
947: p_variable_name,p_variable_value);
948: END stmt;
949:
950: PROCEDURE stmt(

Line 958: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

954: , p_variable_value IN PO_TBL_VARCHAR100
955: )
956: IS
957: BEGIN
958: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
959: p_variable_name,p_variable_value);
960: END stmt;
961:
962: PROCEDURE stmt(

Line 970: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

966: , p_variable_value IN PO_TBL_VARCHAR2000
967: )
968: IS
969: BEGIN
970: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
971: p_variable_name,p_variable_value);
972: END stmt;
973:
974: PROCEDURE stmt(

Line 982: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),

978: , p_variable_value IN PO_TBL_VARCHAR4000
979: )
980: IS
981: BEGIN
982: log(FND_LOG.LEVEL_STATEMENT,p_module_base,TO_CHAR(p_position),
983: p_variable_name,p_variable_value);
984: END stmt;
985:
986: -------------------------------------------------------------------------------

Line 989: --Modifies: FND_LOG_MESSAGES

985:
986: -------------------------------------------------------------------------------
987: --Start of Comments
988: --Pre-reqs: None.
989: --Modifies: FND_LOG_MESSAGES
990: --Locks: None.
991: --Function:
992: -- Logs STATEMENT-level messages containing data from PO_SESSION_GT.
993: --Parameters:

Line 1043: --Modifies: FND_LOG_MESSAGES

1039:
1040: -------------------------------------------------------------------------------
1041: --Start of Comments
1042: --Pre-reqs: None.
1043: --Modifies: FND_LOG_MESSAGES
1044: --Locks: None.
1045: --Function:
1046: -- Logs STATEMENT-level messages containing data from the specified table.
1047: --Parameters:

Line 1325: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,D_START_OF_SUBPROGRAM);

1321: p_module_base IN VARCHAR2
1322: )
1323: IS
1324: BEGIN
1325: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,D_START_OF_SUBPROGRAM);
1326: END proc_begin;
1327:
1328: PROCEDURE proc_begin(
1329: p_module_base IN VARCHAR2

Line 1335: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1331: , p_parameter_value IN VARCHAR2
1332: )
1333: IS
1334: BEGIN
1335: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1336: var_to_string(p_parameter_name,p_parameter_value));
1337: END proc_begin;
1338:
1339: PROCEDURE proc_begin(

Line 1346: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1342: , p_parameter_value IN NUMBER
1343: )
1344: IS
1345: BEGIN
1346: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1347: var_to_string(p_parameter_name,p_parameter_value));
1348: END proc_begin;
1349:
1350: PROCEDURE proc_begin(

Line 1357: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1353: , p_parameter_value IN DATE
1354: )
1355: IS
1356: BEGIN
1357: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1358: var_to_string(p_parameter_name,p_parameter_value));
1359: END proc_begin;
1360:
1361: PROCEDURE proc_begin(

Line 1368: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1364: , p_parameter_value IN BOOLEAN
1365: )
1366: IS
1367: BEGIN
1368: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1369: var_to_string(p_parameter_name,p_parameter_value));
1370: END proc_begin;
1371:
1372: PROCEDURE proc_begin(

Line 1379: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1375: , p_parameter_value IN PO_TBL_NUMBER
1376: )
1377: IS
1378: BEGIN
1379: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1380: p_parameter_name,p_parameter_value);
1381: END proc_begin;
1382:
1383: PROCEDURE proc_begin(

Line 1390: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1386: , p_parameter_value IN PO_TBL_DATE
1387: )
1388: IS
1389: BEGIN
1390: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1391: p_parameter_name,p_parameter_value);
1392: END proc_begin;
1393:
1394: PROCEDURE proc_begin(

Line 1401: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1397: , p_parameter_value IN PO_TBL_VARCHAR1
1398: )
1399: IS
1400: BEGIN
1401: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1402: p_parameter_name,p_parameter_value);
1403: END proc_begin;
1404:
1405: PROCEDURE proc_begin(

Line 1412: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1408: , p_parameter_value IN PO_TBL_VARCHAR5
1409: )
1410: IS
1411: BEGIN
1412: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1413: p_parameter_name,p_parameter_value);
1414: END proc_begin;
1415:
1416: PROCEDURE proc_begin(

Line 1423: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1419: , p_parameter_value IN PO_TBL_VARCHAR30
1420: )
1421: IS
1422: BEGIN
1423: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1424: p_parameter_name,p_parameter_value);
1425: END proc_begin;
1426:
1427: PROCEDURE proc_begin(

Line 1434: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1430: , p_parameter_value IN PO_TBL_VARCHAR100
1431: )
1432: IS
1433: BEGIN
1434: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1435: p_parameter_name,p_parameter_value);
1436: END proc_begin;
1437:
1438: PROCEDURE proc_begin(

Line 1445: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1441: , p_parameter_value IN PO_TBL_VARCHAR2000
1442: )
1443: IS
1444: BEGIN
1445: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1446: p_parameter_name,p_parameter_value);
1447: END proc_begin;
1448:
1449: PROCEDURE proc_begin(

Line 1456: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,

1452: , p_parameter_value IN PO_TBL_VARCHAR4000
1453: )
1454: IS
1455: BEGIN
1456: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1457: p_parameter_name,p_parameter_value);
1458: END proc_begin;
1459:
1460: PROCEDURE proc_end(

Line 1465: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,D_END_OF_SUBPROGRAM);

1461: p_module_base IN VARCHAR2
1462: )
1463: IS
1464: BEGIN
1465: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,D_END_OF_SUBPROGRAM);
1466: END proc_end;
1467:
1468: PROCEDURE proc_end(
1469: p_module_base IN VARCHAR2

Line 1475: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1471: , p_parameter_value IN VARCHAR2
1472: )
1473: IS
1474: BEGIN
1475: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1476: var_to_string(p_parameter_name,p_parameter_value));
1477: END proc_end;
1478:
1479: PROCEDURE proc_end(

Line 1486: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1482: , p_parameter_value IN NUMBER
1483: )
1484: IS
1485: BEGIN
1486: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1487: var_to_string(p_parameter_name,p_parameter_value));
1488: END proc_end;
1489:
1490: PROCEDURE proc_end(

Line 1497: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1493: , p_parameter_value IN DATE
1494: )
1495: IS
1496: BEGIN
1497: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1498: var_to_string(p_parameter_name,p_parameter_value));
1499: END proc_end;
1500:
1501: PROCEDURE proc_end(

Line 1508: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1504: , p_parameter_value IN BOOLEAN
1505: )
1506: IS
1507: BEGIN
1508: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1509: var_to_string(p_parameter_name,p_parameter_value));
1510: END proc_end;
1511:
1512: PROCEDURE proc_end(

Line 1519: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1515: , p_parameter_value IN PO_TBL_NUMBER
1516: )
1517: IS
1518: BEGIN
1519: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1520: p_parameter_name,p_parameter_value);
1521: END proc_end;
1522:
1523: PROCEDURE proc_end(

Line 1530: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1526: , p_parameter_value IN PO_TBL_DATE
1527: )
1528: IS
1529: BEGIN
1530: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1531: p_parameter_name,p_parameter_value);
1532: END proc_end;
1533:
1534: PROCEDURE proc_end(

Line 1541: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1537: , p_parameter_value IN PO_TBL_VARCHAR1
1538: )
1539: IS
1540: BEGIN
1541: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1542: p_parameter_name,p_parameter_value);
1543: END proc_end;
1544:
1545: PROCEDURE proc_end(

Line 1552: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1548: , p_parameter_value IN PO_TBL_VARCHAR5
1549: )
1550: IS
1551: BEGIN
1552: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1553: p_parameter_name,p_parameter_value);
1554: END proc_end;
1555:
1556: PROCEDURE proc_end(

Line 1563: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1559: , p_parameter_value IN PO_TBL_VARCHAR30
1560: )
1561: IS
1562: BEGIN
1563: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1564: p_parameter_name,p_parameter_value);
1565: END proc_end;
1566:
1567: PROCEDURE proc_end(

Line 1574: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1570: , p_parameter_value IN PO_TBL_VARCHAR100
1571: )
1572: IS
1573: BEGIN
1574: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1575: p_parameter_name,p_parameter_value);
1576: END proc_end;
1577:
1578: PROCEDURE proc_end(

Line 1585: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1581: , p_parameter_value IN PO_TBL_VARCHAR2000
1582: )
1583: IS
1584: BEGIN
1585: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1586: p_parameter_name,p_parameter_value);
1587: END proc_end;
1588:
1589: PROCEDURE proc_end(

Line 1596: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,

1592: , p_parameter_value IN PO_TBL_VARCHAR4000
1593: )
1594: IS
1595: BEGIN
1596: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1597: p_parameter_name,p_parameter_value);
1598: END proc_end;
1599:
1600: PROCEDURE proc_return(

Line 1606: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1602: , p_return_value IN VARCHAR2
1603: )
1604: IS
1605: BEGIN
1606: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1607: var_to_string(D_RETURN_VALUE,p_return_value));
1608: END proc_return;
1609:
1610: PROCEDURE proc_return(

Line 1616: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1612: , p_return_value IN NUMBER
1613: )
1614: IS
1615: BEGIN
1616: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1617: var_to_string(D_RETURN_VALUE,p_return_value));
1618: END proc_return;
1619:
1620: PROCEDURE proc_return(

Line 1626: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1622: , p_return_value IN DATE
1623: )
1624: IS
1625: BEGIN
1626: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1627: var_to_string(D_RETURN_VALUE,p_return_value));
1628: END proc_return;
1629:
1630: PROCEDURE proc_return(

Line 1636: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1632: , p_return_value IN BOOLEAN
1633: )
1634: IS
1635: BEGIN
1636: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1637: var_to_string(D_RETURN_VALUE,p_return_value));
1638: END proc_return;
1639:
1640: PROCEDURE proc_return(

Line 1646: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1642: , p_return_value IN PO_TBL_NUMBER
1643: )
1644: IS
1645: BEGIN
1646: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1647: D_RETURN_VALUE,p_return_value);
1648: END proc_return;
1649:
1650: PROCEDURE proc_return(

Line 1656: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1652: , p_return_value IN PO_TBL_DATE
1653: )
1654: IS
1655: BEGIN
1656: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1657: D_RETURN_VALUE,p_return_value);
1658: END proc_return;
1659:
1660: PROCEDURE proc_return(

Line 1666: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1662: , p_return_value IN PO_TBL_VARCHAR1
1663: )
1664: IS
1665: BEGIN
1666: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1667: D_RETURN_VALUE,p_return_value);
1668: END proc_return;
1669:
1670: PROCEDURE proc_return(

Line 1676: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1672: , p_return_value IN PO_TBL_VARCHAR5
1673: )
1674: IS
1675: BEGIN
1676: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1677: D_RETURN_VALUE,p_return_value);
1678: END proc_return;
1679:
1680: PROCEDURE proc_return(

Line 1686: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1682: , p_return_value IN PO_TBL_VARCHAR30
1683: )
1684: IS
1685: BEGIN
1686: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1687: D_RETURN_VALUE,p_return_value);
1688: END proc_return;
1689:
1690: PROCEDURE proc_return(

Line 1696: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1692: , p_return_value IN PO_TBL_VARCHAR100
1693: )
1694: IS
1695: BEGIN
1696: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1697: D_RETURN_VALUE,p_return_value);
1698: END proc_return;
1699:
1700: PROCEDURE proc_return(

Line 1706: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1702: , p_return_value IN PO_TBL_VARCHAR2000
1703: )
1704: IS
1705: BEGIN
1706: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1707: D_RETURN_VALUE,p_return_value);
1708: END proc_return;
1709:
1710: PROCEDURE proc_return(

Line 1716: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,

1712: , p_return_value IN PO_TBL_VARCHAR4000
1713: )
1714: IS
1715: BEGIN
1716: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1717: D_RETURN_VALUE,p_return_value);
1718: END proc_return;
1719:
1720: PROCEDURE proc_raise(

Line 1725: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RAISE,

1721: p_module_base IN VARCHAR2
1722: )
1723: IS
1724: BEGIN
1725: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RAISE,
1726: 'Raising exception: SQLERRM = '||SQLERRM);
1727: END proc_raise;
1728:
1729: -- EVENT-level logging.

Line 1738: log(FND_LOG.LEVEL_EVENT,p_module_base,TO_CHAR(p_position),p_message_text);

1734: , p_message_text IN VARCHAR2
1735: )
1736: IS
1737: BEGIN
1738: log(FND_LOG.LEVEL_EVENT,p_module_base,TO_CHAR(p_position),p_message_text);
1739: END event;
1740:
1741: -- EXCEPTION-level logging.
1742:

Line 1750: log(FND_LOG.LEVEL_EXCEPTION,p_module_base,TO_CHAR(p_position)||'.EXCEPTION',

1746: , p_message_text IN VARCHAR2 DEFAULT NULL
1747: )
1748: IS
1749: BEGIN
1750: log(FND_LOG.LEVEL_EXCEPTION,p_module_base,TO_CHAR(p_position)||'.EXCEPTION',
1751: p_message_text||';SQLERRM = '||SQLERRM);
1752: END exc;
1753:
1754: