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.ENG_CHANGE_LIFECYCLE_UTIL dependencies on FND_PROFILE

Line 165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));

161: ----------------------------------------------------------------
162: -- Open the Debug Log Session, p_debug_flag is TRUE or
163: -- if Profile is set to TRUE: INV_DEBUG_TRACE Yes, INV_DEBUG_LEVEL 20
164: ----------------------------------------------------------------
165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
167:
168: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
169: OR FND_API.to_Boolean(p_debug_flag)

Line 166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));

162: -- Open the Debug Log Session, p_debug_flag is TRUE or
163: -- if Profile is set to TRUE: INV_DEBUG_TRACE Yes, INV_DEBUG_LEVEL 20
164: ----------------------------------------------------------------
165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
167:
168: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
169: OR FND_API.to_Boolean(p_debug_flag)
170: THEN

Line 347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

343: ,x_auto_demote_status OUT NOCOPY NUMBER
344: )
345: IS
346:
347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

Line 348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

344: )
345: IS
346:
347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
352:

Line 381: -- FND_PROFILE package is not available for workflow (WF),

377: Write_Debug('-----------------------------------------------------');
378: Write_Debug('Initializing return status... ' );
379: END IF;
380:
381: -- FND_PROFILE package is not available for workflow (WF),
382: -- therefore manually set WHO column values
383: IF p_api_caller = 'WF' THEN
384: l_fnd_user_id := G_ENG_WF_USER_ID;
385: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

598: l_return_status VARCHAR2(1);
599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601:
602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
604:
605: l_updated BOOLEAN := FALSE ;
606:

Line 603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601:
602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
604:
605: l_updated BOOLEAN := FALSE ;
606:
607: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

Line 665: -- FND_PROFILE package is not available for workflow (WF),

661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: -- FND_PROFILE package is not available for workflow (WF),
666: -- therefore manually set WHO column values
667: IF p_api_caller = 'WF' THEN
668: l_fnd_user_id := G_ENG_WF_USER_ID;
669: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1283: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1279: l_msg_count NUMBER;
1280: l_msg_data VARCHAR2(2000);
1281:
1282: l_api_caller VARCHAR2(2) := NULL;
1283: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1284: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1285:
1286:
1287: l_change_line_id NUMBER ;

Line 1284: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1280: l_msg_data VARCHAR2(2000);
1281:
1282: l_api_caller VARCHAR2(2) := NULL;
1283: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1284: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1285:
1286:
1287: l_change_line_id NUMBER ;
1288: l_line_wf_route_id NUMBER ;

Line 1366: -- FND_PROFILE package is not available for workflow (WF),

1362:
1363: -- Initialize API return status to success
1364: x_return_status := FND_API.G_RET_STS_SUCCESS;
1365:
1366: -- FND_PROFILE package is not available for workflow (WF),
1367: -- therefore manually set WHO column values
1368: IF p_api_caller = 'WF' THEN
1369: l_fnd_user_id := G_ENG_WF_USER_ID;
1370: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1551: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1547: l_msg_count NUMBER;
1548: l_msg_data VARCHAR2(2000);
1549:
1550: l_api_caller VARCHAR2(2) := NULL;
1551: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1552: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1553:
1554: l_action_id eng_change_actions.action_id%TYPE;
1555:

Line 1552: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1548: l_msg_data VARCHAR2(2000);
1549:
1550: l_api_caller VARCHAR2(2) := NULL;
1551: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1552: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1553:
1554: l_action_id eng_change_actions.action_id%TYPE;
1555:
1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

Line 1609: -- FND_PROFILE package is not available for workflow (WF),

1605:
1606: -- Initialize API return status to success
1607: x_return_status := FND_API.G_RET_STS_SUCCESS;
1608:
1609: -- FND_PROFILE package is not available for workflow (WF),
1610: -- therefore manually set WHO column values
1611: IF p_api_caller = 'WF' THEN
1612: l_fnd_user_id := G_ENG_WF_USER_ID;
1613: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1972: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1968: IS
1969: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Header';
1970: l_api_version CONSTANT NUMBER := 1.0;
1971:
1972: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1973: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1974:
1975: l_is_imp_phase_used VARCHAR2(1) := 'F';
1976:

Line 1973: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1969: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Header';
1970: l_api_version CONSTANT NUMBER := 1.0;
1971:
1972: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1973: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1974:
1975: l_is_imp_phase_used VARCHAR2(1) := 'F';
1976:
1977: l_last_status_type NUMBER;

Line 2157: -- FND_PROFILE package is not available for workflow (WF),

2153:
2154: -- Initialize API return status to success
2155: x_return_status := FND_API.G_RET_STS_SUCCESS;
2156:
2157: -- FND_PROFILE package is not available for workflow (WF),
2158: -- therefore manually set WHO column values
2159: IF p_api_caller = 'WF' THEN
2160: l_fnd_user_id := G_ENG_WF_USER_ID;
2161: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 3138: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3134: IS
3135: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Header';
3136: l_api_version CONSTANT NUMBER := 1.0;
3137:
3138: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3139: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3140:
3141: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
3142:

Line 3139: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

3135: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Header';
3136: l_api_version CONSTANT NUMBER := 1.0;
3137:
3138: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3139: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3140:
3141: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
3142:
3143: l_is_imp_phase_used VARCHAR2(1) := 'F';

Line 3262: -- FND_PROFILE package is not available for workflow (WF),

3258:
3259: -- Initialize API return status to success
3260: x_return_status := FND_API.G_RET_STS_SUCCESS;
3261:
3262: -- FND_PROFILE package is not available for workflow (WF),
3263: -- therefore manually set WHO column values
3264: IF p_api_caller = 'WF' THEN
3265: l_fnd_user_id := G_ENG_WF_USER_ID;
3266: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 3896: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3892: IS
3893: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Revised_Item';
3894: l_api_version CONSTANT NUMBER := 1.0;
3895:
3896: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3897: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3898:
3899: l_return_status VARCHAR2(1);
3900: l_msg_count NUMBER;

Line 3897: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

3893: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Revised_Item';
3894: l_api_version CONSTANT NUMBER := 1.0;
3895:
3896: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3897: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3898:
3899: l_return_status VARCHAR2(1);
3900: l_msg_count NUMBER;
3901: l_msg_data VARCHAR2(2000);

Line 3957: -- FND_PROFILE package is not available for workflow (WF),

3953:
3954: -- Initialize API return status to success
3955: x_return_status := FND_API.G_RET_STS_SUCCESS;
3956:
3957: -- FND_PROFILE package is not available for workflow (WF),
3958: -- therefore manually set WHO column values
3959: IF p_api_caller = 'WF' THEN
3960: l_fnd_user_id := G_ENG_WF_USER_ID;
3961: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 4272: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

4268: IS
4269: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Revised_Item';
4270: l_api_version CONSTANT NUMBER := 1.0;
4271:
4272: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4273: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4274:
4275: l_api_caller VARCHAR2(2) := NULL;
4276:

Line 4273: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

4269: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Revised_Item';
4270: l_api_version CONSTANT NUMBER := 1.0;
4271:
4272: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4273: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4274:
4275: l_api_caller VARCHAR2(2) := NULL;
4276:
4277: l_return_status VARCHAR2(1);

Line 4331: -- FND_PROFILE package is not available for workflow (WF),

4327:
4328: -- Initialize API return status to success
4329: x_return_status := FND_API.G_RET_STS_SUCCESS;
4330:
4331: -- FND_PROFILE package is not available for workflow (WF),
4332: -- therefore manually set WHO column values
4333: IF p_api_caller = 'WF' THEN
4334: l_fnd_user_id := G_ENG_WF_USER_ID;
4335: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 4962: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

4958: l_return_status VARCHAR2(1);
4959: l_msg_count NUMBER;
4960: l_msg_data VARCHAR2(2000);
4961:
4962: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4963: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4964:
4965: l_api_caller VARCHAR2(2) := NULL;
4966:

Line 4963: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

4959: l_msg_count NUMBER;
4960: l_msg_data VARCHAR2(2000);
4961:
4962: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4963: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4964:
4965: l_api_caller VARCHAR2(2) := NULL;
4966:
4967: l_action_id eng_change_actions.action_id%TYPE;

Line 5053: -- FND_PROFILE package is not available for workflow (WF),

5049:
5050: -- Initialize API return status to success
5051: x_return_status := FND_API.G_RET_STS_SUCCESS;
5052:
5053: -- FND_PROFILE package is not available for workflow (WF),
5054: -- therefore manually set WHO column values
5055: IF p_api_caller = 'WF' THEN
5056: l_fnd_user_id := G_ENG_WF_USER_ID;
5057: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 6438: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

6434: l_return_status VARCHAR2(1);
6435: l_msg_count NUMBER;
6436: l_msg_data VARCHAR2(2000);
6437:
6438: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6439: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6440:
6441: CURSOR c_currPhase IS
6442: SELECT *

Line 6439: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

6435: l_msg_count NUMBER;
6436: l_msg_data VARCHAR2(2000);
6437:
6438: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6439: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6440:
6441: CURSOR c_currPhase IS
6442: SELECT *
6443: FROM eng_lifecycle_statuses

Line 6499: -- FND_PROFILE package is not available for workflow (WF),

6495:
6496: -- Initialize API return status to success
6497: x_return_status := FND_API.G_RET_STS_SUCCESS;
6498:
6499: -- FND_PROFILE package is not available for workflow (WF),
6500: -- therefore manually set WHO column values
6501: IF p_api_caller = 'WF' THEN
6502: l_fnd_user_id := G_ENG_WF_USER_ID;
6503: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 6680: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

6676: l_return_status VARCHAR2(1);
6677: l_msg_count NUMBER;
6678: l_msg_data VARCHAR2(2000);
6679:
6680: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6681: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6682:
6683: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6684: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

Line 6681: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

6677: l_msg_count NUMBER;
6678: l_msg_data VARCHAR2(2000);
6679:
6680: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6681: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6682:
6683: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6684: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
6685: l_bug_number NUMBER := 0;

Line 6772: -- FND_PROFILE package is not available for workflow (WF),

6768:
6769: -- Initialize API return status to success
6770: x_return_status := FND_API.G_RET_STS_SUCCESS;
6771:
6772: -- FND_PROFILE package is not available for workflow (WF),
6773: -- therefore manually set WHO column values
6774: IF p_api_caller = 'WF' THEN
6775: l_fnd_user_id := G_ENG_WF_USER_ID;
6776: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7395: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7391: l_return_status VARCHAR2(1);
7392: l_msg_count NUMBER;
7393: l_msg_data VARCHAR2(2000);
7394:
7395: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7396: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7397:
7398: BEGIN
7399: -- Standard Start of API savepoint

Line 7396: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7392: l_msg_count NUMBER;
7393: l_msg_data VARCHAR2(2000);
7394:
7395: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7396: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7397:
7398: BEGIN
7399: -- Standard Start of API savepoint
7400: --SAVEPOINT Update_RevItem_Lifecycle;

Line 7435: -- FND_PROFILE package is not available for workflow (WF),

7431:
7432: -- Initialize API return status to success
7433: x_return_status := FND_API.G_RET_STS_SUCCESS;
7434:
7435: -- FND_PROFILE package is not available for workflow (WF),
7436: -- therefore manually set WHO column values
7437: IF p_api_caller = 'WF' THEN
7438: l_fnd_user_id := G_ENG_WF_USER_ID;
7439: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7545: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7541:
7542: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Phase';
7543: l_api_version CONSTANT NUMBER := 1.0;
7544:
7545: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7546: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7547:
7548: l_return_status VARCHAR2(1);
7549: l_msg_count NUMBER;

Line 7546: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7542: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Phase';
7543: l_api_version CONSTANT NUMBER := 1.0;
7544:
7545: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7546: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7547:
7548: l_return_status VARCHAR2(1);
7549: l_msg_count NUMBER;
7550: l_msg_data VARCHAR2(2000);

Line 7620: -- FND_PROFILE package is not available for workflow (WF),

7616:
7617: -- Initialize API return status to success
7618: x_return_status := FND_API.G_RET_STS_SUCCESS;
7619:
7620: -- FND_PROFILE package is not available for workflow (WF),
7621: -- therefore manually set WHO column values
7622: IF p_api_caller = 'WF' THEN
7623: l_fnd_user_id := G_ENG_WF_USER_ID;
7624: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7990: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7986:
7987: l_api_name CONSTANT VARCHAR2(30) := 'Sync_LC_Phase_Setup';
7988: l_api_version CONSTANT NUMBER := 1.0;
7989:
7990: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7991: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7992:
7993: l_return_status VARCHAR2(1);
7994: l_msg_count NUMBER;

Line 7991: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7987: l_api_name CONSTANT VARCHAR2(30) := 'Sync_LC_Phase_Setup';
7988: l_api_version CONSTANT NUMBER := 1.0;
7989:
7990: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7991: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7992:
7993: l_return_status VARCHAR2(1);
7994: l_msg_count NUMBER;
7995: l_msg_data VARCHAR2(2000);

Line 8053: -- FND_PROFILE package is not available for workflow (WF),

8049:
8050: -- Initialize API return status to success
8051: x_return_status := FND_API.G_RET_STS_SUCCESS;
8052:
8053: -- FND_PROFILE package is not available for workflow (WF),
8054: -- therefore manually set WHO column values
8055: IF p_api_caller = 'WF' THEN
8056: l_fnd_user_id := G_ENG_WF_USER_ID;
8057: l_fnd_login_id := G_ENG_WF_LOGIN_ID;