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 1145: 'validating PON_ATTACHMENTS_INTERFACE; calling val_attachments_interface with p_interface_id : ' || p_interface_id);

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
1149: val_attachments_interface(p_interface_id,v_error_code, v_error_message);

Line 1148: -- Validate data in the PON_ATTACHMENTS_INTERFACE table

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
1149: val_attachments_interface(p_interface_id,v_error_code, v_error_message);
1150:
1151: IF (v_error_code IS NOT NULL ) THEN
1152: -- Error encountered while validating the attachments

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

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;
1169: END IF;

Line 1494: -- FROM pon_attachments_interface

1490: -- UPDATE pon_auction_item_prices_all
1491: -- SET attachment_flag = 'Y'
1492: -- WHERE auction_header_id = x_document_number
1493: -- AND line_number IN (SELECT interface_line_number
1494: -- FROM pon_attachments_interface
1495: -- WHERE interface_auction_header_id = p_interface_id
1496: -- AND interface_line_number IS NOT NULL);
1497:
1498: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

1806: FROM pon_auc_shipments_interface
1807: WHERE interface_auction_header_id = p_interface_id
1808: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity);
1809:
1810: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table
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,

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

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
1820: ( attached_document_id,

Line 1853: FROM pon_attachments_interface

1849: NULL, -- pk4_value
1850: NULL, -- pk5_value
1851: 'N', -- automatically_added_flag
1852: NULL -- column1
1853: FROM pon_attachments_interface
1854: WHERE interface_auction_header_id = p_interface_id
1855: AND interface_line_number IS NOT NULL
1856: AND interface_line_number >= l_batch_start
1857: AND interface_line_number <= l_batch_end;

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

1984: --Do this task only if it is an online call
1985: --
1986: IF (p_is_concurrent_call = 'N') THEN
1987:
1988: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table
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,

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

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
1998: ( attached_document_id,

Line 2032: FROM pon_attachments_interface

2028: NULL, -- pk4_value
2029: NULL, -- pk5_value
2030: 'N', -- automatically_added_flag
2031: NULL -- column1
2032: FROM pon_attachments_interface
2033: WHERE interface_auction_header_id = p_interface_id
2034: AND interface_line_number IS NULL;
2035:
2036:

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

2646: p_interface_id IN Interface Header Id
2647: x_error_code OUT NOCOPY errcode if any error generate
2648: x_error_message OUT NOCOPY error message if any error
2649:
2650: COMMENT : validates the data in the pon_attachments_interface table.
2651: The basic validation that is performed is to make sure that every
2652: record in this table corresponds to a valid header or valid line item
2653: in the other interface tables.
2654: ======================================================================*/

Line 2838: DELETE FROM pon_attachments_interface

2834:
2835: -- Delete records from attachments table
2836: v_debug_status := ' DELETE_ATTACHMENTS';
2837:
2838: DELETE FROM pon_attachments_interface
2839: WHERE interface_auction_header_id = p_interface_id;
2840:
2841: x_result := 'SUCCESS';
2842: