195: BEGIN
196: SELECT 'HZ_PARTY:'||TO_CHAR(PARTY_ID)
197: INTO l_party_id
198: FROM EGO_USER_V
199: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202:
203: ERROR_HANDLER.Add_Error_Message(
270: FROM MTL_PARAMETERS
271: WHERE ORGANIZATION_ID = p_organization_id;
272:
273: l_token_table(1).TOKEN_NAME := 'USER_NAME';
274: l_token_table(1).TOKEN_VALUE := FND_GLOBAL.USER_NAME;
275: l_token_table(2).TOKEN_NAME := 'ITEM_NUMBER';
276: l_token_table(2).TOKEN_VALUE := l_item_number;
277: l_token_table(3).TOKEN_NAME := 'ORG_CODE';
278: l_token_table(3).TOKEN_VALUE := l_org_code;
2848: p_organization_id,
2849: p_change_id,
2850: p_change_line_id,
2851: 'CHANGE',
2852: FND_GLOBAL.user_id,
2853: SYSDATE,
2854: FND_GLOBAL.user_id,
2855: FND_GLOBAL.user_id,
2856: SYSDATE,
2850: p_change_line_id,
2851: 'CHANGE',
2852: FND_GLOBAL.user_id,
2853: SYSDATE,
2854: FND_GLOBAL.user_id,
2855: FND_GLOBAL.user_id,
2856: SYSDATE,
2857: P_ITEM_DESC,
2858: P_ITEM_NUM
2851: 'CHANGE',
2852: FND_GLOBAL.user_id,
2853: SYSDATE,
2854: FND_GLOBAL.user_id,
2855: FND_GLOBAL.user_id,
2856: SYSDATE,
2857: P_ITEM_DESC,
2858: P_ITEM_NUM
2859: );
2879: p_organization_id,
2880: p_change_id,
2881: p_change_line_id,
2882: 'CHANGE',
2883: FND_GLOBAL.user_id,
2884: SYSDATE,
2885: FND_GLOBAL.user_id,
2886: FND_GLOBAL.user_id,
2887: SYSDATE,
2881: p_change_line_id,
2882: 'CHANGE',
2883: FND_GLOBAL.user_id,
2884: SYSDATE,
2885: FND_GLOBAL.user_id,
2886: FND_GLOBAL.user_id,
2887: SYSDATE,
2888: LANG_CODE.LANGUAGE_CODE,
2889: USERENV('LANG')
2882: 'CHANGE',
2883: FND_GLOBAL.user_id,
2884: SYSDATE,
2885: FND_GLOBAL.user_id,
2886: FND_GLOBAL.user_id,
2887: SYSDATE,
2888: LANG_CODE.LANGUAGE_CODE,
2889: USERENV('LANG')
2890: );