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_NEGOTIATIONS_SV1 dependencies on FND_LOG

Line 132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

128: l_req_lines_tbl(i).unit_meas_lookup_code := p_unit_meas_lookup_code_tbl(i);
129: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
130: end loop;*/
131:
132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
133: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
134: 'Before create_negotiation');
135: END IF;
136:

Line 133: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',

129: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
130: end loop;*/
131:
132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
133: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
134: 'Before create_negotiation');
135: END IF;
136:
137: -- Finally, make the call to create_negotiation

Line 155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

151: p_neg_outcome => p_neg_outcome,
152: p_document_org_id => p_document_org_id,
153: p_fair_opp_notice_flag => p_fair_opp_notice_flag);
154:
155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
156: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
157: 'After create_negotiation');
158: END IF;
159:

Line 156: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',

152: p_document_org_id => p_document_org_id,
153: p_fair_opp_notice_flag => p_fair_opp_notice_flag);
154:
155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
156: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
157: 'After create_negotiation');
158: END IF;
159:
160: -- End of API Body

Line 258: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

254: l_req_lines_tbl(i).unit_meas_lookup_code := p_unit_meas_lookup_code_tbl(i);
255: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
256: end loop;*/
257:
258: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
259: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
260: 'Before create_negotiation');
261: END IF;
262:

Line 259: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',

255: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
256: end loop;*/
257:
258: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
259: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
260: 'Before create_negotiation');
261: END IF;
262:
263: -- Finally, make the call to create_negotiation

Line 280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

276: x_error_message => x_error_message,
277: p_neg_outcome => p_neg_outcome,
278: p_document_org_id => p_document_org_id);
279:
280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
281: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
282: 'After create_negotiation');
283: END IF;
284:

Line 281: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',

277: p_neg_outcome => p_neg_outcome,
278: p_document_org_id => p_document_org_id);
279:
280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
281: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
282: 'After create_negotiation');
283: END IF;
284:
285: -- End of API Body

Line 457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

453: BEGIN
454: /* get the current org_id */
455: x_progress := '000';
456: -- logme('create_negotiation ' || x_progress);
457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);

Line 458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');

454: /* get the current org_id */
455: x_progress := '000';
456: -- logme('create_negotiation ' || x_progress);
457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);

Line 459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);

455: x_progress := '000';
456: -- logme('create_negotiation ' || x_progress);
457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);

Line 460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);

456: -- logme('create_negotiation ' || x_progress);
457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);

Line 461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);

457: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);

Line 462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);

458: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure Create_Negotiation Start');
459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);

Line 463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);

459: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_type : '||x_negotiation_type);
460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);

Line 464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);

460: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);

Line 465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);

461: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_style_id : '||p_neg_style_id);
462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);
469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);

Line 466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);

462: fnd_log.string(fnd_log.level_statement,g_log_head,'p_outcome_style_id : '||p_outcome_style_id);
463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);
469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);
470: END IF;

Line 467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);

463: fnd_log.string(fnd_log.level_statement,g_log_head,'x_negotiation_id : '||x_negotiation_id);
464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);
469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);
470: END IF;
471:

Line 468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);

464: fnd_log.string(fnd_log.level_statement,g_log_head,'x_doc_url_params : '||x_doc_url_params);
465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);
469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);
470: END IF;
471:
472: --

Line 469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);

465: fnd_log.string(fnd_log.level_statement,g_log_head,'x_result : '||x_result);
466: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_code : '||x_error_code);
467: fnd_log.string(fnd_log.level_statement,g_log_head,'x_error_message : '||x_error_message);
468: fnd_log.string(fnd_log.level_statement,g_log_head,'p_neg_outcome : '||p_neg_outcome);
469: fnd_log.string(fnd_log.level_statement,g_log_head,'p_document_org_id : '||p_document_org_id);
470: END IF;
471:
472: --
473: IF(p_document_org_id IS NULL) THEN

Line 490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

486: ELSE
487: x_org_id := p_document_org_id;
488: END IF;
489:
490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
491: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);
492: END IF;
493: --
494:

Line 491: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);

487: x_org_id := p_document_org_id;
488: END IF;
489:
490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
491: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);
492: END IF;
493: --
494:
495: --

Line 535: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

531: /* Adding parameter p_neg_outcome - RENEG BLANKET FPI */
532: -- Changed API call to use binding parameters.
533: x_progress := '001';
534:
535: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
536: fnd_log.string(fnd_log.level_statement,g_log_head,'Before create_draft_negotiation');
537: END IF;
538: PON_AUCTION_INTERFACE_PKG.create_draft_negotiation
539: ( p_document_title => null -- IN

Line 536: fnd_log.string(fnd_log.level_statement,g_log_head,'Before create_draft_negotiation');

532: -- Changed API call to use binding parameters.
533: x_progress := '001';
534:
535: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
536: fnd_log.string(fnd_log.level_statement,g_log_head,'Before create_draft_negotiation');
537: END IF;
538: PON_AUCTION_INTERFACE_PKG.create_draft_negotiation
539: ( p_document_title => null -- IN
540: , p_document_type => x_negotiation_type -- -- IN

Line 559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

555: );
556:
557:
558:
559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
560: fnd_log.string(fnd_log.level_statement,g_log_head,'After create_draft_negotiation');
561: END IF;
562:
563:

Line 560: fnd_log.string(fnd_log.level_statement,g_log_head,'After create_draft_negotiation');

556:
557:
558:
559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
560: fnd_log.string(fnd_log.level_statement,g_log_head,'After create_draft_negotiation');
561: END IF;
562:
563:
564: if api_result <> 0 THEN

Line 597: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

593: 'LINE',
594: sysdate,
595: l_return_status,
596: l_msg_data);
597: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
598: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);
599: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
600: END IF;
601:

Line 598: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);

594: sysdate,
595: l_return_status,
596: l_msg_data);
597: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
598: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);
599: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
600: END IF;
601:
602: IF ( l_return_status = 'E' ) THEN

Line 599: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

595: l_return_status,
596: l_msg_data);
597: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
598: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);
599: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
600: END IF;
601:
602: IF ( l_return_status = 'E' ) THEN
603: x_progress := '002';

Line 633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

629:
630: WHEN NO_DATA_FOUND then
631: /* The req line has been deleted since it was queried up. */
632:
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
634: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception1 : '||SQLERRM);
635: END IF;
636:
637: x_result:=-1;

Line 634: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception1 : '||SQLERRM);

630: WHEN NO_DATA_FOUND then
631: /* The req line has been deleted since it was queried up. */
632:
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
634: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception1 : '||SQLERRM);
635: END IF;
636:
637: x_result:=-1;
638: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');

Line 653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

649: RETURN;
650:
651: WHEN OTHERS THEN
652: /* This is to see if req line is locked */
653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
654: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception2 : '||SQLERRM);
655: END IF;
656:
657: if (SQLCODE=-54)

Line 654: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception2 : '||SQLERRM);

650:
651: WHEN OTHERS THEN
652: /* This is to see if req line is locked */
653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
654: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception2 : '||SQLERRM);
655: END IF;
656:
657: if (SQLCODE=-54)
658: THEN

Line 678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

674: end if;
675:
676: END;
677:
678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
679: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
682: END IF;

Line 679: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);

675:
676: END;
677:
678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
679: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
682: END IF;
683:

Line 680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);

676: END;
677:
678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
679: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
682: END IF;
683:
684: if (x_req_in_pool_flag='N')

Line 681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);

677:
678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
679: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
682: END IF;
683:
684: if (x_req_in_pool_flag='N')
685: then

Line 693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

689: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
690: WHERE prh.requisition_header_id = prl.requisition_header_id
691: AND prl.requisition_line_id = t_req_lines(i);
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
695: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
696: END IF;
697:

Line 694: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);

690: WHERE prh.requisition_header_id = prl.requisition_header_id
691: AND prl.requisition_line_id = t_req_lines(i);
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
695: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
696: END IF;
697:
698:

Line 695: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);

691: AND prl.requisition_line_id = t_req_lines(i);
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
695: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
696: END IF;
697:
698:
699: fnd_message.set_token('REQ_NUM', x_req_num);

Line 753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

749: x_progress := '003';
750: /* count the number of records in the plsql table */
751: x_num_records := t_req_lines.COUNT;
752:
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,g_log_head,'x_num_records : '||x_num_records);
755: END IF;
756: --bug 6131913
757: -- logme('create_negotiation ' || x_progress);

Line 754: fnd_log.string(fnd_log.level_statement,g_log_head,'x_num_records : '||x_num_records);

750: /* count the number of records in the plsql table */
751: x_num_records := t_req_lines.COUNT;
752:
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,g_log_head,'x_num_records : '||x_num_records);
755: END IF;
756: --bug 6131913
757: -- logme('create_negotiation ' || x_progress);
758:

Line 946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

942: /*
943: ** Get the ship to location id associated with the deliver to location.
944: ** This may then used to get the tax name, if the tax system parameters are
945: ** set up to retrieve the tax code based on ship-to location. */
946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);

Line 947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);

943: ** Get the ship to location id associated with the deliver to location.
944: ** This may then used to get the tax name, if the tax system parameters are
945: ** set up to retrieve the tax code based on ship-to location. */
946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);

Line 948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);

944: ** This may then used to get the tax name, if the tax system parameters are
945: ** set up to retrieve the tax code based on ship-to location. */
946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);

Line 949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);

945: ** set up to retrieve the tax code based on ship-to location. */
946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);

Line 950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);

946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);

Line 951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);

947: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id : '||x_req_line_id);
948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);

Line 952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);

948: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type : '||x_line_type);
949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);

Line 953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);

949: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id : '||x_item_id);
950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);

Line 954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);

950: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev : '||x_item_rev);
951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);

Line 955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);

951: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id : '||x_category_id);
952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);

Line 956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);

952: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity : '||x_quantity);
953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);

Line 957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);

953: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom : '||x_uom);
954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);

Line 958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);

954: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id : '||x_job_id);
955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);

Line 959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);

955: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id : '||x_req_header_id);
956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);

Line 960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);

956: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);

Line 961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);

957: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);

Line 962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);

958: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor : '||x_note_to_vendor);
959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);

Line 963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);

959: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date : '||x_need_by_date);
960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);

Line 964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);

960: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount : '||l_amount);
961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);

Line 965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);

961: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num : '||x_item_num);
962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);

Line 966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);

962: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id : '||x_deliver_to_location_id);
963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);

Line 967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);

963: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price : '||x_unit_price);
964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);

Line 968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);

964: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc : '||x_item_desc);
965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);

Line 969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);

965: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name : '||l_job_name);
966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);

Line 970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);

966: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description : '||l_job_long_description);
967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);

Line 971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);

967: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id : '||l_from_org_id);
968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);

Line 972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);

968: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display : '||x_line_num_display);
969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);

Line 973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);

969: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id : '||x_group_line_id);
970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);

Line 974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);

970: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag : '||x_clm_info_flag);
971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);

Line 975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);

971: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator : '||x_clm_option_indicator);
972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);

Line 976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);

972: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num : '||x_clm_option_num);
973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);
980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);

Line 977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);

973: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date : '||x_clm_option_from_date);
974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);
980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);
981: END IF;

Line 978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);

974: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date : '||x_clm_option_to_date);
975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);
980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);
981: END IF;
982:

Line 979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);

975: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag : '||x_clm_funded_flag);
976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);
980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);
981: END IF;
982:
983: BEGIN

Line 980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);

976: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num : '||x_clm_base_line_num);
977: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE : '||x_CONTRACT_TYPE);
978: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT : '||x_COST_CONSTRAINT);
979: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE : '||x_CLM_IDC_TYPE);
980: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id : '||x_req_line_temp_id);
981: END IF;
982:
983: BEGIN
984: x_progress := '004';

Line 990: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

986: INTO x_ship_to_location_id
987: FROM hr_locations
988: WHERE location_id = x_deliver_to_location_id;
989:
990: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
991: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);
992: END IF;
993:
994: EXCEPTION

Line 991: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);

987: FROM hr_locations
988: WHERE location_id = x_deliver_to_location_id;
989:
990: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
991: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);
992: END IF;
993:
994: EXCEPTION
995: WHEN NO_DATA_FOUND THEN

Line 997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

993:
994: EXCEPTION
995: WHEN NO_DATA_FOUND THEN
996: x_ship_to_location_id := x_deliver_to_location_id;
997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
998: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id1 : '||x_ship_to_location_id);
999: END IF;
1000: END;
1001:

Line 998: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id1 : '||x_ship_to_location_id);

994: EXCEPTION
995: WHEN NO_DATA_FOUND THEN
996: x_ship_to_location_id := x_deliver_to_location_id;
997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
998: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id1 : '||x_ship_to_location_id);
999: END IF;
1000: END;
1001:
1002: /* Sourcing expects the uom_code whereas req lines stores unit_of_measure .

Line 1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1006: into x_uom_code
1007: from mtl_units_of_measure mum
1008: where mum.unit_of_measure = x_uom; --bug 5841426
1009:
1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1011: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);
1012: END IF;
1013:
1014: exception

Line 1011: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);

1007: from mtl_units_of_measure mum
1008: where mum.unit_of_measure = x_uom; --bug 5841426
1009:
1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1011: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);
1012: END IF;
1013:
1014: exception
1015: when others then

Line 1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1013:
1014: exception
1015: when others then
1016: x_uom_code := null;
1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1018: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);
1019: END IF;
1020: end;
1021:

Line 1018: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);

1014: exception
1015: when others then
1016: x_uom_code := null;
1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1018: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);
1019: END IF;
1020: end;
1021:
1022: --

Line 1045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1041: l_conv_rate := PO_CURRENCY_SV.get_cross_ou_rate(
1042: l_from_org_id,
1043: x_org_id);
1044:
1045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1046: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
1047: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
1048: END IF;
1049:

Line 1046: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);

1042: l_from_org_id,
1043: x_org_id);
1044:
1045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1046: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
1047: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
1048: END IF;
1049:
1050: --

Line 1047: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);

1043: x_org_id);
1044:
1045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1046: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
1047: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
1048: END IF;
1049:
1050: --
1051:

Line 1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1061: l_bid_start_price := x_unit_price * l_conv_rate; --
1062: l_po_agreed_amount := l_amount * l_conv_rate; --
1063: END IF;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
1067: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
1068: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1069: END IF;

Line 1066: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);

1062: l_po_agreed_amount := l_amount * l_conv_rate; --
1063: END IF;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
1067: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
1068: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1069: END IF;
1070:

Line 1067: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);

1063: END IF;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
1067: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
1068: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1069: END IF;
1070:
1071: --

Line 1068: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');

1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
1067: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
1068: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1069: END IF;
1070:
1071: --
1072:

Line 1129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1125: , p_error_code => api_error_code
1126: , p_error_message => api_error_msg
1127: );
1128:
1129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1130: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1131: END IF;
1132:
1133: -- logme(' Add Line for item ' || x_item_desc || ' api_result = ' || api_result || ' error code = ' || api_error_code || ' error_msg = ' || api_error_msg );

Line 1130: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');

1126: , p_error_message => api_error_msg
1127: );
1128:
1129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1130: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
1131: END IF;
1132:
1133: -- logme(' Add Line for item ' || x_item_desc || ' api_result = ' || api_result || ' error code = ' || api_error_code || ' error_msg = ' || api_error_msg );
1134: -- logme ( ' The above line autocreated to ' || x_negotiation_line_num);

Line 1177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1173: -- logme( ' in price differentials');
1174: FOR l_price_diff_rec IN l_price_diff_csr(x_req_line_id) LOOP --Bug5841426
1175:
1176:
1177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1178: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');
1179: END IF;
1180:
1181: PON_AUCTION_INTERFACE_PKG.add_price_differential

Line 1178: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');

1174: FOR l_price_diff_rec IN l_price_diff_csr(x_req_line_id) LOOP --Bug5841426
1175:
1176:
1177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1178: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');
1179: END IF;
1180:
1181: PON_AUCTION_INTERFACE_PKG.add_price_differential
1182: ( p_document_number => x_negotiation_id

Line 1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1190: , p_error_code => api_error_code
1191: , p_error_message => api_error_msg
1192: );
1193:
1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1195: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');
1196: END IF;
1197:
1198: IF ( api_result <> 0 ) -- API failure

Line 1195: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');

1191: , p_error_message => api_error_msg
1192: );
1193:
1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1195: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');
1196: END IF;
1197:
1198: IF ( api_result <> 0 ) -- API failure
1199: THEN

Line 1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1236: x_progress := '010';
1237:
1238: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_negotiation_id) = 1 ) THEN --Bug 12605930
1239:
1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1241: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
1242: END IF;
1243:
1244: PON_AUCTION_INTERFACE_PKG.maintain_clm_relations(

Line 1241: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');

1237:
1238: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_negotiation_id) = 1 ) THEN --Bug 12605930
1239:
1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1241: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
1242: END IF;
1243:
1244: PON_AUCTION_INTERFACE_PKG.maintain_clm_relations(
1245: p_api_version => 1.0 -- IN

Line 1252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1248: , x_msg_data => l_msg_data -- OUT
1249: , p_document_number => x_negotiation_id -- IN
1250: );
1251:
1252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1253: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
1254: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1255: END IF;
1256:

Line 1253: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');

1249: , p_document_number => x_negotiation_id -- IN
1250: );
1251:
1252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1253: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
1254: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1255: END IF;
1256:
1257: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1254: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

1250: );
1251:
1252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1253: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
1254: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1255: END IF;
1256:
1257: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1258:

Line 1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1263: rollback;
1264: return ;
1265: end if;
1266:
1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1268: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberAllLines');
1269: END IF;
1270:
1271: -- Renumber the lines in the document.

Line 1268: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberAllLines');

1264: return ;
1265: end if;
1266:
1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1268: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberAllLines');
1269: END IF;
1270:
1271: -- Renumber the lines in the document.
1272: PON_CLO_RENUMBER_PKG.RenumberAllLines(

Line 1278: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1274: ,p_product_code => 'PON' -- IN
1275: , x_status => l_return_status -- OUT
1276: );
1277:
1278: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1279: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberAllLines');
1280: END IF;
1281: END IF ;
1282:

Line 1279: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberAllLines');

1275: , x_status => l_return_status -- OUT
1276: );
1277:
1278: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1279: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberAllLines');
1280: END IF;
1281: END IF ;
1282:
1283: /* if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1298: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1294: x_progress := '020';
1295:
1296: --
1297:
1298: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1299: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');
1300: END IF;
1301:
1302: PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees

Line 1299: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');

1295:
1296: --
1297:
1298: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1299: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');
1300: END IF;
1301:
1302: PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees
1303: ( p_api_version => 1.0 -- IN

Line 1311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1307: , p_document_number => x_negotiation_id -- IN
1308: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN
1309: );
1310:
1311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1312: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');
1313: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1314: END IF;
1315:

Line 1312: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');

1308: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN
1309: );
1310:
1311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1312: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');
1313: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1314: END IF;
1315:
1316:

Line 1313: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

1309: );
1310:
1311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1312: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');
1313: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1314: END IF;
1315:
1316:
1317: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1326: --
1327:
1328: --
1329:
1330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1331: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');
1332: END IF;
1333:
1334:

Line 1331: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');

1327:
1328: --
1329:
1330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1331: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');
1332: END IF;
1333:
1334:
1335: PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors

Line 1343: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1339: , x_msg_count => l_msg_count
1340: , x_msg_data => l_msg_data
1341: );
1342:
1343: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1344: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');
1345: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1346: END IF;
1347:

Line 1344: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');

1340: , x_msg_data => l_msg_data
1341: );
1342:
1343: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1344: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');
1345: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1346: END IF;
1347:
1348:

Line 1345: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

1341: );
1342:
1343: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1344: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_catalog_descriptors');
1345: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
1346: END IF;
1347:
1348:
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: rollback;
1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1387: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);
1388: END IF;
1389:
1390: x_result := -1;

Line 1387: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);

1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: rollback;
1386: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1387: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);
1388: END IF;
1389:
1390: x_result := -1;
1391: --

Line 2370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2366:
2367: BEGIN
2368: l_progress := '000';
2369: IF g_debug_stmt THEN
2370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2371: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||
2372: '.' || l_progress, ' Begin');
2373: END IF;
2374: END IF;

Line 2371: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||

2367: BEGIN
2368: l_progress := '000';
2369: IF g_debug_stmt THEN
2370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2371: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||
2372: '.' || l_progress, ' Begin');
2373: END IF;
2374: END IF;
2375:

Line 2393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2389: END IF;
2390:
2391: l_progress := '020';
2392: IF g_debug_stmt THEN
2393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||
2395: '.' || l_progress, ' End');
2396: END IF;
2397: END IF;

Line 2394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||

2390:
2391: l_progress := '020';
2392: IF g_debug_stmt THEN
2393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name||
2395: '.' || l_progress, ' End');
2396: END IF;
2397: END IF;
2398:

Line 2402: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2398:
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: IF g_debug_stmt THEN
2402: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head ||
2404: l_api_name||'.' || l_progress, ' Exception has occured.' ||
2405: ' l_msg_data: ' || l_msg_data || ' l_msg_count: ' || l_msg_count);
2406: END IF;

Line 2403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head ||

2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: IF g_debug_stmt THEN
2402: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head ||
2404: l_api_name||'.' || l_progress, ' Exception has occured.' ||
2405: ' l_msg_data: ' || l_msg_data || ' l_msg_count: ' || l_msg_count);
2406: END IF;
2407: END IF;

Line 2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2502: l_contract_type VARCHAR2(40);
2503: x_document_number pon_auction_headers_all.document_number%TYPE;
2504:
2505: BEGIN
2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');
2508: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
2509: fnd_log.string(fnd_log.level_statement,g_log_head,'p_req_line_id : '||p_req_line_id);
2510: END IF;

Line 2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');

2503: x_document_number pon_auction_headers_all.document_number%TYPE;
2504:
2505: BEGIN
2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');
2508: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
2509: fnd_log.string(fnd_log.level_statement,g_log_head,'p_req_line_id : '||p_req_line_id);
2510: END IF;
2511:

Line 2508: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);

2504:
2505: BEGIN
2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');
2508: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
2509: fnd_log.string(fnd_log.level_statement,g_log_head,'p_req_line_id : '||p_req_line_id);
2510: END IF;
2511:
2512: /* get the current org_id from auction header*/

Line 2509: fnd_log.string(fnd_log.level_statement,g_log_head,'p_req_line_id : '||p_req_line_id);

2505: BEGIN
2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');
2508: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
2509: fnd_log.string(fnd_log.level_statement,g_log_head,'p_req_line_id : '||p_req_line_id);
2510: END IF;
2511:
2512: /* get the current org_id from auction header*/
2513: x_progress := '000';

Line 2517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2513: x_progress := '000';
2514: x_grouping_method := 'REQUISITION';
2515: select org_id into x_org_id from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2516:
2517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2518: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
2519: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);
2520: END IF;
2521:

Line 2518: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);

2514: x_grouping_method := 'REQUISITION';
2515: select org_id into x_org_id from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2516:
2517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2518: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
2519: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);
2520: END IF;
2521:
2522:

Line 2519: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);

2515: select org_id into x_org_id from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2516:
2517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2518: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
2519: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);
2520: END IF;
2521:
2522:
2523: BEGIN

Line 2531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2527: --Get Uda Template Id and Contract Type from exisiting Auction
2528: select contract_type into l_contract_type from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2529: l_line_uda_temp_id := NULL;
2530:
2531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2532: fnd_log.string(fnd_log.level_statement,g_log_head,'l_contract_type : '||l_contract_type);
2533: END IF;
2534:
2535: begin

Line 2532: fnd_log.string(fnd_log.level_statement,g_log_head,'l_contract_type : '||l_contract_type);

2528: select contract_type into l_contract_type from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2529: l_line_uda_temp_id := NULL;
2530:
2531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2532: fnd_log.string(fnd_log.level_statement,g_log_head,'l_contract_type : '||l_contract_type);
2533: END IF;
2534:
2535: begin
2536: select uda_template_id into l_line_uda_temp_id from pon_auction_item_prices_all

Line 2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2535: begin
2536: select uda_template_id into l_line_uda_temp_id from pon_auction_item_prices_all
2537: where auction_header_id = p_auction_header_id and rownum <2;
2538:
2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2540: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);
2541: END IF;
2542:
2543: exception

Line 2540: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);

2536: select uda_template_id into l_line_uda_temp_id from pon_auction_item_prices_all
2537: where auction_header_id = p_auction_header_id and rownum <2;
2538:
2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2540: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);
2541: END IF;
2542:
2543: exception
2544: when no_data_found then

Line 2554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2550: sysdate,
2551: l_return_status,
2552: l_msg_data);
2553:
2554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2555: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id1 : '||l_line_uda_temp_id);
2556: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
2557: END IF;
2558:

Line 2555: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id1 : '||l_line_uda_temp_id);

2551: l_return_status,
2552: l_msg_data);
2553:
2554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2555: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id1 : '||l_line_uda_temp_id);
2556: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
2557: END IF;
2558:
2559: IF ( l_return_status = 'E' ) THEN

Line 2556: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

2552: l_msg_data);
2553:
2554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2555: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id1 : '||l_line_uda_temp_id);
2556: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
2557: END IF;
2558:
2559: IF ( l_return_status = 'E' ) THEN
2560: x_progress := '002';

Line 2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2578: x_closed_code
2579: FROM po_requisition_lines WHERE requisition_line_id=p_req_line_id
2580: FOR UPDATE OF auction_header_id NOWAIT;
2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
2584: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
2585: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
2586: END IF;

Line 2583: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);

2579: FROM po_requisition_lines WHERE requisition_line_id=p_req_line_id
2580: FOR UPDATE OF auction_header_id NOWAIT;
2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
2584: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
2585: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
2586: END IF;
2587:

Line 2584: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);

2580: FOR UPDATE OF auction_header_id NOWAIT;
2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
2584: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
2585: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
2586: END IF;
2587:
2588:

Line 2585: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);

2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_in_pool_flag : '||x_req_in_pool_flag);
2584: fnd_log.string(fnd_log.level_statement,g_log_head,'x_cancel_flag : '||x_cancel_flag);
2585: fnd_log.string(fnd_log.level_statement,g_log_head,'x_closed_code : '||x_closed_code);
2586: END IF;
2587:
2588:
2589: EXCEPTION

Line 2591: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2587:
2588:
2589: EXCEPTION
2590: WHEN NO_DATA_FOUND THEN
2591: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2592: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 1 : '||SQLERRM);
2593: END IF;
2594:
2595: x_result:=-1;

Line 2592: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 1 : '||SQLERRM);

2588:
2589: EXCEPTION
2590: WHEN NO_DATA_FOUND THEN
2591: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2592: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 1 : '||SQLERRM);
2593: END IF;
2594:
2595: x_result:=-1;
2596: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');

Line 2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2599: RETURN;
2600:
2601: WHEN OTHERS THEN
2602: /* This is to see if req line is locked */
2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2604: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 2 : '||SQLERRM);
2605: END IF;
2606:
2607: if (SQLCODE=-54)

Line 2604: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 2 : '||SQLERRM);

2600:
2601: WHEN OTHERS THEN
2602: /* This is to see if req line is locked */
2603: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2604: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 2 : '||SQLERRM);
2605: END IF;
2606:
2607: if (SQLCODE=-54)
2608: THEN

Line 2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2633: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2634: WHERE prh.requisition_header_id = prl.requisition_header_id
2635: AND prl.requisition_line_id = p_req_line_id;
2636:
2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2638: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
2640: END IF;
2641:

Line 2638: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);

2634: WHERE prh.requisition_header_id = prl.requisition_header_id
2635: AND prl.requisition_line_id = p_req_line_id;
2636:
2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2638: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
2640: END IF;
2641:
2642: fnd_message.set_token('REQ_NUM', x_req_num);

Line 2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);

2635: AND prl.requisition_line_id = p_req_line_id;
2636:
2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2638: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
2640: END IF;
2641:
2642: fnd_message.set_token('REQ_NUM', x_req_num);
2643: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

Line 2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2654: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2655: WHERE prh.requisition_header_id = prl.requisition_header_id
2656: AND prl.requisition_line_id = p_req_line_id;
2657:
2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2659: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);
2661: END IF;
2662:

Line 2659: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);

2655: WHERE prh.requisition_header_id = prl.requisition_header_id
2656: AND prl.requisition_line_id = p_req_line_id;
2657:
2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2659: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);
2661: END IF;
2662:
2663: fnd_message.set_token('REQ_NUM', x_req_num);

Line 2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);

2656: AND prl.requisition_line_id = p_req_line_id;
2657:
2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2659: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);
2661: END IF;
2662:
2663: fnd_message.set_token('REQ_NUM', x_req_num);
2664: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

Line 2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2675: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2676: WHERE prh.requisition_header_id = prl.requisition_header_id
2677: AND prl.requisition_line_id = p_req_line_id;
2678:
2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num2 : '||x_req_num);
2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);
2682: END IF;
2683:

Line 2680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num2 : '||x_req_num);

2676: WHERE prh.requisition_header_id = prl.requisition_header_id
2677: AND prl.requisition_line_id = p_req_line_id;
2678:
2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num2 : '||x_req_num);
2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);
2682: END IF;
2683:
2684: fnd_message.set_token('REQ_NUM', x_req_num);

Line 2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);

2677: AND prl.requisition_line_id = p_req_line_id;
2678:
2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num2 : '||x_req_num);
2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);
2682: END IF;
2683:
2684: fnd_message.set_token('REQ_NUM', x_req_num);
2685: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

Line 2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2805: IF l_cursor%NOTFOUND THEN
2806: EXIT;
2807: END IF;
2808:
2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);

Line 2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);

2806: EXIT;
2807: END IF;
2808:
2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);

Line 2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);

2807: END IF;
2808:
2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);

Line 2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);

2808:
2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);

Line 2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);

2809: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);

Line 2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);

2810: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_id1 : '||x_req_line_id);
2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);

Line 2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);

2811: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_type1 : '||x_line_type);
2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);

Line 2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);

2812: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_id1 : '||x_item_id);
2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);

Line 2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);

2813: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_rev1 : '||x_item_rev);
2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);

Line 2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);

2814: fnd_log.string(fnd_log.level_statement,g_log_head,'x_category_id1 : '||x_category_id);
2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);

Line 2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);

2815: fnd_log.string(fnd_log.level_statement,g_log_head,'x_quantity1 : '||x_quantity);
2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);

Line 2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);

2816: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom1 : '||x_uom);
2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);

Line 2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);

2817: fnd_log.string(fnd_log.level_statement,g_log_head,'x_job_id1 : '||x_job_id);
2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);

Line 2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);

2818: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_header_id1 : '||x_req_header_id);
2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);

Line 2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);

2819: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);

Line 2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);

2820: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis1 : '||l_value_basis);
2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);

Line 2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);

2821: fnd_log.string(fnd_log.level_statement,g_log_head,'x_note_to_vendor1 : '||x_note_to_vendor);
2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);

Line 2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);

2822: fnd_log.string(fnd_log.level_statement,g_log_head,'x_need_by_date1 : '||x_need_by_date);
2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);

Line 2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);

2823: fnd_log.string(fnd_log.level_statement,g_log_head,'l_amount1 : '||l_amount);
2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);

Line 2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);

2824: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_num1 : '||x_item_num);
2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);

Line 2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);

2825: fnd_log.string(fnd_log.level_statement,g_log_head,'x_deliver_to_location_id1 : '||x_deliver_to_location_id);
2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);

Line 2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);

2826: fnd_log.string(fnd_log.level_statement,g_log_head,'x_unit_price1 : '||x_unit_price);
2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);

Line 2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);

2827: fnd_log.string(fnd_log.level_statement,g_log_head,'x_item_desc1 : '||x_item_desc);
2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);

Line 2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);

2828: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_name1 : '||l_job_name);
2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);

Line 2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);

2829: fnd_log.string(fnd_log.level_statement,g_log_head,'l_job_long_description1 : '||l_job_long_description);
2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);

Line 2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);

2830: fnd_log.string(fnd_log.level_statement,g_log_head,'l_from_org_id1 : '||l_from_org_id);
2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);

Line 2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);

2831: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num_display1 : '||x_line_num_display);
2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);

Line 2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);

2832: fnd_log.string(fnd_log.level_statement,g_log_head,'x_group_line_id1 : '||x_group_line_id);
2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);

Line 2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);

2833: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_info_flag1 : '||x_clm_info_flag);
2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);

Line 2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);

2834: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_indicator1 : '||x_clm_option_indicator);
2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);

Line 2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);

2835: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_num1 : '||x_clm_option_num);
2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);
2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);

Line 2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);

2836: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_from_date1 : '||x_clm_option_from_date);
2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);
2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);
2844: END IF;

Line 2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);

2837: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_option_to_date1 : '||x_clm_option_to_date);
2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);
2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);
2844: END IF;
2845:

Line 2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);

2838: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_funded_flag1 : '||x_clm_funded_flag);
2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);
2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);
2844: END IF;
2845:
2846: --get to ship_to_location_id

Line 2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);

2839: fnd_log.string(fnd_log.level_statement,g_log_head,'x_clm_base_line_num1 : '||x_clm_base_line_num);
2840: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CONTRACT_TYPE1 : '||x_CONTRACT_TYPE);
2841: fnd_log.string(fnd_log.level_statement,g_log_head,'x_COST_CONSTRAINT1 : '||x_COST_CONSTRAINT);
2842: fnd_log.string(fnd_log.level_statement,g_log_head,'x_CLM_IDC_TYPE1 : '||x_CLM_IDC_TYPE);
2843: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_line_temp_id1 : '||x_req_line_temp_id);
2844: END IF;
2845:
2846: --get to ship_to_location_id
2847: BEGIN

Line 2854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2850: INTO x_ship_to_location_id
2851: FROM hr_locations
2852: WHERE location_id = x_deliver_to_location_id;
2853:
2854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2855: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);
2856: END IF;
2857:
2858: EXCEPTION

Line 2855: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);

2851: FROM hr_locations
2852: WHERE location_id = x_deliver_to_location_id;
2853:
2854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2855: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);
2856: END IF;
2857:
2858: EXCEPTION
2859: WHEN NO_DATA_FOUND THEN

Line 2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2857:
2858: EXCEPTION
2859: WHEN NO_DATA_FOUND THEN
2860: x_ship_to_location_id := x_deliver_to_location_id;
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id : '||x_ship_to_location_id);
2863: END IF;
2864: END;
2865:

Line 2862: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id : '||x_ship_to_location_id);

2858: EXCEPTION
2859: WHEN NO_DATA_FOUND THEN
2860: x_ship_to_location_id := x_deliver_to_location_id;
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_ship_to_location_id : '||x_ship_to_location_id);
2863: END IF;
2864: END;
2865:
2866: /* Sourcing expects the uom_code whereas req lines stores unit_of_measure .

Line 2874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2870: into x_uom_code
2871: from mtl_units_of_measure mum
2872: where mum.unit_of_measure = x_uom; --bug 5841426
2873:
2874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2875: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);
2876: END IF;
2877:
2878: exception

Line 2875: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);

2871: from mtl_units_of_measure mum
2872: where mum.unit_of_measure = x_uom; --bug 5841426
2873:
2874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2875: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);
2876: END IF;
2877:
2878: exception
2879: when others then

Line 2881: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2877:
2878: exception
2879: when others then
2880: x_uom_code := null;
2881: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2882: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);
2883: END IF;
2884: end;
2885:

Line 2882: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);

2878: exception
2879: when others then
2880: x_uom_code := null;
2881: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2882: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep x_uom_code : '||x_uom_code);
2883: END IF;
2884: end;
2885:
2886: --

Line 2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2908: l_bid_start_price := x_unit_price * l_conv_rate; --
2909: l_po_agreed_amount := l_amount * l_conv_rate; --
2910: END IF;
2911:
2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);

Line 2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);

2909: l_po_agreed_amount := l_amount * l_conv_rate; --
2910: END IF;
2911:
2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);

Line 2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);

2910: END IF;
2911:
2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
2918: END IF;

Line 2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);

2911:
2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
2918: END IF;
2919:

Line 2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);

2912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
2918: END IF;
2919:
2920: --

Line 2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);

2913: fnd_log.string(fnd_log.level_statement,g_log_head,'l_has_price_diff_flag : '||l_has_price_diff_flag);
2914: fnd_log.string(fnd_log.level_statement,g_log_head,'l_conv_rate : '||l_conv_rate);
2915: fnd_log.string(fnd_log.level_statement,g_log_head,'l_value_basis : '||l_value_basis);
2916: fnd_log.string(fnd_log.level_statement,g_log_head,'l_bid_start_price : '||l_bid_start_price);
2917: fnd_log.string(fnd_log.level_statement,g_log_head,'l_po_agreed_amount : '||l_po_agreed_amount);
2918: END IF;
2919:
2920: --
2921: x_progress := '007';

Line 2923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2919:
2920: --
2921: x_progress := '007';
2922:
2923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2924: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
2925: END IF;
2926:
2927: PON_AUCTION_INTERFACE_PKG.add_negotiation_line

Line 2924: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');

2920: --
2921: x_progress := '007';
2922:
2923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2924: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
2925: END IF;
2926:
2927: PON_AUCTION_INTERFACE_PKG.add_negotiation_line
2928: ( p_document_number => p_auction_header_id

Line 2977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2973: , p_error_code => api_error_code
2974: , p_error_message => api_error_msg
2975: );
2976:
2977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2978: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
2979: END IF;
2980:
2981: -- logme(' Add Line for item ' || x_item_desc || ' api_result = ' || api_result || ' error code = ' || api_error_code || ' error_msg = ' || api_error_msg );

Line 2978: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');

2974: , p_error_message => api_error_msg
2975: );
2976:
2977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2978: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_line');
2979: END IF;
2980:
2981: -- logme(' Add Line for item ' || x_item_desc || ' api_result = ' || api_result || ' error code = ' || api_error_code || ' error_msg = ' || api_error_msg );
2982: -- logme ( ' The above line autocreated to ' || x_negotiation_line_num);

Line 3020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3016: IF ( l_has_price_diff_flag = 'Y' ) THEN
3017: -- logme( ' in price differentials');
3018: FOR l_price_diff_rec IN l_price_diff_csr(x_req_line_id) LOOP
3019:
3020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3021: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');
3022: END IF;
3023:
3024: PON_AUCTION_INTERFACE_PKG.add_price_differential

Line 3021: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');

3017: -- logme( ' in price differentials');
3018: FOR l_price_diff_rec IN l_price_diff_csr(x_req_line_id) LOOP
3019:
3020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3021: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.add_price_differential');
3022: END IF;
3023:
3024: PON_AUCTION_INTERFACE_PKG.add_price_differential
3025: ( p_document_number => p_auction_header_id

Line 3037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3033: , p_error_code => api_error_code
3034: , p_error_message => api_error_msg
3035: );
3036:
3037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3038: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');
3039: END IF;
3040:
3041:

Line 3038: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');

3034: , p_error_message => api_error_msg
3035: );
3036:
3037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3038: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_price_differential');
3039: END IF;
3040:
3041:
3042: IF ( api_result <> 0 ) -- API failure

Line 3084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3080: -- Now map the correct reqlineids with the neg line numbers and store
3081: -- in the negotiation lines table.
3082: x_progress := '010';
3083:
3084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3085: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
3086: END IF;
3087:
3088: PON_AUCTION_INTERFACE_PKG.maintain_clm_relations(

Line 3085: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');

3081: -- in the negotiation lines table.
3082: x_progress := '010';
3083:
3084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3085: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
3086: END IF;
3087:
3088: PON_AUCTION_INTERFACE_PKG.maintain_clm_relations(
3089: p_api_version => 1.0 -- IN

Line 3099: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3095: , p_req_line_clin => x_group_line_id
3096: , p_req_line_opt => x_clm_base_line_num
3097: );
3098:
3099: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3100: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
3101: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
3102: END IF;
3103:

Line 3100: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');

3096: , p_req_line_opt => x_clm_base_line_num
3097: );
3098:
3099: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3100: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
3101: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
3102: END IF;
3103:
3104: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3101: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);

3097: );
3098:
3099: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3100: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.maintain_clm_relations');
3101: fnd_log.string(fnd_log.level_statement,g_log_head,'l_return_status : '||l_return_status);
3102: END IF;
3103:
3104: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3105:

Line 3114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3110: rollback;
3111: return ;
3112: end if;
3113:
3114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3115: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberSlin');
3116: END IF;
3117:
3118: -- Renumber the lines in the document.

Line 3115: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberSlin');

3111: return ;
3112: end if;
3113:
3114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3115: fnd_log.string(fnd_log.level_statement,g_log_head,'Before PON_CLO_RENUMBER_PKG.RenumberSlin');
3116: END IF;
3117:
3118: -- Renumber the lines in the document.
3119: PON_CLO_RENUMBER_PKG.RenumberSlin(

Line 3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3121: ,p_line_number => x_negotiation_line_num
3122: , x_status => l_return_status
3123: );
3124:
3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3126: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberSlin');
3127: END IF;
3128:
3129: x_progress := '020';

Line 3126: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberSlin');

3122: , x_status => l_return_status
3123: );
3124:
3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3126: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_CLO_RENUMBER_PKG.RenumberSlin');
3127: END IF;
3128:
3129: x_progress := '020';
3130:

Line 3137: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3133: EXCEPTION
3134: WHEN OTHERS THEN
3135: rollback;
3136:
3137: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3138: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);
3139: END IF;
3140:
3141: x_result := -1;

Line 3138: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);

3134: WHEN OTHERS THEN
3135: rollback;
3136:
3137: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3138: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception : '||SQLERRM);
3139: END IF;
3140:
3141: x_result := -1;
3142:

Line 3211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3207: Logic for each step is explained there. */
3208:
3209: /* STEP 1 - START */
3210:
3211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3212: fnd_log.string(fnd_log.level_statement,g_log_head,'Entering COPY_REQ_UDA_TO_SOL Procudure ');
3213: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
3214: END IF;
3215:

Line 3212: fnd_log.string(fnd_log.level_statement,g_log_head,'Entering COPY_REQ_UDA_TO_SOL Procudure ');

3208:
3209: /* STEP 1 - START */
3210:
3211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3212: fnd_log.string(fnd_log.level_statement,g_log_head,'Entering COPY_REQ_UDA_TO_SOL Procudure ');
3213: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
3214: END IF;
3215:
3216: for i in 1..1

Line 3213: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);

3209: /* STEP 1 - START */
3210:
3211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3212: fnd_log.string(fnd_log.level_statement,g_log_head,'Entering COPY_REQ_UDA_TO_SOL Procudure ');
3213: fnd_log.string(fnd_log.level_statement,g_log_head,'p_auction_header_id : '||p_auction_header_id);
3214: END IF;
3215:
3216: for i in 1..1
3217: loop

Line 3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3228: l_sol_uda_temp_id := NULL;
3229: l_req_uda_temp_id := NULL;
3230: END;
3231:
3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);
3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);
3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);
3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);

Line 3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);

3229: l_req_uda_temp_id := NULL;
3230: END;
3231:
3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);
3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);
3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);
3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);
3237: END IF;

Line 3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);

3230: END;
3231:
3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);
3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);
3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);
3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);
3237: END IF;
3238:

Line 3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);

3231:
3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);
3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);
3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);
3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);
3237: END IF;
3238:
3239: /* STEP 1 - END */

Line 3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);

3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3233: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_line_id : '||l_req_line_id);
3234: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_header_id : '||l_req_header_id);
3235: fnd_log.string(fnd_log.level_statement,g_log_head,'l_sol_uda_temp_id : '||l_sol_uda_temp_id);
3236: fnd_log.string(fnd_log.level_statement,g_log_head,'l_req_uda_temp_id : '||l_req_uda_temp_id);
3237: END IF;
3238:
3239: /* STEP 1 - END */
3240:

Line 3260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3256: LOOP
3257: FETCH l_extn_id_csr INTO l_extn_id;
3258: EXIT WHEN l_extn_id_csr%NOTFOUND;
3259:
3260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3261: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id : '||l_extn_id);
3262: END IF;
3263:
3264: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;

Line 3261: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id : '||l_extn_id);

3257: FETCH l_extn_id_csr INTO l_extn_id;
3258: EXIT WHEN l_extn_id_csr%NOTFOUND;
3259:
3260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3261: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id : '||l_extn_id);
3262: END IF;
3263:
3264: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3265:

Line 3274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3270: WHERE C_EXT_ATTR1 IN ('PRO_ADMIN_OFFICE','COTR_OFFICE','REQ_OFFICE') AND
3271: AUCTION_HEADER_ID = p_auction_header_id;
3272:
3273: EXCEPTION WHEN OTHERS THEN
3274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3275: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 1 : '||SQLERRM);
3276: END IF;
3277: END;
3278:

Line 3275: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 1 : '||SQLERRM);

3271: AUCTION_HEADER_ID = p_auction_header_id;
3272:
3273: EXCEPTION WHEN OTHERS THEN
3274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3275: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 1 : '||SQLERRM);
3276: END IF;
3277: END;
3278:
3279: /* STEP 4 - END */

Line 3293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3289:
3290: IF l_address_val IS NOT NULL THEN
3291: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE_BACKUP' WHERE EXTENSION_ID = l_iss_off_extn_id;
3292:
3293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3294: fnd_log.string(fnd_log.level_statement,g_log_head,'Taking backup of Issuing Office Record');
3295: END IF;
3296: ELSE
3297: BEGIN

Line 3294: fnd_log.string(fnd_log.level_statement,g_log_head,'Taking backup of Issuing Office Record');

3290: IF l_address_val IS NOT NULL THEN
3291: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE_BACKUP' WHERE EXTENSION_ID = l_iss_off_extn_id;
3292:
3293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3294: fnd_log.string(fnd_log.level_statement,g_log_head,'Taking backup of Issuing Office Record');
3295: END IF;
3296: ELSE
3297: BEGIN
3298: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B

Line 3305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3301: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3302:
3303: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3304: EXCEPTION WHEN OTHERS THEN
3305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3306: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 4 : '||SQLERRM);
3307: END IF;
3308: END;
3309: l_user_pref_addr_cnt := 0;

Line 3306: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 4 : '||SQLERRM);

3302:
3303: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3304: EXCEPTION WHEN OTHERS THEN
3305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3306: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 4 : '||SQLERRM);
3307: END IF;
3308: END;
3309: l_user_pref_addr_cnt := 0;
3310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 3310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3306: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 4 : '||SQLERRM);
3307: END IF;
3308: END;
3309: l_user_pref_addr_cnt := 0;
3310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3311: fnd_log.string(fnd_log.level_statement,g_log_head,'Deleted issuing office record copied from user preferences.');
3312: END IF;
3313: END IF;
3314: END IF;

Line 3311: fnd_log.string(fnd_log.level_statement,g_log_head,'Deleted issuing office record copied from user preferences.');

3307: END IF;
3308: END;
3309: l_user_pref_addr_cnt := 0;
3310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3311: fnd_log.string(fnd_log.level_statement,g_log_head,'Deleted issuing office record copied from user preferences.');
3312: END IF;
3313: END IF;
3314: END IF;
3315:

Line 3316: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3312: END IF;
3313: END IF;
3314: END IF;
3315:
3316: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3317: fnd_log.string(fnd_log.level_statement,g_log_head,'l_user_pref_addr_cnt : '||l_user_pref_addr_cnt);
3318: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id : '||l_iss_off_extn_id);
3319: END IF;
3320:

Line 3317: fnd_log.string(fnd_log.level_statement,g_log_head,'l_user_pref_addr_cnt : '||l_user_pref_addr_cnt);

3313: END IF;
3314: END IF;
3315:
3316: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3317: fnd_log.string(fnd_log.level_statement,g_log_head,'l_user_pref_addr_cnt : '||l_user_pref_addr_cnt);
3318: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id : '||l_iss_off_extn_id);
3319: END IF;
3320:
3321: /* STEP 5 - END */

Line 3318: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id : '||l_iss_off_extn_id);

3314: END IF;
3315:
3316: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3317: fnd_log.string(fnd_log.level_statement,g_log_head,'l_user_pref_addr_cnt : '||l_user_pref_addr_cnt);
3318: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id : '||l_iss_off_extn_id);
3319: END IF;
3320:
3321: /* STEP 5 - END */
3322:

Line 3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3342: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3343:
3344: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3345: EXCEPTION WHEN OTHERS THEN
3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3347: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 5 : '||SQLERRM);
3348: END IF;
3349: END;
3350:

Line 3347: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 5 : '||SQLERRM);

3343:
3344: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3345: EXCEPTION WHEN OTHERS THEN
3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3347: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 5 : '||SQLERRM);
3348: END IF;
3349: END;
3350:
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3347: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 5 : '||SQLERRM);
3348: END IF;
3349: END;
3350:
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id 4 : '||l_extn_id);
3353: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id 2 : '||l_iss_off_extn_id);
3354: END IF;
3355:

Line 3352: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id 4 : '||l_extn_id);

3348: END IF;
3349: END;
3350:
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id 4 : '||l_extn_id);
3353: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id 2 : '||l_iss_off_extn_id);
3354: END IF;
3355:
3356: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE' WHERE EXTENSION_ID = l_iss_off_extn_id;

Line 3353: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id 2 : '||l_iss_off_extn_id);

3349: END;
3350:
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id 4 : '||l_extn_id);
3353: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id 2 : '||l_iss_off_extn_id);
3354: END IF;
3355:
3356: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE' WHERE EXTENSION_ID = l_iss_off_extn_id;
3357: END IF;

Line 3366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3362:
3363: /* STEP 2 - END */
3364:
3365: EXCEPTION WHEN OTHERS THEN
3366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3367: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 6 : '||SQLERRM);
3368: END IF;
3369: END COPY_REQ_UDA_TO_SOL;
3370: /* Bug 9881440 - End */

Line 3367: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 6 : '||SQLERRM);

3363: /* STEP 2 - END */
3364:
3365: EXCEPTION WHEN OTHERS THEN
3366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3367: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 6 : '||SQLERRM);
3368: END IF;
3369: END COPY_REQ_UDA_TO_SOL;
3370: /* Bug 9881440 - End */
3371:

Line 3387: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3383: BEGIN
3384: x_return_status := FND_API.G_RET_STS_SUCCESS;
3385:
3386: l_progress := '0010';
3387: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3388: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: remove_from_req_pool');
3389: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'auction_header_id:' || p_auction_header_id );
3390: END IF;
3391:

Line 3388: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: remove_from_req_pool');

3384: x_return_status := FND_API.G_RET_STS_SUCCESS;
3385:
3386: l_progress := '0010';
3387: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3388: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: remove_from_req_pool');
3389: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'auction_header_id:' || p_auction_header_id );
3390: END IF;
3391:
3392: --looping thru the req line_id array and updating the auction references for teh req lines being added.

Line 3389: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'auction_header_id:' || p_auction_header_id );

3385:
3386: l_progress := '0010';
3387: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3388: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: remove_from_req_pool');
3389: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'auction_header_id:' || p_auction_header_id );
3390: END IF;
3391:
3392: --looping thru the req line_id array and updating the auction references for teh req lines being added.
3393: FOR i in 1..p_requisition_line_id.COUNT LOOP

Line 3409: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3405: AND auction_header_id IS NULL
3406: returning requisition_header_id INTO l_requisition_header_id;
3407:
3408: l_progress := '0020';
3409: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3410: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);
3411: END IF;
3412:
3413: ELSIF p_line_type = 'UNSOLICITED' THEN --unsolicited line

Line 3410: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);

3406: returning requisition_header_id INTO l_requisition_header_id;
3407:
3408: l_progress := '0020';
3409: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3410: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);
3411: END IF;
3412:
3413: ELSIF p_line_type = 'UNSOLICITED' THEN --unsolicited line
3414:

Line 3429: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3425: AND auction_header_id IS NULL
3426: returning requisition_header_id INTO l_requisition_header_id;
3427:
3428: l_progress := '0030';
3429: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3430: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);
3431: END IF;
3432: END IF;
3433:

Line 3430: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);

3426: returning requisition_header_id INTO l_requisition_header_id;
3427:
3428: l_progress := '0030';
3429: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3430: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' ReqLineId: '|| p_requisition_line_id(i) || ' Updated no. of rows: '|| sql%rowcount);
3431: END IF;
3432: END IF;
3433:
3434: --looping thru the line_id array and updating the reqs_in_pool_flag and at_sourcing_flag for the entire structure(including slins and options) of the selected line

Line 3488: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3484: AND requisition_header_id = l_requisition_header_id)));
3485: END LOOP;
3486:
3487: l_progress := '0040';
3488: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3489: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Update the selected requisitions reqs_in_pool_flag and at_sourcing_flag for the selected lines');
3490: END IF;
3491:
3492: l_progress := '0050';

Line 3489: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Update the selected requisitions reqs_in_pool_flag and at_sourcing_flag for the selected lines');

3485: END LOOP;
3486:
3487: l_progress := '0040';
3488: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3489: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Update the selected requisitions reqs_in_pool_flag and at_sourcing_flag for the selected lines');
3490: END IF;
3491:
3492: l_progress := '0050';
3493: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3493: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3489: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Update the selected requisitions reqs_in_pool_flag and at_sourcing_flag for the selected lines');
3490: END IF;
3491:
3492: l_progress := '0050';
3493: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3494: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: remove_from_req_pool');
3495: END IF;
3496:
3497: EXCEPTION

Line 3494: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: remove_from_req_pool');

3490: END IF;
3491:
3492: l_progress := '0050';
3493: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3494: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: remove_from_req_pool');
3495: END IF;
3496:
3497: EXCEPTION
3498: WHEN OTHERS THEN

Line 3503: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3501:
3502: l_progress := '0060';
3503: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3504: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3505: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3506: END IF;
3507:

Line 3504: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

3500: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3501:
3502: l_progress := '0060';
3503: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3504: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3505: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3506: END IF;
3507:
3508: raise; --raise exception

Line 3505: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);

3501:
3502: l_progress := '0060';
3503: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3504: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3505: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3506: END IF;
3507:
3508: raise; --raise exception
3509:

Line 3681: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3678: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3679:
3680: l_progress := '0060';
3681: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3682: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3684: END IF;
3685:

Line 3682: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

3678: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3679:
3680: l_progress := '0060';
3681: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3682: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3684: END IF;
3685:
3686: raise; --raise exception

Line 3683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);

3679:
3680: l_progress := '0060';
3681: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3682: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3684: END IF;
3685:
3686: raise; --raise exception
3687:

Line 3757: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3754: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3755:
3756: l_progress := '0060';
3757: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3758: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3759: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3760: END IF;
3761:

Line 3758: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

3754: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3755:
3756: l_progress := '0060';
3757: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3758: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3759: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3760: END IF;
3761:
3762: raise; --raise exception

Line 3759: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);

3755:
3756: l_progress := '0060';
3757: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3758: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3759: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3760: END IF;
3761:
3762: raise; --raise exception
3763:

Line 3874: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3871: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3872:
3873: l_progress := '0060';
3874: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3875: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3876: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3877: END IF;
3878:

Line 3875: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

3871: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3872:
3873: l_progress := '0060';
3874: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3875: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3876: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3877: END IF;
3878:
3879: raise; --raise exception

Line 3876: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);

3872:
3873: l_progress := '0060';
3874: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3875: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3876: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3877: END IF;
3878:
3879: raise; --raise exception
3880:

Line 3951: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3948: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3949:
3950: l_progress := '0060';
3951: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3952: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3953: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3954: END IF;
3955:

Line 3952: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

3948: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
3949:
3950: l_progress := '0060';
3951: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3952: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3953: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3954: END IF;
3955:
3956: raise; --raise exception

Line 3953: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);

3949:
3950: l_progress := '0060';
3951: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3952: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
3953: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' sqlerrm: '||sqlerrm);
3954: END IF;
3955:
3956: raise; --raise exception
3957: END update_sol_ref_amend;