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 1069: --Modifies: FND_LOG_MESSAGES

1065:
1066: -------------------------------------------------------------------------------
1067: --Start of Comments
1068: --Pre-reqs: None.
1069: --Modifies: FND_LOG_MESSAGES
1070: --Locks: None.
1071: --Function:
1072: -- Logs STATEMENT-level messages containing data from the specified table.
1073: --Parameters:

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

1365: p_module_base IN VARCHAR2
1366: )
1367: IS
1368: BEGIN
1369: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,D_START_OF_SUBPROGRAM);
1370: END proc_begin;
1371:
1372: PROCEDURE proc_begin(
1373: p_module_base IN VARCHAR2

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

1375: , p_parameter_value IN VARCHAR2
1376: )
1377: IS
1378: BEGIN
1379: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1380: var_to_string(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 NUMBER
1387: )
1388: IS
1389: BEGIN
1390: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1391: var_to_string(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 DATE
1398: )
1399: IS
1400: BEGIN
1401: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1402: var_to_string(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 BOOLEAN
1409: )
1410: IS
1411: BEGIN
1412: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1413: var_to_string(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_NUMBER
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_DATE
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_VARCHAR1
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_VARCHAR5
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_begin(

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

1463: , p_parameter_value IN PO_TBL_VARCHAR30
1464: )
1465: IS
1466: BEGIN
1467: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1468: p_parameter_name,p_parameter_value);
1469: END proc_begin;
1470:
1471: PROCEDURE proc_begin(

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

1474: , p_parameter_value IN PO_TBL_VARCHAR100
1475: )
1476: IS
1477: BEGIN
1478: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1479: p_parameter_name,p_parameter_value);
1480: END proc_begin;
1481:
1482: PROCEDURE proc_begin(

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

1485: , p_parameter_value IN PO_TBL_VARCHAR2000
1486: )
1487: IS
1488: BEGIN
1489: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1490: p_parameter_name,p_parameter_value);
1491: END proc_begin;
1492:
1493: PROCEDURE proc_begin(

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

1496: , p_parameter_value IN PO_TBL_VARCHAR4000
1497: )
1498: IS
1499: BEGIN
1500: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_BEGIN,
1501: p_parameter_name,p_parameter_value);
1502: END proc_begin;
1503:
1504: PROCEDURE proc_end(

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

1505: p_module_base IN VARCHAR2
1506: )
1507: IS
1508: BEGIN
1509: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,D_END_OF_SUBPROGRAM);
1510: END proc_end;
1511:
1512: PROCEDURE proc_end(
1513: p_module_base IN VARCHAR2

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

1515: , p_parameter_value IN VARCHAR2
1516: )
1517: IS
1518: BEGIN
1519: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1520: var_to_string(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 NUMBER
1527: )
1528: IS
1529: BEGIN
1530: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1531: var_to_string(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 DATE
1538: )
1539: IS
1540: BEGIN
1541: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1542: var_to_string(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 BOOLEAN
1549: )
1550: IS
1551: BEGIN
1552: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1553: var_to_string(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_NUMBER
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_DATE
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_VARCHAR1
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_VARCHAR5
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_end(

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

1603: , p_parameter_value IN PO_TBL_VARCHAR30
1604: )
1605: IS
1606: BEGIN
1607: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1608: p_parameter_name,p_parameter_value);
1609: END proc_end;
1610:
1611: PROCEDURE proc_end(

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

1614: , p_parameter_value IN PO_TBL_VARCHAR100
1615: )
1616: IS
1617: BEGIN
1618: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1619: p_parameter_name,p_parameter_value);
1620: END proc_end;
1621:
1622: PROCEDURE proc_end(

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

1625: , p_parameter_value IN PO_TBL_VARCHAR2000
1626: )
1627: IS
1628: BEGIN
1629: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1630: p_parameter_name,p_parameter_value);
1631: END proc_end;
1632:
1633: PROCEDURE proc_end(

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

1636: , p_parameter_value IN PO_TBL_VARCHAR4000
1637: )
1638: IS
1639: BEGIN
1640: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_END,
1641: p_parameter_name,p_parameter_value);
1642: END proc_end;
1643:
1644: PROCEDURE proc_return(

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

1646: , p_return_value IN VARCHAR2
1647: )
1648: IS
1649: BEGIN
1650: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1651: var_to_string(D_RETURN_VALUE,p_return_value));
1652: END proc_return;
1653:
1654: PROCEDURE proc_return(

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

1656: , p_return_value IN NUMBER
1657: )
1658: IS
1659: BEGIN
1660: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1661: var_to_string(D_RETURN_VALUE,p_return_value));
1662: END proc_return;
1663:
1664: PROCEDURE proc_return(

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

1666: , p_return_value IN DATE
1667: )
1668: IS
1669: BEGIN
1670: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1671: var_to_string(D_RETURN_VALUE,p_return_value));
1672: END proc_return;
1673:
1674: PROCEDURE proc_return(

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

1676: , p_return_value IN BOOLEAN
1677: )
1678: IS
1679: BEGIN
1680: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1681: var_to_string(D_RETURN_VALUE,p_return_value));
1682: END proc_return;
1683:
1684: PROCEDURE proc_return(

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

1686: , p_return_value IN PO_TBL_NUMBER
1687: )
1688: IS
1689: BEGIN
1690: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1691: D_RETURN_VALUE,p_return_value);
1692: END proc_return;
1693:
1694: PROCEDURE proc_return(

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

1696: , p_return_value IN PO_TBL_DATE
1697: )
1698: IS
1699: BEGIN
1700: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1701: D_RETURN_VALUE,p_return_value);
1702: END proc_return;
1703:
1704: PROCEDURE proc_return(

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

1706: , p_return_value IN PO_TBL_VARCHAR1
1707: )
1708: IS
1709: BEGIN
1710: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1711: D_RETURN_VALUE,p_return_value);
1712: END proc_return;
1713:
1714: PROCEDURE proc_return(

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

1716: , p_return_value IN PO_TBL_VARCHAR5
1717: )
1718: IS
1719: BEGIN
1720: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1721: D_RETURN_VALUE,p_return_value);
1722: END proc_return;
1723:
1724: PROCEDURE proc_return(

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

1726: , p_return_value IN PO_TBL_VARCHAR30
1727: )
1728: IS
1729: BEGIN
1730: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1731: D_RETURN_VALUE,p_return_value);
1732: END proc_return;
1733:
1734: PROCEDURE proc_return(

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

1736: , p_return_value IN PO_TBL_VARCHAR100
1737: )
1738: IS
1739: BEGIN
1740: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1741: D_RETURN_VALUE,p_return_value);
1742: END proc_return;
1743:
1744: PROCEDURE proc_return(

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

1746: , p_return_value IN PO_TBL_VARCHAR2000
1747: )
1748: IS
1749: BEGIN
1750: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1751: D_RETURN_VALUE,p_return_value);
1752: END proc_return;
1753:
1754: PROCEDURE proc_return(

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

1756: , p_return_value IN PO_TBL_VARCHAR4000
1757: )
1758: IS
1759: BEGIN
1760: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RETURN,
1761: D_RETURN_VALUE,p_return_value);
1762: END proc_return;
1763:
1764: PROCEDURE proc_raise(

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

1765: p_module_base IN VARCHAR2
1766: )
1767: IS
1768: BEGIN
1769: log(FND_LOG.LEVEL_PROCEDURE,p_module_base,D_RAISE,
1770: 'Raising exception: SQLERRM = '||SQLERRM);
1771: END proc_raise;
1772:
1773: -- EVENT-level logging.

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

1778: , p_message_text IN VARCHAR2
1779: )
1780: IS
1781: BEGIN
1782: log(FND_LOG.LEVEL_EVENT,p_module_base,TO_CHAR(p_position),p_message_text);
1783: END event;
1784:
1785: -- EXCEPTION-level logging.
1786:

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

1790: , p_message_text IN VARCHAR2 DEFAULT NULL
1791: )
1792: IS
1793: BEGIN
1794: log(FND_LOG.LEVEL_EXCEPTION,p_module_base,TO_CHAR(p_position)||'.EXCEPTION',
1795: p_message_text||';SQLERRM = '||SQLERRM);
1796: END exc;
1797:
1798: