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.

[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUC_HEADERS_INTERFACE

Line 330: UPDATE pon_auc_headers_interface

326: x_error_code := 'CREATE_DRAFT:GET_ENTERPRISE_ID';
327: x_error_message := 'Could not get the Enterprise ID. Error returned by get_enterprise_partyId method is - ' || Substr(v_error_message,1,150) ;
328:
329: -- Update the process_status column in header table
330: UPDATE pon_auc_headers_interface
331: SET process_status = 'REJECTED'
332: WHERE interface_auction_header_id = p_interface_id;
333:
334: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 354: UPDATE pon_auc_headers_interface

350: x_error_code := 'CREATE_DRAFT:GET_ENTERPRISE_NAME';
351: x_error_message := 'Could not get the Enterprise Name. Error returned by get_enterprise_partyId method is - ' || Substr(v_error_message,1,150) ;
352:
353: -- Update the process_status column in header table
354: UPDATE pon_auc_headers_interface
355: SET process_status = 'REJECTED'
356: WHERE interface_auction_header_id = p_interface_id;
357:
358: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 452: -- Validate data in the PON_AUC_HEADERS_INTERFACE table

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
453: v_debug_status := 'VALIDATE_HEADER';
454: val_auc_headers_interface(p_interface_id,v_error_code, v_error_message);
455:
456: -- Error encountered while validating auction header interface table data

Line 463: UPDATE pon_auc_headers_interface

459: x_error_code := v_error_code;
460: x_error_message := v_error_message;
461:
462: -- Update the process_status column in header table
463: UPDATE pon_auc_headers_interface
464: SET process_status = 'REJECTED'
465: WHERE interface_auction_header_id = p_interface_id;
466:
467: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 752: UPDATE pon_auc_headers_interface

748: x_error_code := 'CREATE_DRAFT:GET_UDA_TEMPLATE_ID';
749: x_error_message := 'Could not get UDA_TEMPLATE_ID.' || Substr(v_error_message,1,200) ;
750:
751: -- Update the process_status column in header table
752: UPDATE pon_auc_headers_interface
753: SET process_status = 'REJECTED'
754: WHERE interface_auction_header_id = p_interface_id;
755:
756: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 794: UPDATE pon_auc_headers_interface

790: x_error_code := 'CREATE_DRAFT:GET_UDA_TEMPLATE_ID';
791: x_error_message := 'Could not get UDA_TEMPLATE_ID.' || Substr(v_error_message,1,200) ;
792:
793: -- Update the process_status column in header table
794: UPDATE pon_auc_headers_interface
795: SET process_status = 'REJECTED'
796: WHERE interface_auction_header_id = p_interface_id;
797:
798: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1023: UPDATE pon_auc_headers_interface

1019: x_error_code := 'CREATE_DRAFT:COPY_HEADER_UDA';
1020: x_error_message := 'Could not copy Hdr Uda.' || Substr(v_msg_data,1,200) ;
1021:
1022: -- Update the process_status column in header table
1023: UPDATE pon_auc_headers_interface
1024: SET process_status = 'REJECTED'
1025: WHERE interface_auction_header_id = p_interface_id;
1026:
1027: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1098: UPDATE pon_auc_headers_interface

1094: x_error_message := v_error_message;
1095:
1096:
1097: -- Update the process_status column in header table
1098: UPDATE pon_auc_headers_interface
1099: SET process_status = 'REJECTED'
1100: WHERE interface_auction_header_id = p_interface_id;
1101:
1102: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1128: UPDATE pon_auc_headers_interface

1124: x_error_code := v_error_code;
1125: x_error_message := v_error_message;
1126:
1127: -- Update the process_status column in header table
1128: UPDATE pon_auc_headers_interface
1129: SET process_status = 'REJECTED'
1130: WHERE interface_auction_header_id = p_interface_id;
1131:
1132: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1158: UPDATE pon_auc_headers_interface

1154: x_error_code := v_error_code;
1155: x_error_message := v_error_message;
1156:
1157: -- Update the process_status column in header table
1158: UPDATE pon_auc_headers_interface
1159: SET process_status = 'REJECTED'
1160: WHERE interface_auction_header_id = p_interface_id;
1161:
1162: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1629: UPDATE pon_auc_headers_interface

1625: x_error_code := 'CREATE_DRAFT:COPY_LINE_UDA';
1626: x_error_message := 'Could not copy Line Uda.' || Substr(v_msg_data,1,200) ;
1627:
1628: -- Update the process_status column in header table
1629: UPDATE pon_auc_headers_interface
1630: SET process_status = 'REJECTED'
1631: WHERE interface_auction_header_id = p_interface_id;
1632:
1633: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 2088: from pon_auc_headers_interface

2084: end if;
2085:
2086: select supplier_site_id
2087: into v_supplier_site_id
2088: from pon_auc_headers_interface
2089: WHERE interface_auction_header_id = p_interface_id;
2090:
2091: if(v_supplier_site_id is not null and v_supplier_site_id <> -1) then
2092: BEGIN

Line 2129: UPDATE pon_auc_headers_interface

2125: x_error_code := v_error_code;
2126: x_error_message := v_error_message;
2127:
2128: -- Update the process_status column in header table
2129: UPDATE pon_auc_headers_interface
2130: SET process_status = 'REJECTED'
2131: WHERE interface_auction_header_id = p_interface_id;
2132:
2133: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 2264: 'updating the process_status in pon_auc_headers_interface to ACCEPTED');

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
2268: SET process_status = 'ACCEPTED'

Line 2267: UPDATE pon_auc_headers_interface

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
2268: SET process_status = 'ACCEPTED'
2269: WHERE interface_auction_header_id = p_interface_id;
2270:
2271: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 2328: COMMENT : validates the data in the pon_auc_headers_interface table

2324: p_interface_id IN interface id for the auction that is being validated
2325: x_error_code OUT NOCOPY error code if any error generate
2326: x_error_message OUT NOCOPY error message if any error
2327:
2328: COMMENT : validates the data in the pon_auc_headers_interface table
2329: ======================================================================*/
2330:
2331: PROCEDURE val_auc_headers_interface(p_interface_id NUMBER,
2332: x_error_code OUT NOCOPY VARCHAR2,

Line 2354: -- in the PON_AUC_HEADERS_INTERFACE table.

2350: END IF;
2351:
2352:
2353: -- Validate that there is a single record for p_interface_id
2354: -- in the PON_AUC_HEADERS_INTERFACE table.
2355: SELECT COUNT(*) INTO v_count_auc_headers_interface
2356: FROM pon_auc_headers_interface
2357: WHERE interface_auction_header_id = p_interface_id;
2358:

Line 2356: FROM pon_auc_headers_interface

2352:
2353: -- Validate that there is a single record for p_interface_id
2354: -- in the PON_AUC_HEADERS_INTERFACE table.
2355: SELECT COUNT(*) INTO v_count_auc_headers_interface
2356: FROM pon_auc_headers_interface
2357: WHERE interface_auction_header_id = p_interface_id;
2358:
2359: IF (v_count_auc_headers_interface = 0 )THEN
2360: x_error_code := 'VALIDATE_HDR:INVALID_INTERFACE_ID';

Line 2368: FROM pon_auc_headers_interface

2364:
2365: -- Validate that the process_status for the record is null
2366: /**
2367: SELECT process_status INTO v_process_status
2368: FROM pon_auc_headers_interface
2369: WHERE interface_auction_header_id = p_interface_id;
2370:
2371: IF (v_process_status IS NOT NULL) THEN
2372: x_error_code := 'VALIDATE_HDR:INVALIDATE_PROCESS_STATUS';

Line 2807: DELETE FROM pon_auc_headers_interface

2803:
2804: -- Delete records from header table
2805: v_debug_status := 'DELETE_HEADER';
2806:
2807: DELETE FROM pon_auc_headers_interface
2808: WHERE interface_auction_header_id = p_interface_id;
2809:
2810: -- Delete records from item table
2811: v_debug_status := 'DELETE_ITEM';

Line 3203: FROM pon_auc_headers_interface

3199: end if;
3200:
3201: -- Read data into header record for convenience
3202: SELECT * INTO g_header_rec
3203: FROM pon_auc_headers_interface
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,