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.AP_VENDOR_PUB_PKG dependencies on FND_GLOBAL

Line 3468: l_user_id number := FND_GLOBAL.USER_ID;

3464: l_use_bank_charge_flag VARCHAR2(255);
3465: l_bank_charge_bearer VARCHAR2(255);
3466: l_hold_unmatched_invoices_flag VARCHAR2(1);
3467:
3468: l_user_id number := FND_GLOBAL.USER_ID;
3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3471: l_program_id number := FND_GLOBAL.conc_program_id;
3472: l_request_id number := FND_GLOBAL.conc_request_id;

Line 3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

3465: l_bank_charge_bearer VARCHAR2(255);
3466: l_hold_unmatched_invoices_flag VARCHAR2(1);
3467:
3468: l_user_id number := FND_GLOBAL.USER_ID;
3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3471: l_program_id number := FND_GLOBAL.conc_program_id;
3472: l_request_id number := FND_GLOBAL.conc_request_id;
3473: l_val_return_status VARCHAR2(50);

Line 3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;

3466: l_hold_unmatched_invoices_flag VARCHAR2(1);
3467:
3468: l_user_id number := FND_GLOBAL.USER_ID;
3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3471: l_program_id number := FND_GLOBAL.conc_program_id;
3472: l_request_id number := FND_GLOBAL.conc_request_id;
3473: l_val_return_status VARCHAR2(50);
3474: l_val_msg_count NUMBER;

Line 3471: l_program_id number := FND_GLOBAL.conc_program_id;

3467:
3468: l_user_id number := FND_GLOBAL.USER_ID;
3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3471: l_program_id number := FND_GLOBAL.conc_program_id;
3472: l_request_id number := FND_GLOBAL.conc_request_id;
3473: l_val_return_status VARCHAR2(50);
3474: l_val_msg_count NUMBER;
3475: l_val_msg_data VARCHAR2(1000);

Line 3472: l_request_id number := FND_GLOBAL.conc_request_id;

3468: l_user_id number := FND_GLOBAL.USER_ID;
3469: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3470: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3471: l_program_id number := FND_GLOBAL.conc_program_id;
3472: l_request_id number := FND_GLOBAL.conc_request_id;
3473: l_val_return_status VARCHAR2(50);
3474: l_val_msg_count NUMBER;
3475: l_val_msg_data VARCHAR2(1000);
3476: l_creation_date DATE;

Line 3588: l_last_update_login := fnd_global.login_id;

3584: --in the initialization procedure will no longer be defaulted at
3585: --the supplier level because system parameters are org specific
3586: l_vendor_rec.summary_flag := nvl(l_vendor_rec.summary_flag, 'N');
3587: l_vendor_rec.enabled_flag := nvl(l_vendor_rec.enabled_flag, 'Y');
3588: l_last_update_login := fnd_global.login_id;
3589: l_creation_date := sysdate;
3590: l_created_by := fnd_global.user_id;
3591: l_vendor_rec.one_time_flag := nvl(l_vendor_rec.one_time_flag,'N');
3592:

Line 3590: l_created_by := fnd_global.user_id;

3586: l_vendor_rec.summary_flag := nvl(l_vendor_rec.summary_flag, 'N');
3587: l_vendor_rec.enabled_flag := nvl(l_vendor_rec.enabled_flag, 'Y');
3588: l_last_update_login := fnd_global.login_id;
3589: l_creation_date := sysdate;
3590: l_created_by := fnd_global.user_id;
3591: l_vendor_rec.one_time_flag := nvl(l_vendor_rec.one_time_flag,'N');
3592:
3593: -- Bug 6085640 - Terms ID should not be set to default if Terms Name
3594: -- has been given.

Line 4121: l_user_id number := FND_GLOBAL.USER_ID;

4117:
4118: l_def_org_id NUMBER;
4119: l_org_context VARCHAR2(1);
4120:
4121: l_user_id number := FND_GLOBAL.USER_ID;
4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;
4124: l_program_id number := FND_GLOBAL.conc_program_id;
4125: l_request_id number := FND_GLOBAL.conc_request_id;

Line 4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

4118: l_def_org_id NUMBER;
4119: l_org_context VARCHAR2(1);
4120:
4121: l_user_id number := FND_GLOBAL.USER_ID;
4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;
4124: l_program_id number := FND_GLOBAL.conc_program_id;
4125: l_request_id number := FND_GLOBAL.conc_request_id;
4126:

Line 4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;

4119: l_org_context VARCHAR2(1);
4120:
4121: l_user_id number := FND_GLOBAL.USER_ID;
4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;
4124: l_program_id number := FND_GLOBAL.conc_program_id;
4125: l_request_id number := FND_GLOBAL.conc_request_id;
4126:
4127: l_vendor_rec r_vendor_rec_type;

Line 4124: l_program_id number := FND_GLOBAL.conc_program_id;

4120:
4121: l_user_id number := FND_GLOBAL.USER_ID;
4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;
4124: l_program_id number := FND_GLOBAL.conc_program_id;
4125: l_request_id number := FND_GLOBAL.conc_request_id;
4126:
4127: l_vendor_rec r_vendor_rec_type;
4128: l_val_return_status VARCHAR2(50);

Line 4125: l_request_id number := FND_GLOBAL.conc_request_id;

4121: l_user_id number := FND_GLOBAL.USER_ID;
4122: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
4123: l_program_application_id number := FND_GLOBAL.prog_appl_id;
4124: l_program_id number := FND_GLOBAL.conc_program_id;
4125: l_request_id number := FND_GLOBAL.conc_request_id;
4126:
4127: l_vendor_rec r_vendor_rec_type;
4128: l_val_return_status VARCHAR2(50);
4129: l_val_msg_count NUMBER;

Line 7782: l_user_id number := FND_GLOBAL.USER_ID;

7778: l_accts_pay_ccid_def VARCHAR2(255);
7779: l_prepay_ccid_def VARCHAR2(255);
7780: l_future_pay_ccid_def VARCHAR2(255);
7781:
7782: l_user_id number := FND_GLOBAL.USER_ID;
7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7785: l_program_id number := FND_GLOBAL.conc_program_id;
7786: l_request_id number := FND_GLOBAL.conc_request_id;

Line 7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

7779: l_prepay_ccid_def VARCHAR2(255);
7780: l_future_pay_ccid_def VARCHAR2(255);
7781:
7782: l_user_id number := FND_GLOBAL.USER_ID;
7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7785: l_program_id number := FND_GLOBAL.conc_program_id;
7786: l_request_id number := FND_GLOBAL.conc_request_id;
7787:

Line 7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;

7780: l_future_pay_ccid_def VARCHAR2(255);
7781:
7782: l_user_id number := FND_GLOBAL.USER_ID;
7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7785: l_program_id number := FND_GLOBAL.conc_program_id;
7786: l_request_id number := FND_GLOBAL.conc_request_id;
7787:
7788: l_val_return_status VARCHAR2(50);

Line 7785: l_program_id number := FND_GLOBAL.conc_program_id;

7781:
7782: l_user_id number := FND_GLOBAL.USER_ID;
7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7785: l_program_id number := FND_GLOBAL.conc_program_id;
7786: l_request_id number := FND_GLOBAL.conc_request_id;
7787:
7788: l_val_return_status VARCHAR2(50);
7789: l_val_msg_count NUMBER;

Line 7786: l_request_id number := FND_GLOBAL.conc_request_id;

7782: l_user_id number := FND_GLOBAL.USER_ID;
7783: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7784: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7785: l_program_id number := FND_GLOBAL.conc_program_id;
7786: l_request_id number := FND_GLOBAL.conc_request_id;
7787:
7788: l_val_return_status VARCHAR2(50);
7789: l_val_msg_count NUMBER;
7790: l_val_msg_data VARCHAR2(2000);

Line 8259: l_last_updated_by := fnd_global.user_id;

8255: ap_product_setup aps -- Bug 8200984
8256: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8257: AND asp.org_id=l_def_org_id;
8258:
8259: l_last_updated_by := fnd_global.user_id;
8260: l_last_update_login := fnd_global.login_id;
8261: l_created_by := fnd_global.user_id;
8262:
8263: /* Start of bug8892266 */

Line 8260: l_last_update_login := fnd_global.login_id;

8256: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8257: AND asp.org_id=l_def_org_id;
8258:
8259: l_last_updated_by := fnd_global.user_id;
8260: l_last_update_login := fnd_global.login_id;
8261: l_created_by := fnd_global.user_id;
8262:
8263: /* Start of bug8892266 */
8264: SELECT NVL(asp.invoice_currency_code, pv.invoice_currency_code) invoice_currency_code,

Line 8261: l_created_by := fnd_global.user_id;

8257: AND asp.org_id=l_def_org_id;
8258:
8259: l_last_updated_by := fnd_global.user_id;
8260: l_last_update_login := fnd_global.login_id;
8261: l_created_by := fnd_global.user_id;
8262:
8263: /* Start of bug8892266 */
8264: SELECT NVL(asp.invoice_currency_code, pv.invoice_currency_code) invoice_currency_code,
8265: NVL(asp.payment_currency_code, pv.payment_currency_code) payment_currency_code,

Line 9209: l_user_id number := FND_GLOBAL.USER_ID;

9205: l_api_version CONSTANT NUMBER := 1.0;
9206:
9207: l_def_org_id NUMBER;
9208:
9209: l_user_id number := FND_GLOBAL.USER_ID;
9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;
9212: l_program_id number := FND_GLOBAL.conc_program_id;
9213: l_request_id number := FND_GLOBAL.conc_request_id;

Line 9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

9206:
9207: l_def_org_id NUMBER;
9208:
9209: l_user_id number := FND_GLOBAL.USER_ID;
9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;
9212: l_program_id number := FND_GLOBAL.conc_program_id;
9213: l_request_id number := FND_GLOBAL.conc_request_id;
9214: l_vendor_site_rec r_vendor_site_rec_type;

Line 9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;

9207: l_def_org_id NUMBER;
9208:
9209: l_user_id number := FND_GLOBAL.USER_ID;
9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;
9212: l_program_id number := FND_GLOBAL.conc_program_id;
9213: l_request_id number := FND_GLOBAL.conc_request_id;
9214: l_vendor_site_rec r_vendor_site_rec_type;
9215: l_org_context VARCHAR2(1);

Line 9212: l_program_id number := FND_GLOBAL.conc_program_id;

9208:
9209: l_user_id number := FND_GLOBAL.USER_ID;
9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;
9212: l_program_id number := FND_GLOBAL.conc_program_id;
9213: l_request_id number := FND_GLOBAL.conc_request_id;
9214: l_vendor_site_rec r_vendor_site_rec_type;
9215: l_org_context VARCHAR2(1);
9216: l_val_return_status VARCHAR2(50);

Line 9213: l_request_id number := FND_GLOBAL.conc_request_id;

9209: l_user_id number := FND_GLOBAL.USER_ID;
9210: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
9211: l_program_application_id number := FND_GLOBAL.prog_appl_id;
9212: l_program_id number := FND_GLOBAL.conc_program_id;
9213: l_request_id number := FND_GLOBAL.conc_request_id;
9214: l_vendor_site_rec r_vendor_site_rec_type;
9215: l_org_context VARCHAR2(1);
9216: l_val_return_status VARCHAR2(50);
9217: l_val_msg_count NUMBER;

Line 9941: l_program_application_id number := FND_GLOBAL.prog_appl_id;--Bug 7476500

9937: IS
9938: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Vendor_Site';
9939: l_api_version CONSTANT NUMBER := 1.0;
9940: l_org_context VARCHAR2(1);--Bug 7476500
9941: l_program_application_id number := FND_GLOBAL.prog_appl_id;--Bug 7476500
9942: l_def_org_id NUMBER;
9943: l_debug_info VARCHAR2(2000);
9944: x_valid BOOLEAN;
9945: l_sob NUMBER;

Line 13831: l_user_id number := FND_GLOBAL.USER_ID;

13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;
13834: l_program_id number := FND_GLOBAL.conc_program_id;
13835: l_request_id number := FND_GLOBAL.conc_request_id;

Line 13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;
13834: l_program_id number := FND_GLOBAL.conc_program_id;
13835: l_request_id number := FND_GLOBAL.conc_request_id;
13836:

Line 13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;

13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;
13834: l_program_id number := FND_GLOBAL.conc_program_id;
13835: l_request_id number := FND_GLOBAL.conc_request_id;
13836:
13837: l_val_return_status VARCHAR2(50);

Line 13834: l_program_id number := FND_GLOBAL.conc_program_id;

13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;
13834: l_program_id number := FND_GLOBAL.conc_program_id;
13835: l_request_id number := FND_GLOBAL.conc_request_id;
13836:
13837: l_val_return_status VARCHAR2(50);
13838: l_val_msg_count NUMBER;

Line 13835: l_request_id number := FND_GLOBAL.conc_request_id;

13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
13833: l_program_application_id number := FND_GLOBAL.prog_appl_id;
13834: l_program_id number := FND_GLOBAL.conc_program_id;
13835: l_request_id number := FND_GLOBAL.conc_request_id;
13836:
13837: l_val_return_status VARCHAR2(50);
13838: l_val_msg_count NUMBER;
13839: l_val_msg_data VARCHAR2(1000);

Line 14760: nvl(fnd_global.user_id,-1),

14756: l_vendor_contact_rec.org_party_site_id,
14757: --l_vendor_contact_rec.vendor_site_id, Bug 7013954 Vendor Site info no longer used
14758: l_vendor_contact_rec.vendor_contact_id,
14759: SYSDATE,
14760: nvl(fnd_global.user_id,-1),
14761: SYSDATE,
14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),

Line 14762: nvl(fnd_global.user_id,-1),

14758: l_vendor_contact_rec.vendor_contact_id,
14759: SYSDATE,
14760: nvl(fnd_global.user_id,-1),
14761: SYSDATE,
14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),
14765: nvl(FND_GLOBAL.prog_appl_id,-1),
14766: nvl(FND_GLOBAL.conc_program_id,-1),

Line 14763: nvl(fnd_global.login_id,-1),

14759: SYSDATE,
14760: nvl(fnd_global.user_id,-1),
14761: SYSDATE,
14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),
14765: nvl(FND_GLOBAL.prog_appl_id,-1),
14766: nvl(FND_GLOBAL.conc_program_id,-1),
14767: sysdate,

Line 14764: nvl(FND_GLOBAL.conc_request_id,-1),

14760: nvl(fnd_global.user_id,-1),
14761: SYSDATE,
14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),
14765: nvl(FND_GLOBAL.prog_appl_id,-1),
14766: nvl(FND_GLOBAL.conc_program_id,-1),
14767: sysdate,
14768: l_vendor_contact_rec.inactive_date, --Bug 4994974

Line 14765: nvl(FND_GLOBAL.prog_appl_id,-1),

14761: SYSDATE,
14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),
14765: nvl(FND_GLOBAL.prog_appl_id,-1),
14766: nvl(FND_GLOBAL.conc_program_id,-1),
14767: sysdate,
14768: l_vendor_contact_rec.inactive_date, --Bug 4994974
14769: l_vendor_contact_rec.attribute_category, --bug 6745669 -- added dff columns

Line 14766: nvl(FND_GLOBAL.conc_program_id,-1),

14762: nvl(fnd_global.user_id,-1),
14763: nvl(fnd_global.login_id,-1),
14764: nvl(FND_GLOBAL.conc_request_id,-1),
14765: nvl(FND_GLOBAL.prog_appl_id,-1),
14766: nvl(FND_GLOBAL.conc_program_id,-1),
14767: sysdate,
14768: l_vendor_contact_rec.inactive_date, --Bug 4994974
14769: l_vendor_contact_rec.attribute_category, --bug 6745669 -- added dff columns
14770: l_vendor_contact_rec.attribute1,

Line 15732: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

15728:
15729: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendors';
15730: l_api_version CONSTANT NUMBER := 1.0;
15731:
15732: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
15733: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
15734: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
15735:
15736: l_return_status VARCHAR2(2000);

Line 15733: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

15729: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendors';
15730: l_api_version CONSTANT NUMBER := 1.0;
15731:
15732: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
15733: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
15734: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
15735:
15736: l_return_status VARCHAR2(2000);
15737: l_msg_count NUMBER;

Line 15734: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

15730: l_api_version CONSTANT NUMBER := 1.0;
15731:
15732: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
15733: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
15734: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
15735:
15736: l_return_status VARCHAR2(2000);
15737: l_msg_count NUMBER;
15738: l_msg_data VARCHAR2(2000);

Line 15802: g_user_id := FND_GLOBAL.USER_ID;

15798: END IF;
15799:
15800: FND_MSG_PUB.initialize;
15801:
15802: g_user_id := FND_GLOBAL.USER_ID;
15803: g_login_id := FND_GLOBAL.LOGIN_ID;
15804: g_source := p_source;
15805: -- Initialize API return status to success
15806: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 15803: g_login_id := FND_GLOBAL.LOGIN_ID;

15799:
15800: FND_MSG_PUB.initialize;
15801:
15802: g_user_id := FND_GLOBAL.USER_ID;
15803: g_login_id := FND_GLOBAL.LOGIN_ID;
15804: g_source := p_source;
15805: -- Initialize API return status to success
15806: x_return_status := FND_API.G_RET_STS_SUCCESS;
15807:

Line 16338: IF (FND_GLOBAL.conc_request_id = -1) THEN

16334: FOR i IN 1..l_msg_count
16335: LOOP
16336: l_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
16337:
16338: IF (FND_GLOBAL.conc_request_id = -1) THEN
16339: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
16340: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
16341: l_api_name,'Parameters: '
16342: ||' Vendor_Interface_Id: '||vendor_rec.vendor_interface_id

Line 16353: IF (FND_GLOBAL.conc_request_id = -1) THEN

16349: END LOOP;
16350:
16351: ELSIF (l_msg_data is not null) THEN
16352:
16353: IF (FND_GLOBAL.conc_request_id = -1) THEN
16354: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
16355: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
16356: l_api_name,'Parameters: '
16357: ||' Vendor_Interface_Id: '||vendor_rec.vendor_interface_id

Line 16428: IF (FND_GLOBAL.conc_request_id = -1) THEN

16424: FOR i IN 1..l_msg_count
16425: LOOP
16426: l_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
16427:
16428: IF (FND_GLOBAL.conc_request_id = -1) THEN
16429: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
16430: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
16431: l_api_name,'Parameters: '
16432: ||' Vendor_Interface_Id: '||vendor_rec.vendor_interface_id

Line 16443: IF (FND_GLOBAL.conc_request_id = -1) THEN

16439: END LOOP;
16440:
16441: ELSIF (l_msg_data is not null) THEN
16442:
16443: IF (FND_GLOBAL.conc_request_id = -1) THEN
16444: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
16445: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
16446: l_api_name,'Parameters: '
16447: ||' Vendor_Interface_Id: '||vendor_rec.vendor_interface_id

Line 16593: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

16589:
16590: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Sites';
16591: l_api_version CONSTANT NUMBER := 1.0;
16592:
16593: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
16594: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
16595: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
16596:
16597: l_return_status VARCHAR2(2000);

Line 16594: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

16590: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Sites';
16591: l_api_version CONSTANT NUMBER := 1.0;
16592:
16593: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
16594: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
16595: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
16596:
16597: l_return_status VARCHAR2(2000);
16598: l_msg_count NUMBER;

Line 16595: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

16591: l_api_version CONSTANT NUMBER := 1.0;
16592:
16593: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
16594: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
16595: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
16596:
16597: l_return_status VARCHAR2(2000);
16598: l_msg_count NUMBER;
16599: l_msg_data VARCHAR2(2000);

Line 16663: g_user_id := FND_GLOBAL.USER_ID;

16659: END IF;
16660:
16661: FND_MSG_PUB.initialize;
16662:
16663: g_user_id := FND_GLOBAL.USER_ID;
16664: g_login_id := FND_GLOBAL.LOGIN_ID;
16665: g_source := p_source;
16666: -- Initialize API return status to success
16667: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 16664: g_login_id := FND_GLOBAL.LOGIN_ID;

16660:
16661: FND_MSG_PUB.initialize;
16662:
16663: g_user_id := FND_GLOBAL.USER_ID;
16664: g_login_id := FND_GLOBAL.LOGIN_ID;
16665: g_source := p_source;
16666: -- Initialize API return status to success
16667: x_return_status := FND_API.G_RET_STS_SUCCESS;
16668:

Line 17236: IF (FND_GLOBAL.conc_request_id = -1) THEN

17232: FOR i IN 1..l_msg_count
17233: LOOP
17234: l_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
17235:
17236: IF (FND_GLOBAL.conc_request_id = -1) THEN
17237: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17238: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17239: l_api_name,'Parameters: '
17240: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17251: IF (FND_GLOBAL.conc_request_id = -1) THEN

17247: END LOOP;
17248:
17249: ELSIF (l_msg_data is not null) THEN
17250:
17251: IF (FND_GLOBAL.conc_request_id = -1) THEN
17252: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17253: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17254: l_api_name,'Parameters: '
17255: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17302: IF (FND_GLOBAL.conc_request_id = -1) THEN

17298: FOR i IN 1..l_msg_count
17299: LOOP
17300: l_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
17301:
17302: IF (FND_GLOBAL.conc_request_id = -1) THEN
17303: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17304: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17305: l_api_name,'Parameters: '
17306: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17317: IF (FND_GLOBAL.conc_request_id = -1) THEN

17313: END LOOP;
17314:
17315: ELSIF (l_msg_data is not null) THEN
17316:
17317: IF (FND_GLOBAL.conc_request_id = -1) THEN
17318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17319: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17320: l_api_name,'Parameters: '
17321: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17369: IF (FND_GLOBAL.conc_request_id = -1) THEN

17365: FOR i IN 1..l_msg_count
17366: LOOP
17367: l_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
17368:
17369: IF (FND_GLOBAL.conc_request_id = -1) THEN
17370: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17371: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17372: l_api_name,'Parameters: '
17373: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17384: IF (FND_GLOBAL.conc_request_id = -1) THEN

17380: END LOOP;
17381:
17382: ELSIF (l_msg_data is not null) THEN
17383:
17384: IF (FND_GLOBAL.conc_request_id = -1) THEN
17385: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17386: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
17387: l_api_name,'Parameters: '
17388: ||' Vendor_Site_Interface_Id: '||site_rec.vendor_site_interface_id

Line 17536: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

17532:
17533: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Contacts';
17534: l_api_version CONSTANT NUMBER := 1.0;
17535:
17536: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
17537: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
17538: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
17539:
17540: l_return_status VARCHAR2(2000);

Line 17537: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

17533: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Contacts';
17534: l_api_version CONSTANT NUMBER := 1.0;
17535:
17536: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
17537: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
17538: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
17539:
17540: l_return_status VARCHAR2(2000);
17541: l_msg_count NUMBER;

Line 17538: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

17534: l_api_version CONSTANT NUMBER := 1.0;
17535:
17536: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
17537: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
17538: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
17539:
17540: l_return_status VARCHAR2(2000);
17541: l_msg_count NUMBER;
17542: l_msg_data VARCHAR2(2000);

Line 17580: g_user_id := FND_GLOBAL.USER_ID;

17576: END IF;
17577:
17578: FND_MSG_PUB.initialize;
17579:
17580: g_user_id := FND_GLOBAL.USER_ID;
17581: g_login_id := FND_GLOBAL.LOGIN_ID;
17582: g_source := p_source;
17583: -- Initialize API return status to success
17584: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 17581: g_login_id := FND_GLOBAL.LOGIN_ID;

17577:
17578: FND_MSG_PUB.initialize;
17579:
17580: g_user_id := FND_GLOBAL.USER_ID;
17581: g_login_id := FND_GLOBAL.LOGIN_ID;
17582: g_source := p_source;
17583: -- Initialize API return status to success
17584: x_return_status := FND_API.G_RET_STS_SUCCESS;
17585: