668: FROM sys.dual;
669:
670: l_progress := '004';
671: --Get User ID and Login ID
672: l_user_id := FND_GLOBAL.USER_ID;
673: IF (FND_GLOBAL.CONC_LOGIN_ID >= 0) THEN
674: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
675: ELSE
676: l_login_id := FND_GLOBAL.LOGIN_ID;
669:
670: l_progress := '004';
671: --Get User ID and Login ID
672: l_user_id := FND_GLOBAL.USER_ID;
673: IF (FND_GLOBAL.CONC_LOGIN_ID >= 0) THEN
674: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
675: ELSE
676: l_login_id := FND_GLOBAL.LOGIN_ID;
677: END IF;
670: l_progress := '004';
671: --Get User ID and Login ID
672: l_user_id := FND_GLOBAL.USER_ID;
673: IF (FND_GLOBAL.CONC_LOGIN_ID >= 0) THEN
674: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
675: ELSE
676: l_login_id := FND_GLOBAL.LOGIN_ID;
677: END IF;
678:
672: l_user_id := FND_GLOBAL.USER_ID;
673: IF (FND_GLOBAL.CONC_LOGIN_ID >= 0) THEN
674: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
675: ELSE
676: l_login_id := FND_GLOBAL.LOGIN_ID;
677: END IF;
678:
679: IF g_debug_stmt THEN
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1504:
1505: l_progress := '004';
1506:
1507: --Get User ID and Login ID
1508: l_user_id := FND_GLOBAL.USER_ID;
1509:
1510: IF ( FND_GLOBAL.CONC_LOGIN_ID >= 0 )
1511: THEN
1512: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1506:
1507: --Get User ID and Login ID
1508: l_user_id := FND_GLOBAL.USER_ID;
1509:
1510: IF ( FND_GLOBAL.CONC_LOGIN_ID >= 0 )
1511: THEN
1512: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1513: ELSE
1514: l_login_id := FND_GLOBAL.LOGIN_ID;
1508: l_user_id := FND_GLOBAL.USER_ID;
1509:
1510: IF ( FND_GLOBAL.CONC_LOGIN_ID >= 0 )
1511: THEN
1512: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1513: ELSE
1514: l_login_id := FND_GLOBAL.LOGIN_ID;
1515: END IF;
1516:
1510: IF ( FND_GLOBAL.CONC_LOGIN_ID >= 0 )
1511: THEN
1512: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1513: ELSE
1514: l_login_id := FND_GLOBAL.LOGIN_ID;
1515: END IF;
1516:
1517: IF g_debug_stmt THEN
1518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN