eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_SOURCING_OPENAPI_GRP

Line 1: PACKAGE BODY pon_sourcing_openapi_grp AS

1: PACKAGE BODY pon_sourcing_openapi_grp AS
2: /* $Header: PONRNBAB.pls 120.36.12020000.3 2013/05/02 08:24:35 hvutukur ship $ */
3:
4: g_call_purge BOOLEAN := false;
5:

Line 69: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',

65: BEGIN
66:
67: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
68: fnd_log.string(fnd_log.level_statement,
69: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
70: 'Entered with input -- '||
71: 'p_interface_id : '|| p_interface_id);
72: end if;
73:

Line 89: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',

85: );
86:
87: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
88: fnd_log.string(fnd_log.level_statement,
89: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
90: 'returning with output -- '||
91: 'x_document_number : '|| x_document_number ||
92: 'x_document_url : ' || x_document_url ||
93: 'x_request_id : ' || l_request_id ||

Line 133: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',

129: BEGIN
130:
131: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
132: fnd_log.string(fnd_log.level_statement,
133: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
134: 'Entered with input -- '||
135: 'p_interface_id : '|| p_interface_id);
136: end if;
137:

Line 162: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',

158: end if;
159:
160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
161: fnd_log.string(fnd_log.level_statement,
162: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
163: 'returning with output -- '||
164: 'x_document_number : '|| x_document_number ||
165: 'x_document_url : ' || x_document_url ||
166: 'x_request_id : ' || x_request_id ||

Line 305: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

301: IF (p_is_concurrent_call = 'Y') THEN
302:
303: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
304: fnd_log.string(fnd_log.level_statement,
305: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
306: 'This is a concurrent call');
307: end if;
308:
309: x_document_number := p_document_number;

Line 336: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

332: WHERE interface_auction_header_id = p_interface_id;
333:
334: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
335: fnd_log.string(fnd_log.level_statement,
336: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
337: x_error_message);
338: end if;
339:
340: RETURN;

Line 360: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

356: WHERE interface_auction_header_id = p_interface_id;
357:
358: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
359: fnd_log.string(fnd_log.level_statement,
360: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
361: x_error_message);
362: end if;
363:
364: RETURN;

Line 369: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

365: END IF;
366:
367: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
368: fnd_log.string(fnd_log.level_statement,
369: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
370: 'Counting the number of lines for p_interface_id : ' || p_interface_id);
371: end if;
372:
373: SELECT count(p_interface_id)

Line 380: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

376: WHERE interface_auction_header_id = p_interface_id;
377:
378: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
379: fnd_log.string(fnd_log.level_statement,
380: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
381: 'l_number_of_lines (number of lines to copy into PON tables, which may not be the same as the value in number_of_lines field in PON_AUCTION_HEADERS_ALL for this auction) : '||
382: l_number_of_lines ||';Cheking if l_number_of_lines > Threshold for p_party_id: '|| v_site_id);
383: end if;
384:

Line 448: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

444: IF (p_is_concurrent_call = 'N') THEN
445:
446: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
447: fnd_log.string(fnd_log.level_statement,
448: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
449: 'This is not a concurrent call; Handling Header information now; Validating the header');
450: end if;
451:
452: -- Validate data in the PON_AUC_HEADERS_INTERFACE table

Line 469: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

465: WHERE interface_auction_header_id = p_interface_id;
466:
467: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
468: fnd_log.string(fnd_log.level_statement,
469: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
470: 'Error in validating the header; error mesg : ' ||x_error_message);
471: end if;
472:
473: RETURN;

Line 483: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

479:
480:
481: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
482: fnd_log.string(fnd_log.level_statement,
483: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
484: 'preparing to insert a row in the transaction table');
485: end if;
486:
487: -- Get the document_number from sequence and store it so that it can

Line 492: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

488: -- be returned
489:
490: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
491: fnd_log.string(fnd_log.level_statement,
492: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
493: 'Getting the document_number from sequence');
494: end if;
495:
496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number

Line 501: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

497: FROM dual;
498:
499: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
500: fnd_log.string(fnd_log.level_statement,
501: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
502: 'New document_number is (x_document_number) : ' ||x_document_number);
503: end if;
504:
505: --Also get the document url and store it

Line 530: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',

526: when others then
527: v_auc_contact_id := null;
528: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
529: fnd_log.string(fnd_log.level_statement,
530: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
531: 'Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
532: end if;
533: end;
534:

Line 539: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

535: v_contracts_doctype := pon_conterms_utl_pvt.get_negotiation_doc_type(v_doctype_id);
536:
537: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
538: fnd_log.string(fnd_log.level_statement,
539: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
540: 'Calling okc_terms_copy_grp.copy_doc with parameters -- '||
541: 'v_contracts_doctype : ' || v_contracts_doctype ||
542: 'x_document_number : ' || x_document_number ||
543: 'v_auc_contact_id : '|| v_auc_contact_id

Line 554: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

550: l_old_policy := mo_global.get_access_mode();
551: l_old_org_id := mo_global.get_current_org_id();
552: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
553: fnd_log.string(fnd_log.level_statement,
554: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
555: 'Getting current policy -- '||
556: 'old policy : ' || l_old_policy ||
557: 'old org_id : ' || l_old_org_id
558: );

Line 605: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

601:
602:
603: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
604: fnd_log.string(fnd_log.level_statement,
605: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
606: 'Executed copy_doc() ; returned with status : ' ||v_return_status);
607: end if;
608:
609: if (v_return_status <> fnd_api.g_ret_sts_success) then

Line 612: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

608:
609: if (v_return_status <> fnd_api.g_ret_sts_success) then
610: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
611: fnd_log.string(fnd_log.level_statement,
612: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
613: 'Call to copy_doc() failed for source_id=' || g_header_rec.source_doc_id || ' target_id=' || x_document_number);
614: end if;
615:
616: x_result := 'FAILURE';

Line 653: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

649: -- Default style allows quantity based price tiers passing Y as p_qty_price_tiers_enabled.
650:
651: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN --{
652: fnd_log.string(fnd_log.level_statement,
653: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
654: 'Calling the PON_AUCTION_PKG.GET_DEFAULT_TIERS_INDICATOR API to get the' ||
655: ' default price tiers indicator value.');
656: END IF;
657:

Line 668: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

664: x_price_tiers_indicator => v_price_tiers_indicator);
665:
666: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
667: fnd_log.string(fnd_log.level_statement,
668: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
669: 'Inserting row into PON_AUCTION_HEADERS_ALL with the following filed values -- ' ||
670: 'auction_header_id (x_document_number) : '|| x_document_number ||
671: '; document_number (x_document_number) : ' || x_document_number ||
672: '; amendment_number : ' || 0 ||

Line 729: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

725: l_line_uda_temp_id := NULL;
726:
727: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => v_doctype_id) = 1 THEN
728: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
729: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
730: 'Retrieve Uda Template Id for Header');
731: end if;
732:
733: l_uda_template_id := po_uda_data_util.get_template_id (

Line 742: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

738: sysdate,
739: v_return_status,
740: v_error_message);
741: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
742: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
743: 'Return from po_uda_data_util.get_template_id '||v_return_status);
744: end if;
745:
746: IF ( v_return_status = 'E' ) THEN

Line 758: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

754: WHERE interface_auction_header_id = p_interface_id;
755:
756: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
757: fnd_log.string(fnd_log.level_statement,
758: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
759: x_error_message);
760: end if;
761:
762: RETURN;

Line 765: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

761:
762: RETURN;
763: END IF;
764: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
765: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
766: 'Got uda_template_id for Header'||l_uda_template_id);
767: end if;
768:
769: l_uda_template_date := sysdate;

Line 784: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

780: v_error_message);
781:
782:
783: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
784: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
785: 'Return from Line po_uda_data_util.get_template_id '||v_return_status);
786: end if;
787:
788: IF ( v_return_status = 'E' ) THEN

Line 800: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

796: WHERE interface_auction_header_id = p_interface_id;
797:
798: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
799: fnd_log.string(fnd_log.level_statement,
800: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
801: x_error_message);
802: end if;
803:
804: RETURN;

Line 807: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

803:
804: RETURN;
805: END IF;
806: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
807: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
808: 'Got uda_template_id for Line '||l_line_uda_temp_id);
809: end if;
810:
811: /* Bug : 16690156 : Get STANDARD_FORM, DOCUMENT_FORMAT default values */

Line 819: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

815: FROM po_print_form_formats
816: WHERE document_type = 'PO_SOL_STD_FORM' AND default_flag = 'Y' ;
817:
818: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
819: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
820: 'Got default standard_form, document_format : l_standard_form '||l_standard_form||' l_document_format '||l_document_format);
821: end if;
822:
823: EXCEPTION

Line 826: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

822:
823: EXCEPTION
824: WHEN No_Data_Found THEN
825: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
826: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
827: 'Default values donot exist for standard form and document format');
828: end if;
829: l_standard_form := NULL;
830: l_document_format := NULL;

Line 968: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

964: --Copy Header Udas
965:
966: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => v_doctype_id) = 1 THEN
967: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
968: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
969: 'Copy Header UDA from PO to Solicitation');
970: end if;
971: -- bug#9645160
972: PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA

Line 1029: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1025: WHERE interface_auction_header_id = p_interface_id;
1026:
1027: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1028: fnd_log.string(fnd_log.level_statement,
1029: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1030: x_error_message);
1031: end if;
1032:
1033: RETURN;

Line 1036: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

1032:
1033: RETURN;
1034: END IF;
1035: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1036: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
1037: 'Copy Header Uda Status '||v_return_status);
1038: end if;
1039: end if;
1040: --

Line 1044: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1040: --
1041:
1042: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1043: fnd_log.string(fnd_log.level_statement,
1044: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1045: 'Inserted recore into pon_auction_headers_all');
1046: end if;
1047:
1048: END IF; --end of IF (p_is_concurrent_call = 'N')

Line 1063: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1059: --{
1060: -- price break line setting, this should be called after header is inserted
1061: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1062: fnd_log.string(fnd_log.level_statement,
1063: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1064: 'calling PON_AUCTION_PKG.get_default_pb_settings with x_document_number : ' || x_document_number);
1065: end if;
1066:
1067: PON_AUCTION_PKG.get_default_pb_settings (x_document_number,

Line 1073: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1069: v_price_break_neg_flag);
1070:
1071: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1072: fnd_log.string(fnd_log.level_statement,
1073: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1074: 'v_price_break_type : ' || v_price_break_type || '; v_price_break_neg_flag : ' || v_price_break_neg_flag);
1075: end if;
1076:
1077:

Line 1084: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1080: v_debug_status := 'VALIDATE_ITEM' ;
1081:
1082: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1083: fnd_log.string(fnd_log.level_statement,
1084: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1085: 'validating PON_AUCTION_ITEM_PRICES_INTERFACE; calling val_auc_items_interface with p_interface_id : ' || p_interface_id);
1086: end if;
1087:
1088: val_auc_items_interface(p_interface_id, v_error_code, v_error_message);

Line 1104: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1100: WHERE interface_auction_header_id = p_interface_id;
1101:
1102: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1103: fnd_log.string(fnd_log.level_statement,
1104: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1105: 'error when validating PON_AUCTION_ITEM_PRICES_INTERFACE; x_error_message : ' || x_error_message);
1106: end if;
1107:
1108: RETURN;

Line 1115: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1111: -- Validate data in the PON_AUCTION_SHIPMENTS_INTERFACE table
1112:
1113: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1114: fnd_log.string(fnd_log.level_statement,
1115: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1116: 'validating PON_AUCTION_SHIPMENTS_INTERFACE; calling val_auc_shipments_interface with p_interface_id : ' || p_interface_id);
1117: end if;
1118:
1119: val_auc_shipments_interface(p_interface_id,v_error_code, v_error_message);

Line 1134: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1130: WHERE interface_auction_header_id = p_interface_id;
1131:
1132: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1133: fnd_log.string(fnd_log.level_statement,
1134: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1135: 'error when validating PON_AUCTION_SHIPMENTS_INTERFACE; x_error_message : ' || x_error_message);
1136: end if;
1137:
1138: RETURN;

Line 1144: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1140: END IF; -- end if (g_header_rec.origination_code <> 'CONTRACT')
1141:
1142: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1143: fnd_log.string(fnd_log.level_statement,
1144: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1145: 'validating PON_ATTACHMENTS_INTERFACE; calling val_attachments_interface with p_interface_id : ' || p_interface_id);
1146: end if;
1147:
1148: -- Validate data in the PON_ATTACHMENTS_INTERFACE table

Line 1164: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1160: WHERE interface_auction_header_id = p_interface_id;
1161:
1162: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1163: fnd_log.string(fnd_log.level_statement,
1164: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1165: 'error when validating PON_ATTACHMENTS_INTERFACE; x_error_message : ' || x_error_message);
1166: end if;
1167:
1168: RETURN;

Line 1173: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1169: END IF;
1170:
1171: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1172: fnd_log.string(fnd_log.level_statement,
1173: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1174: 'getting category id for VENDOR attachments');
1175: end if;
1176:
1177: -- get category id for VENDOR attachments

Line 1191: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1187: X_ERROR_CODE := 'CREATE_DRAFT:ATTACHMENT_CATEGORY_ID';
1188: X_ERROR_MESSAGE := 'The attachment category id for name=VENDOR could not be found';
1189: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1190: fnd_log.string(fnd_log.level_statement,
1191: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1192: 'error when getting category id for VENDOR attachments; x_error_message : ' || X_ERROR_MESSAGE);
1193: end if;
1194:
1195: RETURN;

Line 1200: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1196: END;
1197:
1198: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1199: fnd_log.string(fnd_log.level_statement,
1200: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1201: 'getting UOM for amount based line types');
1202: end if;
1203:
1204: -- Get UOM for amount based line types

Line 1243: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1239: WHERE interface_auction_header_id = p_interface_id;
1240:
1241: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1242: fnd_log.string(fnd_log.level_statement,
1243: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1244: 'Max lines to copy (l_max_line_number) : ' || l_max_line_number);
1245: end if;
1246:
1247:

Line 1257: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1253: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
1254:
1255: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1256: fnd_log.string(fnd_log.level_statement,
1257: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1258: 'Starting batching with batchsize (l_batch_size) : ' || l_batch_size);
1259: end if;
1260:
1261: -- for testing purpose

Line 1277: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1273: WHILE (l_batch_start <= l_max_line_number) LOOP
1274:
1275: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1276: fnd_log.string(fnd_log.level_statement,
1277: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1278: 'Batching the line_numbers in the range '|| l_batch_start ||' to '|| l_batch_end ||' (inclusive)');
1279: end if;
1280:
1281:

Line 1290: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1286: v_debug_status := 'INSERT_PON_AUC_ITEMS';
1287:
1288: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1289: fnd_log.string(fnd_log.level_statement,
1290: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1291: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');
1292: end if;
1293:
1294:

Line 1308: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1304: AND interface_line_number <= l_batch_end;
1305:
1306: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1307: fnd_log.string(fnd_log.level_statement,
1308: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1309: 'inserting into pon_auction_item_prices_all for auction_header_id (x_document_number) : ' || x_document_number);
1310: end if;
1311:
1312: -- Then insert into the items transaction table.

Line 1451: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1447: -- Update the shipments flag based on if their are shipments
1448:
1449: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1450: fnd_log.string(fnd_log.level_statement,
1451: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1452: ' Updating the shipments flag based on if there are shipments');
1453: end if;
1454:
1455: UPDATE pon_auction_item_prices_all

Line 1469: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1465: -- ADDED FOR SERVICES PROCUREMENT PROJECT
1466: -- Update the price differntials flag based on if their are price differentials at item level
1467: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1468: fnd_log.string(fnd_log.level_statement,
1469: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1470: ' Updating the price differntials flag based on if their are price differentials at item level');
1471: end if;
1472:
1473: UPDATE pon_auction_item_prices_all

Line 1500: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1496: -- AND interface_line_number IS NOT NULL);
1497:
1498: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1499: fnd_log.string(fnd_log.level_statement,
1500: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1501: ' CAlling Add_Catalog_Descriptors with x_document_number : ' || x_document_number || '; p_interface_id : ' || p_interface_id);
1502: end if;
1503:
1504: Add_Catalog_Descriptors (x_document_number, p_interface_id,l_batch_start,l_batch_end);

Line 1515: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1511: --Copy Header Udas
1512:
1513: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => v_doctype_id) = 1 THEN
1514: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1515: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1516: 'Copy Line UDA from PO to Solicitation');
1517: end if;
1518:
1519: -- Insert price breaks information into the transaction table

Line 1574: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1570: AND line_number = l_lineno_list(i);
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1574: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1575: 'Exception in updating complex pricing extended price ');
1576: END IF;
1577: END;
1578: ELSE

Line 1617: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

1613: v_msg_data);
1614:
1615: exit when ( v_return_status = 'E');
1616: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1617: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
1618: 'Copy Shipment Uda Status '||v_return_status||' '||l_lineloc_list(j));
1619: end if;
1620: end loop;
1621: END IF;

Line 1635: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1631: WHERE interface_auction_header_id = p_interface_id;
1632:
1633: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1634: fnd_log.string(fnd_log.level_statement,
1635: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1636: x_error_message);
1637: end if;
1638:
1639: RETURN;

Line 1642: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',

1638:
1639: RETURN;
1640: END IF;
1641: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1642: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
1643: 'Copy Line Uda Status '||v_return_status||' '||l_lineno_list(i));
1644: end if;
1645: end loop;
1646: end if;

Line 1661: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1657: -- clause
1658:
1659: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1660: fnd_log.string(fnd_log.level_statement,
1661: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1662: ' copying price breaks and price break level price differentials' );
1663: end if;
1664:
1665: INSERT INTO pon_auction_shipments_all

Line 1725: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1721: v_debug_status := 'INSERT_PRICE_DIFFERENTIALS_ITEM';
1722:
1723: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1724: fnd_log.string(fnd_log.level_statement,
1725: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1726: 'Inserting price differentials information into the transaction table at item level' );
1727: end if;
1728:
1729: INSERT INTO pon_price_differentials

Line 1773: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1769: -- at shipment level
1770:
1771: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1772: fnd_log.string(fnd_log.level_statement,
1773: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1774: 'Inserting price differentials information into the transaction table at shipment level' );
1775: end if;
1776:
1777: INSERT INTO pon_price_differentials

Line 1815: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1811: v_debug_status := 'INSERT_LINE_ATTACHMENTS';
1812:
1813: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1814: fnd_log.string(fnd_log.level_statement,
1815: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1816: 'Copying over the (Line) attachments from the PON_ATTACHMENTS_INTERFACE table' );
1817: end if;
1818:
1819: INSERT INTO fnd_attached_documents

Line 1864: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1860: --table for all the items that have attachments.
1861:
1862: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1863: fnd_log.string(fnd_log.level_statement,
1864: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1865: 'Updating the attachment_flag in pon_auction_item_prices_all table for all the items that have attachments.' );
1866: end if;
1867:
1868: UPDATE pon_auction_item_prices_all

Line 1887: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1883:
1884: IF (p_is_concurrent_call = 'Y') THEN
1885: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1886: fnd_log.string(fnd_log.level_statement,
1887: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1888: 'This being a concurrent call, the batch is being committed( from line numbers ' || l_batch_start || ' to ' || l_batch_end);
1889: end if;
1890:
1891: COMMIT;

Line 1905: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1901: END IF;
1902:
1903: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1904: fnd_log.string(fnd_log.level_statement,
1905: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1906: 'Computed the window for next batch to be ' || l_batch_start || ' to ' || l_batch_end || ' (inclusive) ' );
1907: end if;
1908:
1909: END LOOP;

Line 1918: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1914: --BATCHING ENDS HERE--
1915: ----------------------------------------------------------------------------------------------------
1916: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1917: fnd_log.string(fnd_log.level_statement,
1918: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1919: ' Before updating exhibits, check if elins are enabled or not');
1920: end if;
1921: /* Bug : 16690958 : Update exhibit_number field for the lines */
1922: IF PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(g_header_rec.org_id, v_doctype_id) = 'Y' THEN

Line 1926: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1922: IF PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(g_header_rec.org_id, v_doctype_id) = 'Y' THEN
1923:
1924: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1925: fnd_log.string(fnd_log.level_statement,
1926: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1927: ' Before updating exhibit numbers');
1928: end if;
1929:
1930: UPDATE pon_auction_item_prices_all ai

Line 1944: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1940: OR PON_EXHIBITS_PKG.IS_CDRLS_ENABLED(g_header_rec.org_id, v_doctype_id) = 'Y' THEN
1941:
1942: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1943: fnd_log.string(fnd_log.level_statement,
1944: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1945: ' Insert exhibit details into pon_auction_exhibit_details');
1946: end if;
1947:
1948: INSERT INTO pon_auction_exhibit_details

Line 1993: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

1989: v_debug_status := 'INSERT_HEADER_ATTACHMENTS';
1990:
1991: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1992: fnd_log.string(fnd_log.level_statement,
1993: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1994: 'Copying over the (header)attachments from the PON_ATTACHMENTS_INTERFACE table' );
1995: end if;
1996:
1997: INSERT INTO fnd_attached_documents

Line 2045: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2041: IF (v_set_as_bidders_curr = 'Y' AND v_blanket_bidders_curr = 'Y') THEN
2042:
2043: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2044: fnd_log.string(fnd_log.level_statement,
2045: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2046: 'Copying over the currency into PON_AUC_CURR_INFO table' );
2047: end if;
2048:
2049: INSERT INTO pon_auction_currency_rates

Line 2082: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2078: v_debug_status := 'INSERT_SUPPLIER_INFO';
2079:
2080: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2081: fnd_log.string(fnd_log.level_statement,
2082: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2083: 'Addding the supplier information on the blanket to the PON_BIDDING_PARTIES; selectiong supplier_site_id' );
2084: end if;
2085:
2086: select supplier_site_id

Line 2110: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2106:
2107: --lxchen
2108: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2109: fnd_log.string(fnd_log.level_statement,
2110: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2111: 'Getting supplier information' );
2112: end if;
2113:
2114: -- Get the supplier information

Line 2135: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2131: WHERE interface_auction_header_id = p_interface_id;
2132:
2133: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2134: fnd_log.string(fnd_log.level_statement,
2135: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2136: 'Error in retrieving supplier information for supplier_id : ' || g_header_rec.supplier_id );
2137: end if;
2138:
2139: RETURN;

Line 2144: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2140: END IF;
2141:
2142: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2143: fnd_log.string(fnd_log.level_statement,
2144: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2145: 'Inserting record into PON_BIDDING_PARTIES' );
2146: end if;
2147:
2148:

Line 2195: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2191: --to handle the children
2192: --
2193: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2194: fnd_log.string(fnd_log.level_statement,
2195: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2196: 'Is this auction super large? (l_is_super_large_neg) : ' || l_is_super_large_neg);
2197: end if;
2198:
2199: IF (l_is_super_large_neg = 'Y') THEN

Line 2202: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2198:
2199: IF (l_is_super_large_neg = 'Y') THEN
2200: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2201: fnd_log.string(fnd_log.level_statement,
2202: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2203: 'Raising a concurrent request here');
2204: end if;
2205:
2206: --RAISE CONCURRENT REQUEST HERE

Line 2220: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2216: );
2217:
2218: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2219: fnd_log.string(fnd_log.level_statement,
2220: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2221: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
2222: end if;
2223:
2224: update pon_auction_headers_all set

Line 2244: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2240: -----------------------------------------------------------------------------
2241: -- Set the result to success and unset any variables required.
2242: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2243: fnd_log.string(fnd_log.level_statement,
2244: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2245: 'Setting the result to success');
2246: end if;
2247:
2248: x_result := 'SUCCESS';

Line 2263: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2259: IF (l_is_super_large_neg = 'N') OR (l_is_super_large_neg = 'Y' AND p_is_concurrent_call = 'Y') THEN
2260:
2261: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2262: fnd_log.string(fnd_log.level_statement,
2263: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2264: 'updating the process_status in pon_auc_headers_interface to ACCEPTED');
2265: end if;
2266:
2267: UPDATE pon_auc_headers_interface

Line 2273: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2269: WHERE interface_auction_header_id = p_interface_id;
2270:
2271: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2272: fnd_log.string(fnd_log.level_statement,
2273: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2274: 'updating the complete_flag in pon_auc_headers_all to Y');
2275: end if;
2276:
2277:

Line 2299: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2295: --COMMIT;
2296:
2297: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2298: fnd_log.string(fnd_log.level_statement,
2299: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2300: 'returning with output -- '||
2301: 'x_document_number : '|| x_document_number ||
2302: 'x_document_url : ' || x_document_url ||
2303: 'x_result : ' || x_result ||

Line 2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2307:
2308: EXCEPTION
2309: WHEN others THEN
2310: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2312: fnd_message.set_token('PROCEDURE', 'create_draft_neg_interface');
2313: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2314:
2315: ROLLBACK TO SAVEPOINT pon_before_insert;

Line 2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2424:
2425: EXCEPTION
2426: WHEN others THEN
2427: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2429: fnd_message.set_token('PROCEDURE', 'val_auc_headers_interface');
2430: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2431: app_exception.raise_exception;
2432:

Line 2461: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2457: v_debug_status := 'VALIDATING_ITEMS';
2458:
2459: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2460: fnd_log.string(fnd_log.level_statement,
2461: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2462: 'Validating the lines in the range ; validating item org_id');
2463: end if;
2464:
2465: -- validate item org_id is the same as that in the header

Line 2476: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2472: IF (v_invalid_item_recs IS NOT NULL ) THEN
2473:
2474: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2475: fnd_log.string(fnd_log.level_statement,
2476: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2477: 'Error in validating item org_id');
2478: end if;
2479:
2480: x_error_code := 'VALIDATE_ITEMS:INCORRECT_ORG_ID';

Line 2490: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2486: -- Validate origination_code is BLANKET
2487:
2488: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2489: fnd_log.string(fnd_log.level_statement,
2490: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2491: 'Validating origination_code is BLANKET');
2492: end if;
2493:
2494: v_debug_status := 'VALIDATE_LINE_ORG_CODE';

Line 2505: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2501: IF (v_invalid_item_recs IS NOT NULL ) THEN
2502:
2503: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2504: fnd_log.string(fnd_log.level_statement,
2505: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2506: 'Error in validating origination_code is BLANKET');
2507: end if;
2508:
2509: x_error_code := 'VALIDATE_ITEMS:INVALID_LINE_ORIGINATION_CODE';

Line 2519: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2515: -- Validate that price_break_type values are CUMULATIVE, NON-CUMMULATIVE or null
2516:
2517: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2518: fnd_log.string(fnd_log.level_statement,
2519: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2520: 'Validating that price_break_type values are CUMULATIVE, NON-CUMMULATIVE or null');
2521: end if;
2522:
2523: v_debug_status := 'VALIDATE_PRICE_BREAK_TYPE';

Line 2534: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2530: IF (v_invalid_item_recs IS NOT NULL ) THEN
2531:
2532: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2533: fnd_log.string(fnd_log.level_statement,
2534: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2535: 'Error in validating that price_break_type values are CUMULATIVE, NON-CUMMULATIVE or null');
2536: end if;
2537:
2538: x_error_code := 'VALIDATE_ITEMS:INVALID_PRICE_BREAK_TYPE';

Line 2546: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2542: END if;
2543:
2544: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2545: fnd_log.string(fnd_log.level_statement,
2546: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2547: 'Returning with x_error_code : ' || x_error_code || '; x_error_message : ' || x_error_message);
2548: end if;
2549:
2550: EXCEPTION

Line 2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2549:
2550: EXCEPTION
2551: WHEN others THEN
2552: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2554: fnd_message.set_token('PROCEDURE', 'val_auc_items_interface');
2555: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2556: app_exception.raise_exception;
2557:

Line 2584: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2580: BEGIN
2581:
2582: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2583: fnd_log.string(fnd_log.level_statement,
2584: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2585: 'Entered the procedure');
2586: end if;
2587:
2588: -- validate item org_id is the same as that in the header

Line 2600: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',

2596: IF (v_shipment_rec IS NOT null) THEN
2597:
2598: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2599: fnd_log.string(fnd_log.level_statement,
2600: 'pon.plsql.pon_sourcing_openapi_grp.val_auc_items_interface',
2601: 'Error in validating item org_id');
2602: end if;
2603:
2604: x_error_code := 'VALIDATE_SHIPMENTS:INCORRECT_ORG_ID';

Line 2614: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

2610: -- Validate the shipment type columns have correct values
2611:
2612: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2613: fnd_log.string(fnd_log.level_statement,
2614: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2615: 'Validating the shipment type columns have correct values');
2616: end if;
2617:
2618: v_debug_status := 'VALIDATE_SHIPMENT_TYPE';

Line 2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2632:
2633: EXCEPTION
2634: WHEN others THEN
2635: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2637: fnd_message.set_token('PROCEDURE', 'val_auc_shipments_interface');
2638: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2639: app_exception.raise_exception;
2640:

Line 2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2666:
2667: EXCEPTION
2668: WHEN others THEN
2669: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2671: fnd_message.set_token('PROCEDURE', 'val_attachments_interface');
2672: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2673: app_exception.raise_exception;
2674:

Line 2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2762:
2763: EXCEPTION
2764: WHEN others THEN
2765: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2767: fnd_message.set_token('PROCEDURE', 'get_trading_partner_info');
2768: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2769: app_exception.raise_exception;
2770:

Line 2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

2844:
2845: EXCEPTION
2846: WHEN others THEN
2847: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2849: fnd_message.set_token('PROCEDURE', 'purge_interface_table');
2850: fnd_message.set_token('ERROR','[' || SQLERRM || ']');
2851: app_exception.raise_exception;
2852: END purge_interface_table;

Line 2897: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_SOURCING_OPENAPI_GRP';

2893: ,x_cpa_enabled OUT NOCOPY VARCHAR2) IS
2894:
2895: -- declare local variables
2896: l_api_name CONSTANT VARCHAR2(30) := 'IS_CPA_INTEGRATION_ENABLED';
2897: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_SOURCING_OPENAPI_GRP';
2898: l_api_version CONSTANT VARCHAR2(5) := '1.0';
2899:
2900: BEGIN
2901:

Line 2966: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_SOURCING_OPENAPI_GRP';

2962: x_return_status OUT NOCOPY VARCHAR2,
2963: x_msg_count OUT NOCOPY NUMBER,
2964: x_msg_data OUT NOCOPY VARCHAR2) IS
2965:
2966: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_SOURCING_OPENAPI_GRP';
2967: l_api_name CONSTANT VARCHAR2(30) := 'get_display_line_number';
2968: l_api_version CONSTANT NUMBER := 1.0;
2969:
2970: begin

Line 3197: 'pon.plsql.pon_sourcing_openapi_grp.initialise_globals',

3193: BEGIN
3194:
3195: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3196: fnd_log.string(fnd_log.level_statement,
3197: 'pon.plsql.pon_sourcing_openapi_grp.initialise_globals',
3198: 'Entered the procedure; initialising g_header_rec');
3199: end if;
3200:
3201: -- Read data into header record for convenience

Line 3208: 'pon.plsql.pon_sourcing_openapi_grp.initialise_globals',

3204: WHERE interface_auction_header_id = p_interface_id;
3205:
3206: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3207: fnd_log.string(fnd_log.level_statement,
3208: 'pon.plsql.pon_sourcing_openapi_grp.initialise_globals',
3209: 'initialised g_header_rec; Entered the procedure');
3210: end if;
3211:
3212: END INITIALISE_GLOBALS;

Line 3241: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3237:
3238: BEGIN
3239: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3240: fnd_log.string(fnd_log.level_statement,
3241: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3242: 'This is a concurrent program; Entered the procedure');
3243: end if;
3244:
3245: --set the message_suffix

Line 3258: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3254: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3255:
3256: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3257: fnd_log.string(fnd_log.level_statement,
3258: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3259: 'The request Id of this concurrent process is ' || l_request_id ||'; Now calling create_draft_neg_interface_pvt');
3260: end if;
3261:
3262: create_draft_neg_interface_pvt (

Line 3278: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3274: RETCODE := '2' ;
3275:
3276: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3277: fnd_log.string(fnd_log.level_statement,
3278: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3279: l_error_message);
3280: end if;
3281:
3282: ELSE

Line 3286: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3282: ELSE
3283:
3284: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3285: fnd_log.string(fnd_log.level_statement,
3286: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3287: 'purging the tables; calling PON_SOURCING_OPENAPI_GRP.PURGE_INTERFACE_TABLE()');
3288: end if;
3289:
3290: g_call_purge := true;

Line 3287: 'purging the tables; calling PON_SOURCING_OPENAPI_GRP.PURGE_INTERFACE_TABLE()');

3283:
3284: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3285: fnd_log.string(fnd_log.level_statement,
3286: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3287: 'purging the tables; calling PON_SOURCING_OPENAPI_GRP.PURGE_INTERFACE_TABLE()');
3288: end if;
3289:
3290: g_call_purge := true;
3291: PURGE_INTERFACE_TABLE (

Line 3302: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3298: RETCODE := '2' ;
3299:
3300: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3301: fnd_log.string(fnd_log.level_statement,
3302: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3303: l_error_message);
3304: end if;
3305:
3306: END IF;

Line 3310: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3306: END IF;
3307:
3308: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3309: fnd_log.string(fnd_log.level_statement,
3310: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3311: 'Notifying SUCCESS');
3312: end if;
3313:
3314: PON_WF_UTL_PKG.ReportConcProgramStatus (

Line 3333: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3329: --
3330:
3331: /* if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3332: fnd_log.string(fnd_log.level_statement,
3333: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3334: 'Clearing request_id in pon_auction_headers_all');
3335: end if;
3336:
3337: update pon_auction_headers_all

Line 3345: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3341: RETCODE := '0';
3342:
3343: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3344: fnd_log.string(fnd_log.level_statement,
3345: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3346: 'Cleared request_id in pon_auction_headers_all for auction_header_id : ' || p_auction_header_id ||' ; returning');
3347: end if;
3348:
3349: Commit;

Line 3365: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3361: p_DestinationPageCode => 'PON_MANAGE_DRAFT_NEG',
3362: p_bid_number => NULL);
3363: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3364: fnd_log.string(fnd_log.level_statement,
3365: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3366: 'Notifying FAILURE');
3367: end if;
3368:
3369: END IF;

Line 3430: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',

3426: sysdate + 7);
3427:
3428: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3429: fnd_log.string(fnd_log.level_statement,
3430: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3431: 'Notifying FAILURE');
3432: end if;
3433:
3434: --set the return code

Line 3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');

3483: WHEN OTHERS THEN
3484: x_result := FND_API.G_RET_STS_ERROR ;
3485: x_error_code := 'UNKNOWN_ERROR';
3486: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3491: fnd_message.retrieve(x_error_message);

Line 3499: END PON_SOURCING_OPENAPI_GRP;

3495:
3496: END maintain_clm_relations;
3497:
3498:
3499: END PON_SOURCING_OPENAPI_GRP;