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_PVT dependencies on EGO_ITEM_PUB

Line 350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE

346: ) RETURN BOOLEAN IS
347: l_hz_party_type HZ_PARTIES.party_type%TYPE;
348: l_dummy_char VARCHAR2(32767);
349: BEGIN
350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
354: ) THEN

Line 351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

347: l_hz_party_type HZ_PARTIES.party_type%TYPE;
348: l_dummy_char VARCHAR2(32767);
349: BEGIN
350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
354: ) THEN
355: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

Line 352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

348: l_dummy_char VARCHAR2(32767);
349: BEGIN
350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
354: ) THEN
355: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
356: x_party_id := -1000; -- needed by EGO_SECURITY_PUB

Line 353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE

349: BEGIN
350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
354: ) THEN
355: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
356: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
357: x_party_name := p_party_type;

Line 355: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
352: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
353: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
354: ) THEN
355: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
356: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
357: x_party_name := p_party_type;
358: RETURN TRUE;
359: ELSE

Line 360: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

356: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
357: x_party_name := p_party_type;
358: RETURN TRUE;
359: ELSE
360: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
361: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
362: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
363: l_hz_party_type := p_party_type;
364: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

Line 362: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN

358: RETURN TRUE;
359: ELSE
360: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
361: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
362: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
363: l_hz_party_type := p_party_type;
364: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
365: l_hz_party_type := G_HZ_USER_PARTY_TYPE;
366: END IF;

Line 364: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

360: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
361: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
362: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
363: l_hz_party_type := p_party_type;
364: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
365: l_hz_party_type := G_HZ_USER_PARTY_TYPE;
366: END IF;
367: IF x_party_id IS NOT NULL THEN
368: -- validate the party_id passed.

Line 932: EGO_ITEM_PUB.Update_Item_Attr_Ext(

928:
929: BEGIN
930: code_debug('update_common_attrs : ' || ' Entering method with params p_commit = ' || p_commit);
931:
932: EGO_ITEM_PUB.Update_Item_Attr_Ext(
933: P_API_VERSION => 1.0,
934: P_INIT_MSG_LIST => l_init_msg_list,
935: P_COMMIT => p_commit,
936: P_INVENTORY_ITEM_ID => p_inventory_item_id,

Line 941: code_debug('update_common_attrs : ' || ' Return status for ego_item_pub.update-item_attr_ext ' || x_return_status

937: P_ITEM_CATALOG_GROUP_ID => p_new_icc_id,
938: x_return_status => x_return_status,
939: X_MSG_COUNT => x_msg_count);
940:
941: code_debug('update_common_attrs : ' || ' Return status for ego_item_pub.update-item_attr_ext ' || x_return_status
942: || ' count = ' || x_msg_count);
943:
944: END update_common_attrs;
945:

Line 1019: G_Item_Rec EGO_Item_PUB.Item_Rec_Type;

1015: l_error_code NUMBER;
1016: --R12 C
1017: l_return_err VARCHAR2(1000);
1018: l_batch_id NUMBER;
1019: G_Item_Rec EGO_Item_PUB.Item_Rec_Type;
1020: l_error_text VARCHAR2(4000);
1021:
1022:
1023: ----------------------------------------------------------------------------

Line 2037: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;

2033:
2034: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';
2035: l_return_status VARCHAR2(1) := G_MISS_CHAR;
2036: l_msg_count NUMBER := 0;
2037: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

Line 3505: (EGO_ITEM_PUB.G_TTYPE_CREATE

3501: --
3502: IF ( p_transaction_type IS NULL
3503: OR
3504: p_transaction_type NOT IN
3505: (EGO_ITEM_PUB.G_TTYPE_CREATE
3506: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3507: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3508: )
3509: OR

Line 3506: ,EGO_ITEM_PUB.G_TTYPE_DELETE

3502: IF ( p_transaction_type IS NULL
3503: OR
3504: p_transaction_type NOT IN
3505: (EGO_ITEM_PUB.G_TTYPE_CREATE
3506: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3507: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3508: )
3509: OR
3510: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

Line 3507: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

3503: OR
3504: p_transaction_type NOT IN
3505: (EGO_ITEM_PUB.G_TTYPE_CREATE
3506: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3507: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3508: )
3509: OR
3510: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
3511: AND( (p_role_name IS NULL AND p_role_id IS NULL)

Line 3510: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

3506: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3507: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3508: )
3509: OR
3510: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
3511: AND( (p_role_name IS NULL AND p_role_id IS NULL)
3512: OR
3513: p_party_type IS NULL
3514: OR

Line 3516: (EGO_ITEM_PUB.G_USER_PARTY_TYPE

3512: OR
3513: p_party_type IS NULL
3514: OR
3515: p_party_type NOT IN
3516: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3517: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )

Line 3517: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

3513: p_party_type IS NULL
3514: OR
3515: p_party_type NOT IN
3516: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3517: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )
3521: OR

Line 3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

3514: OR
3515: p_party_type NOT IN
3516: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3517: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )
3521: OR
3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

Line 3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE

3515: p_party_type NOT IN
3516: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3517: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )
3521: OR
3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3523: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

Line 3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

3518: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )
3521: OR
3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3523: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3524: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3525: AND p_party_name IS NULL
3526: AND p_party_id IS NULL

Line 3523: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

3519: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3520: )
3521: OR
3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3523: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3524: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3525: AND p_party_name IS NULL
3526: AND p_party_id IS NULL
3527: )

Line 3524: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)

3520: )
3521: OR
3522: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3523: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3524: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3525: AND p_party_name IS NULL
3526: AND p_party_id IS NULL
3527: )
3528: OR

Line 3532: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

3528: OR
3529: p_instance_type IS NULL
3530: OR
3531: p_instance_type NOT IN
3532: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3533: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3534: )
3535: OR
3536: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

Line 3533: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

3529: p_instance_type IS NULL
3530: OR
3531: p_instance_type NOT IN
3532: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3533: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3534: )
3535: OR
3536: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3537: AND

Line 3536: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

3532: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3533: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3534: )
3535: OR
3536: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3537: AND
3538: ( (p_instance_set_id IS NULL AND p_instance_set_name IS NULL)
3539: OR
3540: p_inventory_item_id IS NOT NULL

Line 3546: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

3542: p_organization_id IS NOT NULL
3543: )
3544: )
3545: OR
3546: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3547: AND
3548: ( (p_inventory_item_id IS NULL AND p_item_number IS NULL)
3549: OR
3550: (p_organization_id IS NULL AND p_organization_code IS NULL)

Line 3558: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

3554: )
3555: )
3556: )
3557: OR
3558: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
3559: AND (x_grant_guid IS NULL)
3560: )
3561: OR
3562: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE

Line 3562: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE

3558: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
3559: AND (x_grant_guid IS NULL)
3560: )
3561: OR
3562: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE
3563: AND (x_grant_guid IS NULL)
3564: )
3565: ) THEN
3566: --

Line 3588: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE

3584: l_party_id := p_party_id;
3585: l_party_name := p_party_name;
3586: l_create_grant_flag := TRUE;
3587:
3588: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE
3589: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN
3590:
3591: BEGIN
3592: SELECT instance_type, instance_set_id, instance_pk1_value,

Line 3589: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN

3585: l_party_name := p_party_name;
3586: l_create_grant_flag := TRUE;
3587:
3588: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE
3589: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN
3590:
3591: BEGIN
3592: SELECT instance_type, instance_set_id, instance_pk1_value,
3593: instance_pk2_value, start_date, end_date

Line 3603: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

3599: code_debug(l_api_name||' grant validation check done ' );
3600: EXCEPTION
3601: WHEN NO_DATA_FOUND THEN
3602: code_debug (l_api_version ||' no grant found for modification ');
3603: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3604: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3605: ELSE
3606: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3607: END IF;

Line 3615: IF l_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE THEN

3611: --
3612: -- no security check done for the update of grants of type instance set.
3613: -- should this be done??
3614: --
3615: IF l_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE THEN
3616: l_inventory_item_id := l_pk1_value;
3617: l_organization_id := l_pk2_value;
3618: -- 4052565
3619: -- modified call to has_role_on_item from validate_role_privilege

Line 3644: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN

3640: END IF;
3641: code_debug(l_api_name ||' user has function privilege to update the roles in instance set');
3642: END IF;
3643:
3644: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN
3645: --
3646: -- delete the grant given
3647: --
3648: code_debug(l_api_name||' calling EGO_SECURITY_PUB.revoke_grant ' );

Line 3668: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

3664: COMMIT WORK;
3665: END IF;
3666: RETURN;
3667: END IF;
3668: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3669: --
3670: -- update the grant given
3671: --
3672: IF date_check (p_start_date => l_sysdate

Line 3717: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN

3713: END IF;
3714: RETURN;
3715: END IF;
3716: END IF;
3717: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
3718: code_debug(l_api_name||' started validations for CREATE ');
3719: --
3720: -- start validations for create
3721: --

Line 3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

3727: ,x_party_name => l_party_name
3728: ) THEN
3729: code_debug (l_api_version ||' invalid party passed ');
3730: l_create_grant_flag := FALSE;
3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');

Line 3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN

3730: l_create_grant_flag := FALSE;
3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');

Line 3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

Line 4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

4114: -- check for invalid params
4115: --
4116: IF ( p_transaction_type IS NULL
4117: OR
4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS

Line 4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE

4115: --
4116: IF ( p_transaction_type IS NULL
4117: OR
4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported

Line 4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE

4116: IF ( p_transaction_type IS NULL
4117: OR
4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )

Line 4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE

4117: OR
4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )
4125: OR

Line 4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS

4118: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )
4125: OR
4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

Line 4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported

4119: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4120: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
4121: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )
4125: OR
4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4127: ,EGO_ITEM_PUB.G_TTYPE_DELETE

Line 4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

4122: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )
4125: OR
4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4127: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4128: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE Bug 11064547- Change Phase transation Type not supported
4129: )
4130: AND

Line 4127: ,EGO_ITEM_PUB.G_TTYPE_DELETE

4123: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE /* P4TP immutability enhancement */ Bug 11064547- Change Phase transation Type not supported
4124: )
4125: OR
4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4127: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4128: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE Bug 11064547- Change Phase transation Type not supported
4129: )
4130: AND
4131: (p_revision IS NOT NULL OR p_revision_id IS NOT NULL)

Line 4128: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE Bug 11064547- Change Phase transation Type not supported

4124: )
4125: OR
4126: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
4127: ,EGO_ITEM_PUB.G_TTYPE_DELETE
4128: -- ,EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE Bug 11064547- Change Phase transation Type not supported
4129: )
4130: AND
4131: (p_revision IS NOT NULL OR p_revision_id IS NOT NULL)
4132: AND

Line 4136: ( p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE

4132: AND
4133: p_status IS NOT NULL
4134: )
4135: OR
4136: ( p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE
4137: AND
4138: (
4139: (p_phase_id IS NULL) --- phase_id must be passed
4140: OR

Line 4167: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

4163: l_inventory_item_id := p_inventory_item_id;
4164: l_item_number := p_item_number;
4165: l_sysdate := SYSDATE;
4166:
4167: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
4168: l_effective_date := NVL(p_new_effective_date,l_sysdate);
4169: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
4170: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4171: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN

Line 4169: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE

4165: l_sysdate := SYSDATE;
4166:
4167: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
4168: l_effective_date := NVL(p_new_effective_date,l_sysdate);
4169: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
4170: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4171: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
4172: l_effective_date := NVL(p_effective_date, l_sysdate);
4173: ELSE

Line 4170: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE

4166:
4167: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
4168: l_effective_date := NVL(p_new_effective_date,l_sysdate);
4169: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
4170: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4171: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
4172: l_effective_date := NVL(p_effective_date, l_sysdate);
4173: ELSE
4174: l_effective_date := l_sysdate;

Line 4171: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN

4167: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
4168: l_effective_date := NVL(p_new_effective_date,l_sysdate);
4169: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
4170: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
4171: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
4172: l_effective_date := NVL(p_effective_date, l_sysdate);
4173: ELSE
4174: l_effective_date := l_sysdate;
4175: END IF;

Line 4223: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

4219: l_change_status_flag := FALSE;
4220: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_APPROVED');
4221: fnd_msg_pub.Add;
4222: ELSE
4223: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4224: l_priv_function_name := G_FN_NAME_PROMOTE;
4225: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
4226: l_priv_function_name := G_FN_NAME_DEMOTE;
4227: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

Line 4225: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

4221: fnd_msg_pub.Add;
4222: ELSE
4223: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4224: l_priv_function_name := G_FN_NAME_PROMOTE;
4225: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
4226: l_priv_function_name := G_FN_NAME_DEMOTE;
4227: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4228: l_priv_function_name := G_FN_NAME_CHANGE_STATUS;
4229: END IF;

Line 4227: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

4223: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4224: l_priv_function_name := G_FN_NAME_PROMOTE;
4225: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
4226: l_priv_function_name := G_FN_NAME_DEMOTE;
4227: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4228: l_priv_function_name := G_FN_NAME_CHANGE_STATUS;
4229: END IF;
4230: IF NOT has_role_on_item
4231: (p_function_name => l_priv_function_name

Line 4281: IF ( p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE)

4277: );
4278: FETCH c_get_item_det INTO l_curr_cc_id, l_curr_lifecycle_id, l_curr_phase_id, l_curr_status;
4279: CLOSE c_get_item_det;
4280: END IF;
4281: IF ( p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE)
4282: AND
4283: l_curr_lifecycle_id IS NULL
4284: ) THEN
4285: l_change_status_flag := FALSE;

Line 4306: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE

4302: --
4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305:
4306: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE
4307: /* , EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE */) THEN
4308: --
4309: -- check if there is a project associated
4310: --

Line 4307: /* , EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE */) THEN

4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305:
4306: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE
4307: /* , EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE */) THEN
4308: --
4309: -- check if there is a project associated
4310: --
4311: IF 'TRUE' = EGO_LIFECYCLE_USER_PUB.Has_LC_Tracking_Project

Line 4328: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

4324: fnd_message.set_token('ORG_NAME', l_org_name);
4325: fnd_msg_pub.Add;
4326: END IF;
4327:
4328: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4329:
4330: -- BUG 11064547 swuppala: allow skipping of Phase during Promote/ Demote START
4331: -- If Phase ID is given, promote the Item to the given phase
4332: -- Or promote to the next immediate phase

Line 4408: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

4404:
4405: fnd_msg_pub.Add;
4406: END IF;
4407: END IF;
4408: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
4409:
4410: -- If Phase ID is given, demote the Item to the given phase
4411: -- Or demote to the immediate previous phas
4412: IF(p_phase_id IS NULL) THEN

Line 4490: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE then

4486: END IF;
4487: -- PROMOTE/DEMOTE can be used to skip the phase
4488: -- CHANGE_PHASE is not supported Bug 11064547
4489: /*
4490: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE then
4491: --- first chk if the phase entered exists
4492: ---
4493: --- chk if the phase is part of the current lifecycle of the item
4494: OPEN c_chk_phase_against_lc (cp_lifecycle_id => l_curr_lifecycle_id

Line 4613: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN

4609: );
4610: fnd_message.set_token('CATALOG_CATEGORY_NAME', l_dummy_char);
4611: fnd_msg_pub.Add;
4612: END IF;
4613: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4614: -- check if the user has privilege to update the item.
4615: IF p_phase_id IS NOT NULL THEN
4616: -- user changing phase
4617: OPEN c_get_phase_seq(cp_phase_id => l_curr_phase_id);

Line 4662: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN

4658: END IF;
4659:
4660: IF l_change_status_flag THEN
4661: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change ');
4662: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4663: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4664: (p_api_version => p_api_version
4665: ,p_commit => FND_API.G_FALSE
4666: ,p_inventory_item_id => l_inventory_item_id

Line 4686: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE THEN

4682: );
4683: -- PROMOTE/DEMOTE can be used to skip the phase
4684: -- CHANGE_PHASE is not supported- Bug 11064547
4685: /*
4686: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE THEN
4687:
4688: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4689: (p_api_version => p_api_version
4690: ,p_commit => FND_API.G_FALSE

Line 4709: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

4705: ,x_msg_count => x_msg_count
4706: ,x_msg_data => x_msg_data
4707: );
4708: */
4709: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4710: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4711: (p_api_version => p_api_version
4712: ,p_commit => FND_API.G_FALSE
4713: ,p_inventory_item_id => l_inventory_item_id

Line 4731: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN

4727: ,x_msg_count => x_msg_count
4728: ,x_msg_data => x_msg_data
4729: );
4730:
4731: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4732: EGO_ITEM_LC_IMP_PC_PUB.Modify_Pending_Phase_Change
4733: (p_api_version => p_api_version
4734: ,p_commit => FND_API.G_FALSE
4735: ,p_transaction_type => p_transaction_type