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

Line 22: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

18:
19: PROCEDURE log_message(p_message IN VARCHAR2) IS
20: BEGIN
21: IF (g_fnd_debug = 'Y') THEN
22: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
23: FND_LOG.string(log_level => FND_LOG.level_statement,
24: module => g_module,
25: message => substr(p_message, 0, 4000));
26: END IF;

Line 23: FND_LOG.string(log_level => FND_LOG.level_statement,

19: PROCEDURE log_message(p_message IN VARCHAR2) IS
20: BEGIN
21: IF (g_fnd_debug = 'Y') THEN
22: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
23: FND_LOG.string(log_level => FND_LOG.level_statement,
24: module => g_module,
25: message => substr(p_message, 0, 4000));
26: END IF;
27: END IF;

Line 33: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

29:
30: PROCEDURE log_error(p_message IN VARCHAR2) IS
31: BEGIN
32: IF (g_fnd_debug = 'Y') THEN
33: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
34: FND_LOG.string(log_level => FND_LOG.level_unexpected,
35: module => g_module,
36: message => substr(p_message, 0, 4000));
37: END IF;

Line 34: FND_LOG.string(log_level => FND_LOG.level_unexpected,

30: PROCEDURE log_error(p_message IN VARCHAR2) IS
31: BEGIN
32: IF (g_fnd_debug = 'Y') THEN
33: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
34: FND_LOG.string(log_level => FND_LOG.level_unexpected,
35: module => g_module,
36: message => substr(p_message, 0, 4000));
37: END IF;
38: END IF;

Line 84: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

80: x_application_id number := null;
81:
82: x_language_code VARCHAR2(3);
83: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
84: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
85: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
86: x_return_code VARCHAR2(10);
87:
88: l_api_name VARCHAR2(30) := ' AUTO_ALLOC_AND_SPLIT_REQ';

Line 95: /* perform initialization for FND logging */

91: l_progress NUMBER := 0;
92:
93: BEGIN
94:
95: /* perform initialization for FND logging */
96: if(g_fnd_debug = 'Y') then
97:
98: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
99: l_debug_enabled := 'Y';

Line 98: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

94:
95: /* perform initialization for FND logging */
96: if(g_fnd_debug = 'Y') then
97:
98: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
99: l_debug_enabled := 'Y';
100: end if;
101:
102: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

Line 102: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

98: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
99: l_debug_enabled := 'Y';
100: end if;
101:
102: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
103: l_exception_enabled := 'Y';
104: end if;
105:
106: end if;

Line 382: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

378: p_requisition_number OUT NOCOPY VARCHAR2,
379: p_job_name OUT NOCOPY VARCHAR2,
380: p_document_disp_line_number OUT NOCOPY VARCHAR2) IS
381:
382: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
383: x_result VARCHAR2(10);
384: x_error_message VARCHAR2(1000);
385:
386: -- unallocatedItems are items that have awarded bids that have yet to be

Line 418: /* perform initialization for FND logging */

414: l_progress NUMBER := 0;
415:
416: BEGIN
417:
418: /* perform initialization for FND logging */
419: if(g_fnd_debug = 'Y') then
420:
421: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
422: l_debug_enabled := 'Y';

Line 421: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

417:
418: /* perform initialization for FND logging */
419: if(g_fnd_debug = 'Y') then
420:
421: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
422: l_debug_enabled := 'Y';
423: end if;
424:
425: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

Line 425: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

421: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
422: l_debug_enabled := 'Y';
423: end if;
424:
425: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
426: l_exception_enabled := 'Y';
427: end if;
428:
429: end if;

Line 532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

528: l_split_error_code VARCHAR2(10);
529: l_orig_req_line NUMBER;
530: l_req_qty NUMBER;
531: l_num_messages NUMBER;
532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
533: l_req_line_id_col dbms_sql.number_table;
534: lock_not_acquired EXCEPTION;
535: l_user_id NUMBER;
536:

Line 599: /* perform initialization for FND logging */

595:
596:
597: BEGIN
598:
599: /* perform initialization for FND logging */
600: if(g_fnd_debug = 'Y') then
601:
602: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
603: l_debug_enabled := 'Y';

Line 602: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

598:
599: /* perform initialization for FND logging */
600: if(g_fnd_debug = 'Y') then
601:
602: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
603: l_debug_enabled := 'Y';
604: end if;
605:
606: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

Line 606: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

602: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
603: l_debug_enabled := 'Y';
604: end if;
605:
606: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
607: l_exception_enabled := 'Y';
608: end if;
609:
610: end if;

Line 906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;
910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;

Line 922: /* perform initialization for FND logging */

918: l_progress NUMBER := 0;
919:
920: BEGIN
921:
922: /* perform initialization for FND logging */
923: if(g_fnd_debug = 'Y') then
924:
925: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
926: l_debug_enabled := 'Y';

Line 925: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

921:
922: /* perform initialization for FND logging */
923: if(g_fnd_debug = 'Y') then
924:
925: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
926: l_debug_enabled := 'Y';
927: end if;
928:
929: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

Line 929: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

925: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
926: l_debug_enabled := 'Y';
927: end if;
928:
929: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
930: l_exception_enabled := 'Y';
931: end if;
932:
933: end if;

Line 1665: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1661: x_line_number NUMBER;
1662: x_award_quantity NUMBER;
1663: x_allocation_quantity NUMBER;
1664: x_requisition_line_id NUMBER;
1665: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1666: x_interface_header_id NUMBER;
1667: x_interface_line_id NUMBER;
1668: x_price NUMBER;
1669: x_quantity NUMBER;

Line 3458: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3454: x_language_code VARCHAR2(4);
3455: x_round_number NUMBER;
3456: x_line_number NUMBER;
3457: x_bid_number NUMBER;
3458: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3459: x_po_header_id NUMBER;
3460: x_order_number pon_bid_headers.order_number%TYPE;
3461: x_interface_header_id NUMBER;
3462: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;

Line 3610: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

3606: -- Get the current policy
3607: v_old_policy := mo_global.get_access_mode();
3608: v_old_org_id := mo_global.get_current_org_id();
3609:
3610: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3611: fnd_log.string(
3612: fnd_log.level_statement,
3613: g_module || '.check_unique_order_number',
3614: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);

Line 3611: fnd_log.string(

3607: v_old_policy := mo_global.get_access_mode();
3608: v_old_org_id := mo_global.get_current_org_id();
3609:
3610: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3611: fnd_log.string(
3612: fnd_log.level_statement,
3613: g_module || '.check_unique_order_number',
3614: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);
3615: end if;

Line 3612: fnd_log.level_statement,

3608: v_old_org_id := mo_global.get_current_org_id();
3609:
3610: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3611: fnd_log.string(
3612: fnd_log.level_statement,
3613: g_module || '.check_unique_order_number',
3614: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);
3615: end if;
3616:

Line 3874: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3870: x_seq_for_item_key varchar2(6) := null;
3871: x_doc_type_to_create varchar2(25);
3872: v_old_policy varchar2(1);
3873: v_old_org_id number;
3874: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3875: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
3876: x_print_flag varchar2(1) := 'N';
3877: x_fax_flag varchar2(1) := 'N';
3878: x_email_flag varchar2(1) := 'N';

Line 3901: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

3897: -- Get the current policy
3898: v_old_policy := mo_global.get_access_mode();
3899: v_old_org_id := mo_global.get_current_org_id();
3900:
3901: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3902: fnd_log.string(
3903: fnd_log.level_statement,
3904: g_module || '.check_unique_order_number',
3905: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);

Line 3902: fnd_log.string(

3898: v_old_policy := mo_global.get_access_mode();
3899: v_old_org_id := mo_global.get_current_org_id();
3900:
3901: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3902: fnd_log.string(
3903: fnd_log.level_statement,
3904: g_module || '.check_unique_order_number',
3905: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);
3906: end if;

Line 3903: fnd_log.level_statement,

3899: v_old_org_id := mo_global.get_current_org_id();
3900:
3901: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3902: fnd_log.string(
3903: fnd_log.level_statement,
3904: g_module || '.check_unique_order_number',
3905: 'old_policy = ' || v_old_policy || ', old_org_id = ' || v_old_org_id);
3906: end if;
3907:

Line 4063: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4059:
4060:
4061: x_number_of_failed_pos NUMBER;
4062: x_auction_header_id NUMBER;
4063: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4064:
4065: BEGIN
4066: IF (UNCMODE = 'CANCEL') THEN
4067: return;

Line 4151: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4147: newline varchar2(256);
4148: beginBold VARCHAR2(10);
4149: endBold VARCHAR2(10);
4150: x_count NUMBER;
4151: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4152: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
4153: x_purchase_orders VARCHAR2(30);
4154: x_contract_type pon_auction_headers_all.contract_type%TYPE;
4155:

Line 4318: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4314: newline varchar2(256);
4315: beginBold VARCHAR2(10);
4316: endBold VARCHAR2(10);
4317: x_count NUMBER;
4318: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4319: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
4320: x_purchase_orders VARCHAR2(30);
4321: x_contract_type pon_auction_headers_all.contract_type%TYPE;
4322: x_error_msg pon_bid_headers.po_error_msg%type;

Line 4532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4528: l_debug_enabled VARCHAR2(1) := 'N';
4529: l_exception_enabled VARCHAR2(1) := 'N';
4530: l_progress NUMBER := 0;
4531:
4532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4533:
4534: -- Business Events Project
4535: x_return_status VARCHAR2(20);
4536: x_msg_count NUMBER;

Line 4542: /* perform initialization for FND logging */

4538:
4539:
4540: BEGIN
4541:
4542: /* perform initialization for FND logging */
4543: if(g_fnd_debug = 'Y') then
4544:
4545: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
4546: l_debug_enabled := 'Y';

Line 4545: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

4541:
4542: /* perform initialization for FND logging */
4543: if(g_fnd_debug = 'Y') then
4544:
4545: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
4546: l_debug_enabled := 'Y';
4547: end if;
4548:
4549: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

Line 4549: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then

4545: if (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
4546: l_debug_enabled := 'Y';
4547: end if;
4548:
4549: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
4550: l_exception_enabled := 'Y';
4551: end if;
4552:
4553: end if;