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_OPEN_INTERFACE_PVT dependencies on FND_GLOBAL

Line 518: fnd_global.user_id ,

514: l_sequence_number ,
515: c_interface_section_rec.GROUP_NAME ,
516: PON_AUCTION_SECTIONS_S.NEXTVAL ,
517: SYSDATE ,
518: fnd_global.user_id ,
519: SYSDATE ,
520: fnd_global.user_id
521: );
522: END IF;

Line 520: fnd_global.user_id

516: PON_AUCTION_SECTIONS_S.NEXTVAL ,
517: SYSDATE ,
518: fnd_global.user_id ,
519: SYSDATE ,
520: fnd_global.user_id
521: );
522: END IF;
523: END IF;
524: END;

Line 725: fnd_global.user_id ,

721: 'HEADER' ,
722: l_ATTR_GROUP_SEQ_NUMBER ,
723: l_ATTR_DISP_SEQ_NUMBER ,
724: SYSDATE ,
725: fnd_global.user_id ,
726: SYSDATE ,
727: fnd_global.user_id ,
728: SYSDATE ,
729: l_LAST_AMENDMENT_UPDATE ,

Line 727: fnd_global.user_id ,

723: l_ATTR_DISP_SEQ_NUMBER ,
724: SYSDATE ,
725: fnd_global.user_id ,
726: SYSDATE ,
727: fnd_global.user_id ,
728: SYSDATE ,
729: l_LAST_AMENDMENT_UPDATE ,
730: c_interface_attr_rec.KNOCKOUT_SCORE
731: );

Line 1353: fnd_global.user_id, -- Created_by

1349: NVL(l_approver_flag,'N'), -- Approver_flag
1350: task_name, -- Task Name
1351: target_date, -- Target_date
1352: SYSDATE, -- Creation_date
1353: fnd_global.user_id, -- Created_by
1354: SYSDATE, -- last_update_date
1355: fnd_global.user_id); -- last_updated_by
1356: END IF;
1357: -- Getting the manager and manager info of the creator of the solicitation

Line 1355: fnd_global.user_id); -- last_updated_by

1351: target_date, -- Target_date
1352: SYSDATE, -- Creation_date
1353: fnd_global.user_id, -- Created_by
1354: SYSDATE, -- last_update_date
1355: fnd_global.user_id); -- last_updated_by
1356: END IF;
1357: -- Getting the manager and manager info of the creator of the solicitation
1358: BEGIN
1359: SELECT DISTINCT PER.FULL_NAME ,

Line 1401: fnd_global.user_id, -- Created_by

1397: NVL(manager_approver_flag,'Y'), -- Approver_flag
1398: task_name, -- Task Name
1399: target_date, -- Target_date
1400: SYSDATE, -- Creation_date
1401: fnd_global.user_id, -- Created_by
1402: SYSDATE, -- last_update_date
1403: fnd_global.user_id); -- last_updated_by
1404:
1405: EXCEPTION

Line 1403: fnd_global.user_id); -- last_updated_by

1399: target_date, -- Target_date
1400: SYSDATE, -- Creation_date
1401: fnd_global.user_id, -- Created_by
1402: SYSDATE, -- last_update_date
1403: fnd_global.user_id); -- last_updated_by
1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: -- need to raise the sql exception if any encountered

Line 1466: fnd_global.user_id, -- Created_by

1462: NVL(approver_flag,'N'), -- Approver_flag
1463: task_name, -- Task Name
1464: target_date, -- Target_date
1465: SYSDATE, -- Creation_date
1466: fnd_global.user_id, -- Created_by
1467: SYSDATE, -- last_update_date
1468: fnd_global.user_id); -- last_updated_by
1469: END IF;
1470: END IF;

Line 1468: fnd_global.user_id); -- last_updated_by

1464: target_date, -- Target_date
1465: SYSDATE, -- Creation_date
1466: fnd_global.user_id, -- Created_by
1467: SYSDATE, -- last_update_date
1468: fnd_global.user_id); -- last_updated_by
1469: END IF;
1470: END IF;
1471:
1472: EXCEPTION

Line 1666: l_CREATED_BY :=FND_GLOBAL.USER_ID;

1662: l_TRADING_PARTNER_CONTACT_ID :=c_invitee_supplier_rec.TRADING_PARTNER_CONTACT_ID;
1663: l_ADDITIONAL_CONTACT_EMAIL :=c_invitee_supplier_rec.ADDITIONAL_CONTACT_EMAIL;
1664: l_ACTION :=c_invitee_supplier_rec.ACTION;
1665: l_CREATION_DATE :=SYSDATE;
1666: l_CREATED_BY :=FND_GLOBAL.USER_ID;
1667: l_LAST_UPDATE_DATE :=SYSDATE;
1668: l_LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;
1669: /*** If the action is insert ***/
1670: IF (NVL(L_ACTION,'INSERT')='INSERT') THEN

Line 1668: l_LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;

1664: l_ACTION :=c_invitee_supplier_rec.ACTION;
1665: l_CREATION_DATE :=SYSDATE;
1666: l_CREATED_BY :=FND_GLOBAL.USER_ID;
1667: l_LAST_UPDATE_DATE :=SYSDATE;
1668: l_LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;
1669: /*** If the action is insert ***/
1670: IF (NVL(L_ACTION,'INSERT')='INSERT') THEN
1671: -- If the vendor_name and vendor_id is not null
1672: IF (L_VENDOR_NAME IS NOT NULL) THEN

Line 1804: l_cp_user_id := fnd_global.user_id;

1800: l_cp_user_id NUMBER;
1801: l_cp_login_id NUMBER;
1802:
1803: BEGIN
1804: l_cp_user_id := fnd_global.user_id;
1805: l_cp_login_id := fnd_global.login_id;
1806:
1807: INSERT ALL
1808: WHEN (sel_vendor_name IS NULL AND sel_vendor_id IS NULL )

Line 1805: l_cp_login_id := fnd_global.login_id;

1801: l_cp_login_id NUMBER;
1802:
1803: BEGIN
1804: l_cp_user_id := fnd_global.user_id;
1805: l_cp_login_id := fnd_global.login_id;
1806:
1807: INSERT ALL
1808: WHEN (sel_vendor_name IS NULL AND sel_vendor_id IS NULL )
1809: THEN INTO PON_INTERFACE_ERRORS

Line 2108: fnd_global.user_id,

2104:
2105: PON_VALIDATE_ITEM_PRICES_INT.VALIDATE('ITEMUPLOAD',
2106: p_batch_id,
2107: p_doctype_id,
2108: fnd_global.user_id,
2109: p_trading_partner_id,
2110: p_trading_partner_contact_id,
2111: p_curr_lang,
2112: p_contract_type,

Line 2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;

2282: l_price_break_response ,
2283: l_price_tiers_indicator
2284: FROM pon_auction_headers_all
2285: WHERE auction_header_id = p_auction_header_id;
2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;
2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE
2289: INTO g_login_id,
2290: g_curr_lang

Line 2287: SELECT fnd_global.login_id,

2283: l_price_tiers_indicator
2284: FROM pon_auction_headers_all
2285: WHERE auction_header_id = p_auction_header_id;
2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;
2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE
2289: INTO g_login_id,
2290: g_curr_lang
2291: FROM dual;

Line 2288: fnd_global.CURRENT_LANGUAGE

2284: FROM pon_auction_headers_all
2285: WHERE auction_header_id = p_auction_header_id;
2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;
2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE
2289: INTO g_login_id,
2290: g_curr_lang
2291: FROM dual;
2292:

Line 2293: g_user_id := fnd_global.user_id;

2289: INTO g_login_id,
2290: g_curr_lang
2291: FROM dual;
2292:
2293: g_user_id := fnd_global.user_id;
2294: /*select fnd_currency.GET_INFO(l_currency_code,l_precision,l_ext_precision,l_minAcctUnit)
2295: INTO l_price_precision FROM dual;*/
2296: fnd_currency.GET_INFO(l_currency_code,l_precision,l_ext_precision,l_minAcctUnit);
2297: print_log('create_lines_with_children: before calling line_level_validation');

Line 2728: fnd_global.USER_id ,

2724: ppbi.effective_start_date ,
2725: ppbi.effective_end_date ,
2726: ppbi.org_id ,
2727: sysdate ,
2728: fnd_global.USER_id ,
2729: sysdate ,
2730: fnd_global.USER_id ,
2731: fnd_global.login_id ,
2732: Nvl(ppbi.HAS_PRICE_DIFFERENTIALS_FLAG,'N'),

Line 2730: fnd_global.USER_id ,

2726: ppbi.org_id ,
2727: sysdate ,
2728: fnd_global.USER_id ,
2729: sysdate ,
2730: fnd_global.USER_id ,
2731: fnd_global.login_id ,
2732: Nvl(ppbi.HAS_PRICE_DIFFERENTIALS_FLAG,'N'),
2733: ppbi.DIFFERENTIAL_RESPONSE_TYPE ,
2734: ppbi.MAX_QUANTITY

Line 2731: fnd_global.login_id ,

2727: sysdate ,
2728: fnd_global.USER_id ,
2729: sysdate ,
2730: fnd_global.USER_id ,
2731: fnd_global.login_id ,
2732: Nvl(ppbi.HAS_PRICE_DIFFERENTIALS_FLAG,'N'),
2733: ppbi.DIFFERENTIAL_RESPONSE_TYPE ,
2734: ppbi.MAX_QUANTITY
2735: FROM pon_auc_price_breaks_interface ppbi,

Line 2765: fnd_global.USER_id ,

2761: pdf_int.SEQUENCE_NUMBER ,
2762: pdf_int.PRICE_TYPE ,
2763: pdf_int.MULTIPLIER ,
2764: sysdate ,
2765: fnd_global.USER_id ,
2766: sysdate ,
2767: fnd_global.USER_id ,
2768: fnd_global.login_id
2769: FROM pon_auc_price_differ_int pdf_int,

Line 2767: fnd_global.USER_id ,

2763: pdf_int.MULTIPLIER ,
2764: sysdate ,
2765: fnd_global.USER_id ,
2766: sysdate ,
2767: fnd_global.USER_id ,
2768: fnd_global.login_id
2769: FROM pon_auc_price_differ_int pdf_int,
2770: pon_auc_price_breaks_interface ppb_int
2771: WHERE pdf_int.batch_id = p_batch_id

Line 2768: fnd_global.login_id

2764: sysdate ,
2765: fnd_global.USER_id ,
2766: sysdate ,
2767: fnd_global.USER_id ,
2768: fnd_global.login_id
2769: FROM pon_auc_price_differ_int pdf_int,
2770: pon_auc_price_breaks_interface ppb_int
2771: WHERE pdf_int.batch_id = p_batch_id
2772: AND NVL(ppb_int.HAS_PRICE_DIFFERENTIALS_FLAG,'N') = 'Y'

Line 4617: Nvl(neg_header_record_data.created_by,fnd_global.user_id), -- CREATED_BY

4613: userenv('LANG'), -- LANGUAGE_CODE
4614: neg_header_record_data.bid_visibility_code, -- BID_VISIBILITY_CODE
4615: 'N', -- ATTACHMENT_FLAG
4616: Nvl(neg_header_record_data.creation_date, SYSDATE), -- CREATION_DATE
4617: Nvl(neg_header_record_data.created_by,fnd_global.user_id), -- CREATED_BY
4618: Nvl(neg_header_record_data.last_update_date,SYSDATE), -- LAST_UPDATE_DATE
4619: Nvl(neg_header_record_data.last_updated_by,fnd_global.user_id), -- LAST_UPDATED_BY
4620: neg_header_record_data.doctype_id, -- DOCTYPE_ID
4621: neg_header_record_data.ORG_ID, -- ORG_ID

Line 4619: Nvl(neg_header_record_data.last_updated_by,fnd_global.user_id), -- LAST_UPDATED_BY

4615: 'N', -- ATTACHMENT_FLAG
4616: Nvl(neg_header_record_data.creation_date, SYSDATE), -- CREATION_DATE
4617: Nvl(neg_header_record_data.created_by,fnd_global.user_id), -- CREATED_BY
4618: Nvl(neg_header_record_data.last_update_date,SYSDATE), -- LAST_UPDATE_DATE
4619: Nvl(neg_header_record_data.last_updated_by,fnd_global.user_id), -- LAST_UPDATED_BY
4620: neg_header_record_data.doctype_id, -- DOCTYPE_ID
4621: neg_header_record_data.ORG_ID, -- ORG_ID
4622: null, -- BUYER_ID
4623: 'N', -- MANUAL_EDIT_FLAG

Line 4957: l_cp_user_id := fnd_global.user_id;

4953:
4954:
4955: BEGIN
4956: print_Log('header_initial_validation begin: p_batch_id ' || p_batch_id);
4957: l_cp_user_id := fnd_global.user_id;
4958: l_cp_login_id := fnd_global.login_id;
4959:
4960: SELECT doctype_id, org_id, style_id, po_style_name, trading_partner_contact_name
4961: INTO l_doctype_id, l_org_id, l_style_id, l_po_style_name, l_tpc_name

Line 4958: l_cp_login_id := fnd_global.login_id;

4954:
4955: BEGIN
4956: print_Log('header_initial_validation begin: p_batch_id ' || p_batch_id);
4957: l_cp_user_id := fnd_global.user_id;
4958: l_cp_login_id := fnd_global.login_id;
4959:
4960: SELECT doctype_id, org_id, style_id, po_style_name, trading_partner_contact_name
4961: INTO l_doctype_id, l_org_id, l_style_id, l_po_style_name, l_tpc_name
4962: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;

Line 5393: l_cp_user_id := fnd_global.user_id;

5389: BEGIN
5390:
5391: print_Log('validate_header begin: p_batch_id ' || p_batch_id || ' p_is_amendment ' || p_is_amendment);
5392:
5393: l_cp_user_id := fnd_global.user_id;
5394: l_cp_login_id := fnd_global.login_id;
5395:
5396: IF( p_is_amendment <> 'Y' ) THEN
5397: -- Call to check if all mandatory columns in pon_auction_headers_interface table are given non-null values

Line 5394: l_cp_login_id := fnd_global.login_id;

5390:
5391: print_Log('validate_header begin: p_batch_id ' || p_batch_id || ' p_is_amendment ' || p_is_amendment);
5392:
5393: l_cp_user_id := fnd_global.user_id;
5394: l_cp_login_id := fnd_global.login_id;
5395:
5396: IF( p_is_amendment <> 'Y' ) THEN
5397: -- Call to check if all mandatory columns in pon_auction_headers_interface table are given non-null values
5398: null_check(

Line 6632: NULL,fnd_global.user_id, fnd_global.login_id);

6628: x_err_msg => l_template_err_msg);
6629: IF ( l_template_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6630: print_log('Error in UDA template id defaulting');
6631: insert_error ('PON_IMPORT_UDA_TEMP_ERR',p_batch_id,'UDA_TEMPLATE_ID',
6632: NULL,fnd_global.user_id, fnd_global.login_id);
6633: RAISE FND_API.G_EXC_ERROR;
6634: END IF;
6635: neg_header_record_data.uda_template_date := SYSDATE ;
6636: END IF;

Line 6960: fnd_global.user_Id,

6956: x_error_code,
6957: x_error_message,
6958: p_auction_header_id,
6959: l_close_bidding_date,
6960: fnd_global.user_Id,
6961: fnd_global.login_id);
6962:
6963:
6964: UPDATE pon_auction_headers_all SET

Line 6961: fnd_global.login_id);

6957: x_error_message,
6958: p_auction_header_id,
6959: l_close_bidding_date,
6960: fnd_global.user_Id,
6961: fnd_global.login_id);
6962:
6963:
6964: UPDATE pon_auction_headers_all SET
6965: OPEN_BIDDING_DATE=neg_header_record_data.open_bidding_date,

Line 7177: NULL,fnd_global.user_id, fnd_global.login_id);

7173: EXCEPTION
7174: WHEN No_Data_Found THEN
7175: x_return_status := FND_API.G_RET_STS_ERROR;
7176: insert_error ('PON_INT_TPC_INV',p_batch_id,'TRADING_PARTNER_CONTACT_NAME',
7177: NULL,fnd_global.user_id, fnd_global.login_id);
7178:
7179: print_Log('trading parter name given is invalid for batch_id ' || p_batch_id );
7180: RAISE FND_API.G_EXC_ERROR;
7181: END;

Line 7274: NULL,fnd_global.user_id, fnd_global.login_id);

7270: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id,'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
7271: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7272: print_log('failure from create_amendment');
7273: insert_error ('PON_INT_UDA_ERR',p_batch_id,'UDA',
7274: NULL,fnd_global.user_id, fnd_global.login_id);
7275: RETURN;
7276: END IF;
7277: print_log('Header UDA information inserted' );
7278: END IF;

Line 7289: NULL,fnd_global.user_id, fnd_global.login_id);

7285:
7286: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7287: print_log('failure from create_neg_team');
7288: insert_error ('PON_INT_COLL_FAIL',p_batch_id,'COLLABORATION_TEAM',
7289: NULL,fnd_global.user_id, fnd_global.login_id);
7290: RAISE FND_API.G_EXC_ERROR;
7291: END IF;
7292:
7293: print_log('Negotiation team members insertion completed');

Line 7303: NULL,fnd_global.user_id, fnd_global.login_id);

7299:
7300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7301: print_log('failure from create_header_attr_inter');
7302: insert_error ('PON_INT_ATT_FAIL',p_batch_id,'HEADER_ATTRIBUTES',
7303: NULL,fnd_global.user_id, fnd_global.login_id);
7304: RAISE FND_API.G_EXC_ERROR;
7305: END IF;
7306:
7307: print_log('Header requirements insertion completed');

Line 7319: NULL,fnd_global.user_id, fnd_global.login_id);

7315: || ' x_return_status ' || x_return_status);
7316: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7317: print_log('failure from create_lines_with_children');
7318: insert_error ('PON_INT_LINE_FAIL',p_batch_id,'LINE',
7319: NULL,fnd_global.user_id, fnd_global.login_id);
7320: RAISE FND_API.G_EXC_ERROR;
7321: END IF;
7322:
7323: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN

Line 7334: NULL,fnd_global.user_id, fnd_global.login_id);

7330: process_uda_attributes(p_batch_id, x_auction_header_id, rec.line_number, l_uda_template_id, 'PON_AUC_PRICES_EXT_ATTRS', x_return_status);
7331: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7332: print_log('failure in Line UDA insertion for line ' || rec.line_number);
7333: insert_error ('PON_INT_LINEUDA_FAIL',p_batch_id,'LINE_UDA',
7334: NULL,fnd_global.user_id, fnd_global.login_id);
7335: RETURN;
7336: END IF;
7337: END LOOP;
7338: print_Log('Line level UDA insertion completed successfully');

Line 7345: NULL,fnd_global.user_id, fnd_global.login_id);

7341:
7342: ELSE
7343: print_log('Amendment can not be created for the auction_header_id given for batch ' || p_batch_id);
7344: insert_error ('PON_INT_AMENDCHECK_FAIL',p_batch_id,'AMENDMENT',
7345: NULL,fnd_global.user_id, fnd_global.login_id);
7346: RAISE FND_API.G_EXC_ERROR;
7347:
7348: END IF;
7349:

Line 7636: fnd_global.user_id,

7632: 'PON_IMPORT_LINE_NUM_ERR',
7633: p_batch_id,
7634: sel_line_id,
7635: 'PON_ITEM_PRICES_INTERFACE',
7636: fnd_global.user_id,
7637: SYSDATE,
7638: fnd_global.user_id,
7639: SYSDATE,
7640: fnd_global.login_id)

Line 7638: fnd_global.user_id,

7634: sel_line_id,
7635: 'PON_ITEM_PRICES_INTERFACE',
7636: fnd_global.user_id,
7637: SYSDATE,
7638: fnd_global.user_id,
7639: SYSDATE,
7640: fnd_global.login_id)
7641: WHEN (sel_line_id < 1 OR
7642: ( sel_line_id = 1 AND sel_group_type IN ('LOT_LINE','GROUP_LINE')))

Line 7640: fnd_global.login_id)

7636: fnd_global.user_id,
7637: SYSDATE,
7638: fnd_global.user_id,
7639: SYSDATE,
7640: fnd_global.login_id)
7641: WHEN (sel_line_id < 1 OR
7642: ( sel_line_id = 1 AND sel_group_type IN ('LOT_LINE','GROUP_LINE')))
7643: THEN INTO PON_INTERFACE_ERRORS
7644: (

Line 7662: fnd_global.user_id,

7658: 'PON_IMPORT_LINE_NUM_ERR',
7659: p_batch_id,
7660: sel_line_id,
7661: 'PON_ITEM_PRICES_INTERFACE',
7662: fnd_global.user_id,
7663: SYSDATE,
7664: fnd_global.user_id,
7665: SYSDATE,
7666: fnd_global.login_id)

Line 7664: fnd_global.user_id,

7660: sel_line_id,
7661: 'PON_ITEM_PRICES_INTERFACE',
7662: fnd_global.user_id,
7663: SYSDATE,
7664: fnd_global.user_id,
7665: SYSDATE,
7666: fnd_global.login_id)
7667: WHEN (sel_line_id > 1
7668: AND EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2

Line 7666: fnd_global.login_id)

7662: fnd_global.user_id,
7663: SYSDATE,
7664: fnd_global.user_id,
7665: SYSDATE,
7666: fnd_global.login_id)
7667: WHEN (sel_line_id > 1
7668: AND EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2
7669: WHERE t2.batch_id = p_batch_id
7670: AND t2.interface_line_id = (sel_line_id - 1)

Line 7698: fnd_global.user_id,

7694: 'PON_IMPORT_LINE_ORDER_ERR',
7695: p_batch_id,
7696: sel_line_id,
7697: 'PON_ITEM_PRICES_INTERFACE',
7698: fnd_global.user_id,
7699: SYSDATE,
7700: fnd_global.user_id,
7701: SYSDATE,
7702: fnd_global.login_id)

Line 7700: fnd_global.user_id,

7696: sel_line_id,
7697: 'PON_ITEM_PRICES_INTERFACE',
7698: fnd_global.user_id,
7699: SYSDATE,
7700: fnd_global.user_id,
7701: SYSDATE,
7702: fnd_global.login_id)
7703: SELECT
7704: interface_line_id sel_line_id,

Line 7702: fnd_global.login_id)

7698: fnd_global.user_id,
7699: SYSDATE,
7700: fnd_global.user_id,
7701: SYSDATE,
7702: fnd_global.login_id)
7703: SELECT
7704: interface_line_id sel_line_id,
7705: group_type sel_group_type
7706: FROM pon_item_prices_interface

Line 7732: fnd_global.user_id,

7728: 'LINES',
7729: 'PON_IMPORT_LINE_NUM_ERR',
7730: p_batch_id,
7731: 'PON_ITEM_PRICES_INTERFACE',
7732: fnd_global.user_id,
7733: SYSDATE,
7734: fnd_global.user_id,
7735: SYSDATE,
7736: fnd_global.login_id);

Line 7734: fnd_global.user_id,

7730: p_batch_id,
7731: 'PON_ITEM_PRICES_INTERFACE',
7732: fnd_global.user_id,
7733: SYSDATE,
7734: fnd_global.user_id,
7735: SYSDATE,
7736: fnd_global.login_id);
7737:
7738: EXCEPTION

Line 7736: fnd_global.login_id);

7732: fnd_global.user_id,
7733: SYSDATE,
7734: fnd_global.user_id,
7735: SYSDATE,
7736: fnd_global.login_id);
7737:
7738: EXCEPTION
7739: WHEN OTHERS THEN
7740: NULL;

Line 7766: fnd_global.user_id,

7762: 'PON_IMPORT_LINE_GRP_ERR',
7763: p_batch_id,
7764: sel_line_id,
7765: 'PON_ITEM_PRICES_INTERFACE',
7766: fnd_global.user_id,
7767: SYSDATE,
7768: fnd_global.user_id,
7769: SYSDATE,
7770: fnd_global.login_id)

Line 7768: fnd_global.user_id,

7764: sel_line_id,
7765: 'PON_ITEM_PRICES_INTERFACE',
7766: fnd_global.user_id,
7767: SYSDATE,
7768: fnd_global.user_id,
7769: SYSDATE,
7770: fnd_global.login_id)
7771: WHEN (sel_info_flag IS NULL )
7772: THEN INTO PON_INTERFACE_ERRORS

Line 7770: fnd_global.login_id)

7766: fnd_global.user_id,
7767: SYSDATE,
7768: fnd_global.user_id,
7769: SYSDATE,
7770: fnd_global.login_id)
7771: WHEN (sel_info_flag IS NULL )
7772: THEN INTO PON_INTERFACE_ERRORS
7773: (
7774: INTERFACE_TYPE ,

Line 7793: fnd_global.user_id,

7789: 'CLM_INFO_FLAG',
7790: p_batch_id,
7791: sel_line_id,
7792: 'PON_ITEM_PRICES_INTERFACE',
7793: fnd_global.user_id,
7794: SYSDATE,
7795: fnd_global.user_id,
7796: SYSDATE,
7797: fnd_global.login_id)

Line 7795: fnd_global.user_id,

7791: sel_line_id,
7792: 'PON_ITEM_PRICES_INTERFACE',
7793: fnd_global.user_id,
7794: SYSDATE,
7795: fnd_global.user_id,
7796: SYSDATE,
7797: fnd_global.login_id)
7798: WHEN (sel_info_flag = 'Y'
7799: AND (sel_price IS NOT NULL

Line 7797: fnd_global.login_id)

7793: fnd_global.user_id,
7794: SYSDATE,
7795: fnd_global.user_id,
7796: SYSDATE,
7797: fnd_global.login_id)
7798: WHEN (sel_info_flag = 'Y'
7799: AND (sel_price IS NOT NULL
7800: OR sel_qty IS NOT NULL
7801: OR sel_category IS NOT NULL

Line 7822: fnd_global.user_id,

7818: 'PON_IMPORT_INFOLINE_ERR',
7819: p_batch_id,
7820: sel_line_id,
7821: 'PON_ITEM_PRICES_INTERFACE',
7822: fnd_global.user_id,
7823: SYSDATE,
7824: fnd_global.user_id,
7825: SYSDATE,
7826: fnd_global.login_id)

Line 7824: fnd_global.user_id,

7820: sel_line_id,
7821: 'PON_ITEM_PRICES_INTERFACE',
7822: fnd_global.user_id,
7823: SYSDATE,
7824: fnd_global.user_id,
7825: SYSDATE,
7826: fnd_global.login_id)
7827:
7828: WHEN (sel_group_Line_id IS NOT NULL

Line 7826: fnd_global.login_id)

7822: fnd_global.user_id,
7823: SYSDATE,
7824: fnd_global.user_id,
7825: SYSDATE,
7826: fnd_global.login_id)
7827:
7828: WHEN (sel_group_Line_id IS NOT NULL
7829: AND (EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2
7830: WHERE t2.interface_line_id = sel_group_line_id

Line 7853: fnd_global.user_id,

7849: 'PON_IMPORT_CLINSLIN_ERR',
7850: p_batch_id,
7851: sel_line_id,
7852: 'PON_ITEM_PRICES_INTERFACE',
7853: fnd_global.user_id,
7854: SYSDATE,
7855: fnd_global.user_id,
7856: SYSDATE,
7857: fnd_global.login_id)

Line 7855: fnd_global.user_id,

7851: sel_line_id,
7852: 'PON_ITEM_PRICES_INTERFACE',
7853: fnd_global.user_id,
7854: SYSDATE,
7855: fnd_global.user_id,
7856: SYSDATE,
7857: fnd_global.login_id)
7858:
7859: SELECT

Line 7857: fnd_global.login_id)

7853: fnd_global.user_id,
7854: SYSDATE,
7855: fnd_global.user_id,
7856: SYSDATE,
7857: fnd_global.login_id)
7858:
7859: SELECT
7860: interface_line_id sel_line_id,
7861: group_type sel_group_type,