6:
7: /* abedajna add begin */
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_Utility_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwvutlb.pls';
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
12: /* abedajna add end */
13:
14: /** dliao add **/
7: /* abedajna add begin */
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_Utility_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwvutlb.pls';
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
12: /* abedajna add end */
13:
14: /** dliao add **/
15: g_initialize_log BOOLEAN :=FALSE;
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735: IF FND_GLOBAL.User_Id IS NULL THEN
736: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF FND_GLOBAL.User_Id IS NULL THEN
1025: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:
1851: END IF;
1852: ELSE */
1853: /* 1. Talk with IBE folks when they encounter the similar problem.
1854: they recommend that to user this user and responsibility,
1855: instead of the user from fnd_global. I will double confirm with FND.
1856: 2. Why always forced to use user (5), we will only use it
1857: when there is no valid user
1858: */
1859: /*IF (FND_GLOBAL.USER_ID() is null or
1855: instead of the user from fnd_global. I will double confirm with FND.
1856: 2. Why always forced to use user (5), we will only use it
1857: when there is no valid user
1858: */
1859: /*IF (FND_GLOBAL.USER_ID() is null or
1860: FND_GLOBAL.USER_ID() < -1) THEN
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1856: 2. Why always forced to use user (5), we will only use it
1857: when there is no valid user
1858: */
1859: /*IF (FND_GLOBAL.USER_ID() is null or
1860: FND_GLOBAL.USER_ID() < -1) THEN
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1864: FND_GLOBAL.RESP_ID(),
1857: when there is no valid user
1858: */
1859: /*IF (FND_GLOBAL.USER_ID() is null or
1860: FND_GLOBAL.USER_ID() < -1) THEN
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1864: FND_GLOBAL.RESP_ID(),
1865: FND_GLOBAL.RESP_APPL_ID());
1859: /*IF (FND_GLOBAL.USER_ID() is null or
1860: FND_GLOBAL.USER_ID() < -1) THEN
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1864: FND_GLOBAL.RESP_ID(),
1865: FND_GLOBAL.RESP_APPL_ID());
1866: END IF;
1867:
1860: FND_GLOBAL.USER_ID() < -1) THEN
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1864: FND_GLOBAL.RESP_ID(),
1865: FND_GLOBAL.RESP_APPL_ID());
1866: END IF;
1867:
1868: SELECT amw_debug_log_s.nextval INTO g_session_id FROM DUAL;
1861: FND_GLOBAL.APPS_INITIALIZE( 5, 20420, 1);
1862: ELSE
1863: FND_GLOBAL.APPS_INITIALIZE( FND_GLOBAL.USER_ID(),
1864: FND_GLOBAL.RESP_ID(),
1865: FND_GLOBAL.RESP_APPL_ID());
1866: END IF;
1867:
1868: SELECT amw_debug_log_s.nextval INTO g_session_id FROM DUAL;
1869: