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.EGO_ITEM_WS_PVT dependencies on EGO_ODI_PUB

Line 1806: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

1802: ,std_bom_explode_flag => explode_std_bom -- Bug 8752314 : CMR Change
1803: );
1804:
1805: if( To_Number(Nvl(x_error_code,0)) <> 0) THEN
1806: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
1807: p_odi_session_id => p_odi_session_id,
1808: p_input_id => p_index ,
1809: p_err_code => 'BOM_EXPLOSION_ERROR',
1810: p_err_message => 'Error: Error Occured while exploding the '||alternate_desg||' structure for the Item ');

Line 2289: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2285: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2286: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2287: WHERE session_id = p_session_id;
2288:
2289: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2290: p_odi_session_id => p_odi_session_id,
2291: p_input_id => p_input_id,
2292: p_err_code => 'EGO_INVALID_INVOCATION_MODE',
2293: p_err_message => 'Invalid Invocation Mode, No valid details of Items to be published are given');

Line 2300: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2296: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2297: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2298: WHERE session_id = p_session_id;
2299:
2300: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2301: p_odi_session_id => p_odi_session_id,
2302: p_input_id => p_input_id,
2303: p_err_code => 'EGO_NO_ORG_DETAILS',
2304: p_err_message => 'Organization details are not provided');

Line 2311: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2307: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2308: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2309: WHERE session_id = p_session_id;
2310:
2311: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2312: p_odi_session_id => p_odi_session_id,
2313: p_input_id => p_input_id,
2314: p_err_code => 'EGO_NO_REV_DETAILS',
2315: p_err_message => 'Revision details are not provided');

Line 2322: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

2318: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2319: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2320: WHERE session_id = p_session_id;
2321:
2322: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2323: p_odi_session_id => p_odi_session_id,
2324: p_input_id => p_input_id,
2325: p_param_name => 'BatchId',
2326: p_param_value => l_batch_id );

Line 2328: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2324: p_input_id => p_input_id,
2325: p_param_name => 'BatchId',
2326: p_param_value => l_batch_id );
2327:
2328: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2329: p_odi_session_id => p_odi_session_id,
2330: p_input_id => p_input_id,
2331: p_err_code => 'EGO_INVALID_BATCH_ID',
2332: p_err_message => 'Invalid Batch Id');

Line 2459: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

2455: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
2456: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2457: WHERE session_id = p_session_id;
2458:
2459: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2460: p_odi_session_id => p_odi_session_id,
2461: p_input_id => p_index,
2462: p_param_name => 'LanguageName',
2463: p_param_value => l_lang_name_tab(i) );

Line 2465: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2461: p_input_id => p_index,
2462: p_param_name => 'LanguageName',
2463: p_param_value => l_lang_name_tab(i) );
2464:
2465: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2466: p_odi_session_id => p_odi_session_id,
2467: p_input_id => p_index,
2468: p_err_code => 'EGO_INVALID_LANGUAGE_NAME',
2469: p_err_message => 'Invalid Language Name');

Line 2486: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

2482: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
2483: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2484: WHERE session_id = p_session_id;
2485:
2486: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2487: p_odi_session_id => p_odi_session_id,
2488: p_input_id => p_index,
2489: p_param_name => 'LanguageCode',
2490: p_param_value => l_lang_code_tab(i) );

Line 2492: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

2488: p_input_id => p_index,
2489: p_param_name => 'LanguageCode',
2490: p_param_value => l_lang_code_tab(i) );
2491:
2492: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2493: p_odi_session_id => p_odi_session_id,
2494: p_input_id => p_index,
2495: p_err_code => 'EGO_INVALID_LANGUAGE_CODE',
2496: p_err_message => 'Invalid Language Code');

Line 3221: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

3217: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3218: WHERE session_id = p_session_id;
3219:
3220: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3221: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
3222: p_odi_session_id => p_odi_session_id,
3223: p_input_id => p_index,
3224: p_param_name => 'AttributeGroupName',
3225: p_param_value => l_uda_attr_name_tab(i) );

Line 3227: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

3223: p_input_id => p_index,
3224: p_param_name => 'AttributeGroupName',
3225: p_param_value => l_uda_attr_name_tab(i) );
3226:
3227: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
3228: p_odi_session_id => p_odi_session_id,
3229: p_input_id => p_index,
3230: p_err_code => 'EGO_INVALID_AG_NAME',
3231: p_err_message => 'Invalid Attribute Group Name');

Line 3252: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

3248: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3249: WHERE session_id = p_session_id;
3250:
3251: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3252: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
3253: p_odi_session_id => p_odi_session_id,
3254: p_input_id => p_index,
3255: p_param_name => 'AttributeGroupId',
3256: p_param_value => l_uda_attr_id_tab(i) );

Line 3258: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

3254: p_input_id => p_index,
3255: p_param_name => 'AttributeGroupId',
3256: p_param_value => l_uda_attr_id_tab(i) );
3257:
3258: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
3259: p_odi_session_id => p_odi_session_id,
3260: p_input_id => p_index,
3261: p_err_code => 'EGO_INVALID_AG_ID',
3262: p_err_message => 'Invalid Attribute Group Id');

Line 3362: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

3358: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3359: WHERE session_id = p_session_id;
3360:
3361: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3362: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
3363: p_odi_session_id => p_odi_session_id,
3364: p_input_id => p_index,
3365: p_param_name => 'AttributeName',
3366: p_param_value => l_ta_attr_name_tab(i) );

Line 3368: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

3364: p_input_id => p_index,
3365: p_param_name => 'AttributeName',
3366: p_param_value => l_ta_attr_name_tab(i) );
3367:
3368: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
3369: p_odi_session_id => p_odi_session_id,
3370: p_input_id => p_index,
3371: p_err_code => 'EGO_INVALID_TA_NAME',
3372: p_err_message => 'Invalid Transaction Attribute Name');

Line 3409: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

3405: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3406: WHERE session_id = p_session_id;
3407:
3408: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3409: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
3410: p_odi_session_id => p_odi_session_id,
3411: p_input_id => p_index,
3412: p_param_name => 'AttributeId',
3413: p_param_value => l_ta_attr_id_tab(i) );

Line 3415: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

3411: p_input_id => p_index,
3412: p_param_name => 'AttributeId',
3413: p_param_value => l_ta_attr_id_tab(i) );
3414:
3415: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
3416: p_odi_session_id => p_odi_session_id,
3417: p_input_id => p_index,
3418: p_err_code => 'EGO_INVALID_TA_ID',
3419: p_err_message => 'Invalid Transaction Attribute Id');

Line 3727: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

3723: p_index => 1);
3724: END IF; --end of (v_is_valid_item)
3725: ELSE
3726: IF (l_inv_id <> -1) THEN
3727: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
3728: p_odi_session_id => p_odi_session_id,
3729: p_input_id => 1,
3730: p_param_name => 'InventoryItemId',
3731: p_param_value => l_inv_id );

Line 4045: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4041: l_segment_17_tab(i) IS NULL AND l_segment_18_tab(i) IS NULL AND
4042: l_segment_19_tab(i) IS NULL AND l_segment_20_tab(i) IS NULL)
4043: THEN
4044: v_is_valid_item := FALSE;
4045: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4046: p_odi_session_id => p_odi_session_id,
4047: p_input_id => i,
4048: p_err_code => 'EGO_NO_ITEM_DETAILS',
4049: p_err_message => 'Item details are not provided');

Line 4121: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4117: END IF; -- (v_is_valid_item)
4118:
4119: ELSE
4120: IF (l_list_inv_id <> -1) THEN
4121: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4122: p_odi_session_id => p_odi_session_id,
4123: p_input_id => i,
4124: p_param_name => 'InventoryItemId',
4125: p_param_value => l_list_inv_id );

Line 4213: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4209: from mtl_system_items_kfv
4210: WHERE organization_id = p_org_id
4211: AND inventory_item_id = p_inv_id;
4212:
4213: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4214: p_odi_session_id => p_odi_session_id,
4215: p_input_id => p_index,
4216: p_param_name => 'InventoryItemId',
4217: p_param_value => p_inv_item_id );

Line 4274: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4270: RETURN TRUE;
4271: EXCEPTION
4272: WHEN No_Data_Found THEN
4273: IF (p_inv_id <> -1 AND p_org_id <> -1) THEN
4274: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4275: p_odi_session_id => p_odi_session_id,
4276: p_input_id => p_index,
4277: p_param_name => 'InventoryItemId',
4278: p_param_value => p_inv_id );

Line 4280: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4276: p_input_id => p_index,
4277: p_param_name => 'InventoryItemId',
4278: p_param_value => p_inv_id );
4279:
4280: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4281: p_odi_session_id => p_odi_session_id,
4282: p_input_id => p_index,
4283: p_err_code => 'EGO_INVALID_ITEM_ID',
4284: p_err_message => 'Invalid Inventory Item Id');

Line 4311: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4307: p_segment19 ,
4308: p_segment20 ,
4309: p_index );
4310:
4311: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4312: p_odi_session_id => p_odi_session_id,
4313: p_input_id => p_index,
4314: p_err_code => 'EGO_INVALID_ITEM_NAME',
4315: p_err_message => 'Invalid Inventory Item Name');

Line 4342: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4338: INTO p_organization_id
4339: from mtl_parameters
4340: WHERE organization_id = p_org_id;
4341:
4342: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4343: p_odi_session_id => p_odi_session_id,
4344: p_input_id => p_index,
4345: p_param_name => 'OrganizationId',
4346: p_param_value => p_org_id );

Line 4353: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4349: INTO p_organization_id
4350: from mtl_parameters
4351: WHERE organization_code = p_org_code;
4352:
4353: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4354: p_odi_session_id => p_odi_session_id,
4355: p_input_id => p_index,
4356: p_param_name => 'OrganizationCode',
4357: p_param_value => p_org_code );

Line 4364: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4360: RETURN TRUE;
4361: EXCEPTION
4362: WHEN No_Data_Found THEN
4363: IF (p_org_id <> -1) THEN
4364: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4365: p_odi_session_id => p_odi_session_id,
4366: p_input_id => p_index,
4367: p_param_name => 'OrganizationId',
4368: p_param_value => p_org_id );

Line 4370: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4366: p_input_id => p_index,
4367: p_param_name => 'OrganizationId',
4368: p_param_value => p_org_id );
4369:
4370: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4371: p_odi_session_id => p_odi_session_id,
4372: p_input_id => p_index,
4373: p_err_code => 'EGO_INVALID_ORG_ID',
4374: p_err_message => 'Invalid Organization Id');

Line 4376: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4372: p_input_id => p_index,
4373: p_err_code => 'EGO_INVALID_ORG_ID',
4374: p_err_message => 'Invalid Organization Id');
4375: ELSE
4376: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4377: p_odi_session_id => p_odi_session_id,
4378: p_input_id => p_index,
4379: p_param_name => 'OrganizationCode',
4380: p_param_value => p_org_code );

Line 4382: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4378: p_input_id => p_index,
4379: p_param_name => 'OrganizationCode',
4380: p_param_value => p_org_code );
4381:
4382: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4383: p_odi_session_id => p_odi_session_id,
4384: p_input_id => p_index,
4385: p_err_code => 'EGO_INVALID_ORG_CODE',
4386: p_err_message => 'Invalid Organization Code');

Line 4528: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4524: END IF; -- end of if (p_rev_date IS NOT NULL)
4525: RETURN TRUE;
4526: EXCEPTION
4527: WHEN e_no_revision THEN
4528: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4529: p_odi_session_id => p_odi_session_id,
4530: p_input_id => p_index,
4531: p_param_name => 'RevisionDate',
4532: p_param_value => to_char(p_rev_date,'YYYY.MM.DD HH24:MI:SS')

Line 4535: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4531: p_param_name => 'RevisionDate',
4532: p_param_value => to_char(p_rev_date,'YYYY.MM.DD HH24:MI:SS')
4533: );
4534:
4535: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4536: p_odi_session_id => p_odi_session_id,
4537: p_input_id => p_index,
4538: p_err_code => 'EGO_NO_REV_EXISTS',
4539: p_err_message => 'No revision exists for the revision date');

Line 4545: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4541: RETURN FALSE;
4542:
4543: WHEN e_unimpl_revision then
4544: IF (p_rev_id <> -1) THEN
4545: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4546: p_odi_session_id => p_odi_session_id,
4547: p_input_id => p_index,
4548: p_param_name => 'RevisionId',
4549: p_param_value => p_rev_id

Line 4554: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4550: );
4551: END IF;
4552:
4553: IF (p_revision IS NOT NULL) THEN
4554: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4555: p_odi_session_id => p_odi_session_id,
4556: p_input_id => p_index,
4557: p_param_name => 'Revision',
4558: p_param_value => p_revision

Line 4562: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4558: p_param_value => p_revision
4559: );
4560: END IF;
4561:
4562: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4563: p_odi_session_id => p_odi_session_id,
4564: p_input_id => p_index,
4565: p_err_code => 'EGO_UNIMPL_REVISION',
4566: p_err_message => 'Unimplemented Revisions are not published');

Line 4572: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4568: RETURN FALSE;
4569:
4570: WHEN No_Data_Found THEN
4571: IF (p_rev_id <> -1) THEN
4572: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4573: p_odi_session_id => p_odi_session_id,
4574: p_input_id => p_index,
4575: p_param_name => 'RevisionId',
4576: p_param_value => p_rev_id

Line 4579: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4575: p_param_name => 'RevisionId',
4576: p_param_value => p_rev_id
4577: );
4578: ELSIF (p_revision IS NOT NULL) THEN
4579: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4580: p_odi_session_id => p_odi_session_id,
4581: p_input_id => p_index,
4582: p_param_name => 'Revision',
4583: p_param_value => p_revision

Line 4586: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4582: p_param_name => 'Revision',
4583: p_param_value => p_revision
4584: );
4585: ELSE
4586: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4587: p_odi_session_id => p_odi_session_id,
4588: p_input_id => p_index,
4589: p_param_name => 'RevisionDate',
4590: p_param_value => to_char(p_rev_date,'YYYY.MM.DD HH24:MI:SS')

Line 4594: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4590: p_param_value => to_char(p_rev_date,'YYYY.MM.DD HH24:MI:SS')
4591: );
4592: END IF;
4593:
4594: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4595: p_odi_session_id => p_odi_session_id,
4596: p_input_id => p_index,
4597: p_err_code => 'EGO_INVALID_REV_DETAILS',
4598: p_err_message => 'Invalid Revision Details');

Line 4640: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4636: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
4637: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
4638: WHERE session_id = p_session_id;
4639:
4640: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4641: p_odi_session_id => p_odi_session_id,
4642: p_input_id => p_index,
4643: p_param_name => 'StructureName',
4644: p_param_value => p_structure_name

Line 4655: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4651: WHERE SESSION_ID = p_session_id
4652: AND INPUT_ID = p_input_id
4653: AND PARAM_NAME = 'OrganizationCode';
4654:
4655: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4656: p_odi_session_id => p_odi_session_id,
4657: p_input_id => p_index,
4658: p_param_name => 'OrganizationCode',
4659: p_param_value => v_org_code

Line 4663: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

4659: p_param_value => v_org_code
4660: );
4661: EXCEPTION
4662: WHEN NO_DATA_FOUND THEN
4663: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4664: p_odi_session_id => p_odi_session_id,
4665: p_input_id => p_index,
4666: p_param_name => 'OrganizationId',
4667: p_param_value => p_org_id

Line 4671: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4667: p_param_value => p_org_id
4668: );
4669: END;
4670:
4671: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4672: p_odi_session_id => p_odi_session_id,
4673: p_input_id => p_index,
4674: p_err_code => 'EGO_INVALID_STRUCTURE',
4675: p_err_message => 'Invalid Structure Name and Org Combination');

Line 4764: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4760: FETCH v_dynamic_cursor INTO l_seq_number;
4761: EXIT WHEN v_dynamic_cursor%NOTFOUND;
4762:
4763: IF (p_for_exploded_items = 'N') THEN
4764: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4765: p_odi_session_id => p_odi_session_id,
4766: p_input_id => l_seq_number,
4767: p_err_code => 'EGO_NO_PUBLISH_PRIV',
4768: p_err_message => 'User does not have the publish privilege for item');

Line 4848: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4844: from mtl_system_items_b_kfv
4845: WHERE inventory_item_id = l_item_id
4846: AND ORGANIZATION_ID = l_org_id;
4847:
4848: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4849: p_odi_session_id => p_odi_session_id,
4850: p_input_id => l_seq_number,
4851: p_err_code => 'EGO_NO_PUBLISH_PRIV_COMP',
4852: p_err_message => 'User does not have the publish privilege for Component - '|| l_component_name);

Line 4878: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4874: LOOP
4875: FETCH v_dynamic_cursor INTO l_seq_number;
4876: EXIT WHEN v_dynamic_cursor%NOTFOUND;
4877:
4878: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4879: p_odi_session_id => p_odi_session_id,
4880: p_input_id => l_seq_number,
4881: p_err_code => 'EGO_NO_PUBLISH_PRIV',
4882: p_err_message => 'User does not have the publilsh privilege on few components of the structure for the item');

Line 4899: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

4895: from mtl_system_items_b_kfv
4896: WHERE inventory_item_id = i.PK1_VALUE
4897: AND ORGANIZATION_ID = i.PK2_VALUE;
4898:
4899: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
4900: p_odi_session_id => p_odi_session_id,
4901: p_input_id => l_seq_number,
4902: p_err_code => 'EGO_NO_PUBLISH_PRIV_COMP',
4903: p_err_message => 'User does not have the publish privilege for Component - '|| l_component_name);

Line 5092: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5088:
5089: DELETE EGO_PUB_WS_ERRORS
5090: WHERE session_id = p_session_id;
5091:
5092: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5093: p_odi_session_id => p_odi_session_id,
5094: p_input_id => 1,
5095: p_param_name => 'RESPONSIBILITY_NAME',
5096: p_param_value => l_responsibility_name );

Line 5098: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5094: p_input_id => 1,
5095: p_param_name => 'RESPONSIBILITY_NAME',
5096: p_param_value => l_responsibility_name );
5097:
5098: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5099: p_odi_session_id => p_odi_session_id,
5100: p_input_id => 1,
5101: p_param_name => 'RESPONSIBILITY_APPL_NAME',
5102: p_param_value => l_responsibility_appl_name );

Line 5104: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

5100: p_input_id => 1,
5101: p_param_name => 'RESPONSIBILITY_APPL_NAME',
5102: p_param_value => l_responsibility_appl_name );
5103:
5104: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
5105: p_odi_session_id => p_odi_session_id,
5106: p_input_id => 1,
5107: p_err_code => 'EGO_INVALID_SECURITY_DETAILS',
5108: p_err_message => 'Invalid Security Details');

Line 5148: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5144: IS
5145:
5146: BEGIN
5147: IF (p_segment1 IS NOT NULL) THEN
5148: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5149: p_odi_session_id => p_odi_session_id,
5150: p_input_id => p_index,
5151: p_param_name => 'Segment1',
5152: p_param_value => p_segment1 );

Line 5156: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5152: p_param_value => p_segment1 );
5153: END IF;
5154:
5155: IF (p_segment2 IS NOT NULL) THEN
5156: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5157: p_odi_session_id => p_odi_session_id,
5158: p_input_id => p_index,
5159: p_param_name => 'Segment2',
5160: p_param_value => p_segment2 );

Line 5164: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5160: p_param_value => p_segment2 );
5161: END IF;
5162:
5163: IF (p_segment3 IS NOT NULL) THEN
5164: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5165: p_odi_session_id => p_odi_session_id,
5166: p_input_id => p_index,
5167: p_param_name => 'Segment3',
5168: p_param_value => p_segment3 );

Line 5172: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5168: p_param_value => p_segment3 );
5169: END IF;
5170:
5171: IF (p_segment4 IS NOT NULL) THEN
5172: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5173: p_odi_session_id => p_odi_session_id,
5174: p_input_id => p_index,
5175: p_param_name => 'Segment4',
5176: p_param_value => p_segment4 );

Line 5180: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5176: p_param_value => p_segment4 );
5177: END IF;
5178:
5179: IF (p_segment5 IS NOT NULL) THEN
5180: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5181: p_odi_session_id => p_odi_session_id,
5182: p_input_id => p_index,
5183: p_param_name => 'Segment5',
5184: p_param_value => p_segment5 );

Line 5188: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5184: p_param_value => p_segment5 );
5185: END IF;
5186:
5187: IF (p_segment6 IS NOT NULL) THEN
5188: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5189: p_odi_session_id => p_odi_session_id,
5190: p_input_id => p_index,
5191: p_param_name => 'Segment6',
5192: p_param_value => p_segment6 );

Line 5196: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5192: p_param_value => p_segment6 );
5193: END IF;
5194:
5195: IF (p_segment7 IS NOT NULL) THEN
5196: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5197: p_odi_session_id => p_odi_session_id,
5198: p_input_id => p_index,
5199: p_param_name => 'Segment7',
5200: p_param_value => p_segment7 );

Line 5204: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5200: p_param_value => p_segment7 );
5201: END IF;
5202:
5203: IF (p_segment8 IS NOT NULL) THEN
5204: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5205: p_odi_session_id => p_odi_session_id,
5206: p_input_id => p_index,
5207: p_param_name => 'Segment8',
5208: p_param_value => p_segment8 );

Line 5212: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5208: p_param_value => p_segment8 );
5209: END IF;
5210:
5211: IF (p_segment9 IS NOT NULL) THEN
5212: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5213: p_odi_session_id => p_odi_session_id,
5214: p_input_id => p_index,
5215: p_param_name => 'Segment9',
5216: p_param_value => p_segment9 );

Line 5220: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5216: p_param_value => p_segment9 );
5217: END IF;
5218:
5219: IF (p_segment10 IS NOT NULL) THEN
5220: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5221: p_odi_session_id => p_odi_session_id,
5222: p_input_id => p_index,
5223: p_param_name => 'Segment10',
5224: p_param_value => p_segment10 );

Line 5228: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5224: p_param_value => p_segment10 );
5225: END IF;
5226:
5227: IF (p_segment11 IS NOT NULL) THEN
5228: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5229: p_odi_session_id => p_odi_session_id,
5230: p_input_id => p_index,
5231: p_param_name => 'Segment11',
5232: p_param_value => p_segment11 );

Line 5236: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5232: p_param_value => p_segment11 );
5233: END IF;
5234:
5235: IF (p_segment12 IS NOT NULL) THEN
5236: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5237: p_odi_session_id => p_odi_session_id,
5238: p_input_id => p_index,
5239: p_param_name => 'Segment12',
5240: p_param_value => p_segment12 );

Line 5244: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5240: p_param_value => p_segment12 );
5241: END IF;
5242:
5243: IF (p_segment13 IS NOT NULL) THEN
5244: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5245: p_odi_session_id => p_odi_session_id,
5246: p_input_id => p_index,
5247: p_param_name => 'Segment13',
5248: p_param_value => p_segment13 );

Line 5252: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5248: p_param_value => p_segment13 );
5249: END IF;
5250:
5251: IF (p_segment14 IS NOT NULL) THEN
5252: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5253: p_odi_session_id => p_odi_session_id,
5254: p_input_id => p_index,
5255: p_param_name => 'Segment14',
5256: p_param_value => p_segment14 );

Line 5260: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5256: p_param_value => p_segment14 );
5257: END IF;
5258:
5259: IF (p_segment15 IS NOT NULL) THEN
5260: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5261: p_odi_session_id => p_odi_session_id,
5262: p_input_id => p_index,
5263: p_param_name => 'Segment15',
5264: p_param_value => p_segment15 );

Line 5269: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5265:
5266: END IF;
5267:
5268: IF (p_segment16 IS NOT NULL) THEN
5269: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5270: p_odi_session_id => p_odi_session_id,
5271: p_input_id => p_index,
5272: p_param_name => 'Segment16',
5273: p_param_value => p_segment16 );

Line 5278: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5274:
5275: END IF;
5276:
5277: IF (p_segment17 IS NOT NULL) THEN
5278: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5279: p_odi_session_id => p_odi_session_id,
5280: p_input_id => p_index,
5281: p_param_name => 'Segment17',
5282: p_param_value => p_segment17 );

Line 5287: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5283:
5284: END IF;
5285:
5286: IF (p_segment18 IS NOT NULL) THEN
5287: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5288: p_odi_session_id => p_odi_session_id,
5289: p_input_id => p_index,
5290: p_param_name => 'Segment18',
5291: p_param_value => p_segment18 );

Line 5296: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5292:
5293: END IF;
5294:
5295: IF (p_segment19 IS NOT NULL) THEN
5296: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5297: p_odi_session_id => p_odi_session_id,
5298: p_input_id => p_index,
5299: p_param_name => 'Segment19',
5300: p_param_value => p_segment19 );

Line 5305: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5301:
5302: END IF;
5303:
5304: IF (p_segment20 IS NOT NULL) THEN
5305: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5306: p_odi_session_id => p_odi_session_id,
5307: p_input_id => p_index,
5308: p_param_name => 'Segment20',
5309: p_param_value => p_segment20 );

Line 5325: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5321: IS
5322: BEGIN
5323:
5324: IF (p_rev_id <> -1) THEN
5325: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5326: p_odi_session_id => p_odi_session_id,
5327: p_input_id => p_index,
5328: p_param_name => 'RevisionId',
5329: p_param_value => p_rev_id );

Line 5333: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5329: p_param_value => p_rev_id );
5330: END IF;
5331:
5332: IF (p_revision IS NOT NULL) THEN
5333: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5334: p_odi_session_id => p_odi_session_id,
5335: p_input_id => p_index,
5336: p_param_name => 'Revision',
5337: p_param_value => p_revision );

Line 5341: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

5337: p_param_value => p_revision );
5338: END IF;
5339:
5340: IF (p_rev_date IS NOT NULL) THEN
5341: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
5342: p_odi_session_id => p_odi_session_id,
5343: p_input_id => p_index,
5344: p_param_name => 'RevisionDate',
5345: p_param_value => p_rev_date );