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_ATTACHMENTS_INTERFACE

Line 896: 'validating PON_ATTACHMENTS_INTERFACE; calling val_attachments_interface with p_interface_id : ' || p_interface_id);

892:
893: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
894: fnd_log.string(fnd_log.level_statement,
895: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
896: 'validating PON_ATTACHMENTS_INTERFACE; calling val_attachments_interface with p_interface_id : ' || p_interface_id);
897: end if;
898:
899: -- Validate data in the PON_ATTACHMENTS_INTERFACE table
900: val_attachments_interface(p_interface_id,v_error_code, v_error_message);

Line 899: -- Validate data in the PON_ATTACHMENTS_INTERFACE table

895: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
896: 'validating PON_ATTACHMENTS_INTERFACE; calling val_attachments_interface with p_interface_id : ' || p_interface_id);
897: end if;
898:
899: -- Validate data in the PON_ATTACHMENTS_INTERFACE table
900: val_attachments_interface(p_interface_id,v_error_code, v_error_message);
901:
902: IF (v_error_code IS NOT NULL ) THEN
903: -- Error encountered while validating the attachments

Line 916: 'error when validating PON_ATTACHMENTS_INTERFACE; x_error_message : ' || x_error_message);

912:
913: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
914: fnd_log.string(fnd_log.level_statement,
915: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
916: 'error when validating PON_ATTACHMENTS_INTERFACE; x_error_message : ' || x_error_message);
917: end if;
918:
919: RETURN;
920: END IF;

Line 1214: -- FROM pon_attachments_interface

1210: -- UPDATE pon_auction_item_prices_all
1211: -- SET attachment_flag = 'Y'
1212: -- WHERE auction_header_id = x_document_number
1213: -- AND line_number IN (SELECT interface_line_number
1214: -- FROM pon_attachments_interface
1215: -- WHERE interface_auction_header_id = p_interface_id
1216: -- AND interface_line_number IS NOT NULL);
1217:
1218: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 1386: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table

1382: FROM pon_auc_shipments_interface
1383: WHERE interface_auction_header_id = p_interface_id
1384: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity);
1385:
1386: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table
1387: v_debug_status := 'INSERT_LINE_ATTACHMENTS';
1388:
1389: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1390: fnd_log.string(fnd_log.level_statement,

Line 1392: 'Copying over the (Line) attachments from the PON_ATTACHMENTS_INTERFACE table' );

1388:
1389: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1390: fnd_log.string(fnd_log.level_statement,
1391: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1392: 'Copying over the (Line) attachments from the PON_ATTACHMENTS_INTERFACE table' );
1393: end if;
1394:
1395: INSERT INTO fnd_attached_documents
1396: ( attached_document_id,

Line 1429: FROM pon_attachments_interface

1425: NULL, -- pk4_value
1426: NULL, -- pk5_value
1427: 'N', -- automatically_added_flag
1428: NULL -- column1
1429: FROM pon_attachments_interface
1430: WHERE interface_auction_header_id = p_interface_id
1431: AND interface_line_number IS NOT NULL
1432: AND interface_line_number >= l_batch_start
1433: AND interface_line_number <= l_batch_end;

Line 1503: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table

1499: --Do this task only if it is an online call
1500: --
1501: IF (p_is_concurrent_call = 'N') THEN
1502:
1503: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table
1504: v_debug_status := 'INSERT_HEADER_ATTACHMENTS';
1505:
1506: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1507: fnd_log.string(fnd_log.level_statement,

Line 1509: 'Copying over the (header)attachments from the PON_ATTACHMENTS_INTERFACE table' );

1505:
1506: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1507: fnd_log.string(fnd_log.level_statement,
1508: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1509: 'Copying over the (header)attachments from the PON_ATTACHMENTS_INTERFACE table' );
1510: end if;
1511:
1512: INSERT INTO fnd_attached_documents
1513: ( attached_document_id,

Line 1547: FROM pon_attachments_interface

1543: NULL, -- pk4_value
1544: NULL, -- pk5_value
1545: 'N', -- automatically_added_flag
1546: NULL -- column1
1547: FROM pon_attachments_interface
1548: WHERE interface_auction_header_id = p_interface_id
1549: AND interface_line_number IS NULL;
1550:
1551:

Line 2165: COMMENT : validates the data in the pon_attachments_interface table.

2161: p_interface_id IN Interface Header Id
2162: x_error_code OUT NOCOPY errcode if any error generate
2163: x_error_message OUT NOCOPY error message if any error
2164:
2165: COMMENT : validates the data in the pon_attachments_interface table.
2166: The basic validation that is performed is to make sure that every
2167: record in this table corresponds to a valid header or valid line item
2168: in the other interface tables.
2169: ======================================================================*/

Line 2353: DELETE FROM pon_attachments_interface

2349:
2350: -- Delete records from attachments table
2351: v_debug_status := ' DELETE_ATTACHMENTS';
2352:
2353: DELETE FROM pon_attachments_interface
2354: WHERE interface_auction_header_id = p_interface_id;
2355:
2356: x_result := 'SUCCESS';
2357: