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_AUC_HEADERS_INTERFACE

Line 291: UPDATE pon_auc_headers_interface

287: x_error_code := 'CREATE_DRAFT:GET_ENTERPRISE_ID';
288: x_error_message := 'Could not get the Enterprise ID. Error returned by get_enterprise_partyId method is - ' || Substr(v_error_message,1,150) ;
289:
290: -- Update the process_status column in header table
291: UPDATE pon_auc_headers_interface
292: SET process_status = 'REJECTED'
293: WHERE interface_auction_header_id = p_interface_id;
294:
295: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 315: UPDATE pon_auc_headers_interface

311: x_error_code := 'CREATE_DRAFT:GET_ENTERPRISE_NAME';
312: x_error_message := 'Could not get the Enterprise Name. Error returned by get_enterprise_partyId method is - ' || Substr(v_error_message,1,150) ;
313:
314: -- Update the process_status column in header table
315: UPDATE pon_auc_headers_interface
316: SET process_status = 'REJECTED'
317: WHERE interface_auction_header_id = p_interface_id;
318:
319: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 413: -- Validate data in the PON_AUC_HEADERS_INTERFACE table

409: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
410: 'This is not a concurrent call; Handling Header information now; Validating the header');
411: end if;
412:
413: -- Validate data in the PON_AUC_HEADERS_INTERFACE table
414: v_debug_status := 'VALIDATE_HEADER';
415: val_auc_headers_interface(p_interface_id,v_error_code, v_error_message);
416:
417: -- Error encountered while validating auction header interface table data

Line 424: UPDATE pon_auc_headers_interface

420: x_error_code := v_error_code;
421: x_error_message := v_error_message;
422:
423: -- Update the process_status column in header table
424: UPDATE pon_auc_headers_interface
425: SET process_status = 'REJECTED'
426: WHERE interface_auction_header_id = p_interface_id;
427:
428: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 849: UPDATE pon_auc_headers_interface

845: x_error_message := v_error_message;
846:
847:
848: -- Update the process_status column in header table
849: UPDATE pon_auc_headers_interface
850: SET process_status = 'REJECTED'
851: WHERE interface_auction_header_id = p_interface_id;
852:
853: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 879: UPDATE pon_auc_headers_interface

875: x_error_code := v_error_code;
876: x_error_message := v_error_message;
877:
878: -- Update the process_status column in header table
879: UPDATE pon_auc_headers_interface
880: SET process_status = 'REJECTED'
881: WHERE interface_auction_header_id = p_interface_id;
882:
883: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 909: UPDATE pon_auc_headers_interface

905: x_error_code := v_error_code;
906: x_error_message := v_error_message;
907:
908: -- Update the process_status column in header table
909: UPDATE pon_auc_headers_interface
910: SET process_status = 'REJECTED'
911: WHERE interface_auction_header_id = p_interface_id;
912:
913: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1603: from pon_auc_headers_interface

1599: end if;
1600:
1601: select supplier_site_id
1602: into v_supplier_site_id
1603: from pon_auc_headers_interface
1604: WHERE interface_auction_header_id = p_interface_id;
1605:
1606: if(v_supplier_site_id is not null and v_supplier_site_id <> -1) then
1607: BEGIN

Line 1644: UPDATE pon_auc_headers_interface

1640: x_error_code := v_error_code;
1641: x_error_message := v_error_message;
1642:
1643: -- Update the process_status column in header table
1644: UPDATE pon_auc_headers_interface
1645: SET process_status = 'REJECTED'
1646: WHERE interface_auction_header_id = p_interface_id;
1647:
1648: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

1775:
1776: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1777: fnd_log.string(fnd_log.level_statement,
1778: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1779: 'updating the process_status in pon_auc_headers_interface to ACCEPTED');
1780: end if;
1781:
1782: UPDATE pon_auc_headers_interface
1783: SET process_status = 'ACCEPTED'

Line 1782: UPDATE pon_auc_headers_interface

1778: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1779: 'updating the process_status in pon_auc_headers_interface to ACCEPTED');
1780: end if;
1781:
1782: UPDATE pon_auc_headers_interface
1783: SET process_status = 'ACCEPTED'
1784: WHERE interface_auction_header_id = p_interface_id;
1785:
1786: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

1839: p_interface_id IN interface id for the auction that is being validated
1840: x_error_code OUT NOCOPY error code if any error generate
1841: x_error_message OUT NOCOPY error message if any error
1842:
1843: COMMENT : validates the data in the pon_auc_headers_interface table
1844: ======================================================================*/
1845:
1846: PROCEDURE val_auc_headers_interface(p_interface_id NUMBER,
1847: x_error_code OUT NOCOPY VARCHAR2,

Line 1869: -- in the PON_AUC_HEADERS_INTERFACE table.

1865: END IF;
1866:
1867:
1868: -- Validate that there is a single record for p_interface_id
1869: -- in the PON_AUC_HEADERS_INTERFACE table.
1870: SELECT COUNT(*) INTO v_count_auc_headers_interface
1871: FROM pon_auc_headers_interface
1872: WHERE interface_auction_header_id = p_interface_id;
1873:

Line 1871: FROM pon_auc_headers_interface

1867:
1868: -- Validate that there is a single record for p_interface_id
1869: -- in the PON_AUC_HEADERS_INTERFACE table.
1870: SELECT COUNT(*) INTO v_count_auc_headers_interface
1871: FROM pon_auc_headers_interface
1872: WHERE interface_auction_header_id = p_interface_id;
1873:
1874: IF (v_count_auc_headers_interface = 0 )THEN
1875: x_error_code := 'VALIDATE_HDR:INVALID_INTERFACE_ID';

Line 1883: FROM pon_auc_headers_interface

1879:
1880: -- Validate that the process_status for the record is null
1881: /**
1882: SELECT process_status INTO v_process_status
1883: FROM pon_auc_headers_interface
1884: WHERE interface_auction_header_id = p_interface_id;
1885:
1886: IF (v_process_status IS NOT NULL) THEN
1887: x_error_code := 'VALIDATE_HDR:INVALIDATE_PROCESS_STATUS';

Line 2322: DELETE FROM pon_auc_headers_interface

2318:
2319: -- Delete records from header table
2320: v_debug_status := 'DELETE_HEADER';
2321:
2322: DELETE FROM pon_auc_headers_interface
2323: WHERE interface_auction_header_id = p_interface_id;
2324:
2325: -- Delete records from item table
2326: v_debug_status := 'DELETE_ITEM';

Line 2704: FROM pon_auc_headers_interface

2700: end if;
2701:
2702: -- Read data into header record for convenience
2703: SELECT * INTO g_header_rec
2704: FROM pon_auc_headers_interface
2705: WHERE interface_auction_header_id = p_interface_id;
2706:
2707: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2708: fnd_log.string(fnd_log.level_statement,