APPS.XNP_MESSAGE dependencies on FND_GLOBAL

Line 13: g_new_line CONSTANT VARCHAR2(10) := convert(fnd_global.local_chr(10),

9: g_logdir VARCHAR2(100);
10: g_logdate DATE;
11: g_APPS_MAINTENANCE_MODE VARCHAR2(10);
12:
13: g_new_line CONSTANT VARCHAR2(10) := convert(fnd_global.local_chr(10),
14: substr(userenv('LANGUAGE'), instr(userenv('LANGUAGE'),'.') +1),
15: 'WE8ISO8859P1') ;
16:
17: PROCEDURE decode_xnp_msgs (

Line 588: fnd_global.user_id,

584: l_msg_header.wi_instance_id,
585: l_msg_header.fa_instance_id,
586: l_adapter_name,
587: empty_clob(),
588: fnd_global.user_id,
589: SYSDATE,
590: fnd_global.user_id,
591: SYSDATE )
592: RETURNING body_text INTO l_lob_loc ;

Line 590: fnd_global.user_id,

586: l_adapter_name,
587: empty_clob(),
588: fnd_global.user_id,
589: SYSDATE,
590: fnd_global.user_id,
591: SYSDATE )
592: RETURNING body_text INTO l_lob_loc ;
593:
594: IF xdp_utilities.g_message_list.COUNT > 0 THEN

Line 1221: ,FND_GLOBAL.USER_ID

1217: ,'MESSAGE' -- Always insert type to be 'Message' - even though it can be an event or a timer
1218: ,'VARCHAR2'
1219: ,'Y'
1220: ,'N'
1221: ,FND_GLOBAL.USER_ID
1222: ,SYSDATE
1223: ,FND_GLOBAL.USER_ID
1224: ,SYSDATE
1225: ,FND_GLOBAL.LOGIN_ID)

Line 1223: ,FND_GLOBAL.USER_ID

1219: ,'Y'
1220: ,'N'
1221: ,FND_GLOBAL.USER_ID
1222: ,SYSDATE
1223: ,FND_GLOBAL.USER_ID
1224: ,SYSDATE
1225: ,FND_GLOBAL.LOGIN_ID)
1226: RETURNING MSG_ELEMENT_ID INTO L_PARENT_ID;
1227:

Line 1225: ,FND_GLOBAL.LOGIN_ID)

1221: ,FND_GLOBAL.USER_ID
1222: ,SYSDATE
1223: ,FND_GLOBAL.USER_ID
1224: ,SYSDATE
1225: ,FND_GLOBAL.LOGIN_ID)
1226: RETURNING MSG_ELEMENT_ID INTO L_PARENT_ID;
1227:
1228: -- Inserting Message Name into Elements
1229:

Line 1254: ,FND_GLOBAL.USER_ID

1250: ,P_MSG_CODE
1251: ,'VARCHAR2'
1252: ,'Y'
1253: ,'N'
1254: ,FND_GLOBAL.USER_ID
1255: ,SYSDATE
1256: ,FND_GLOBAL.USER_ID
1257: ,SYSDATE
1258: ,FND_GLOBAL.LOGIN_ID

Line 1256: ,FND_GLOBAL.USER_ID

1252: ,'Y'
1253: ,'N'
1254: ,FND_GLOBAL.USER_ID
1255: ,SYSDATE
1256: ,FND_GLOBAL.USER_ID
1257: ,SYSDATE
1258: ,FND_GLOBAL.LOGIN_ID
1259: )
1260: RETURNING MSG_ELEMENT_ID INTO L_CHILD_ID;

Line 1258: ,FND_GLOBAL.LOGIN_ID

1254: ,FND_GLOBAL.USER_ID
1255: ,SYSDATE
1256: ,FND_GLOBAL.USER_ID
1257: ,SYSDATE
1258: ,FND_GLOBAL.LOGIN_ID
1259: )
1260: RETURNING MSG_ELEMENT_ID INTO L_CHILD_ID;
1261:
1262: -- Inserting Message Name into Structures with 'Message' as parent

Line 1284: ,FND_GLOBAL.USER_ID

1280: XNP_MSG_STRUCTURES_S.NEXTVAL
1281: ,L_PARENT_ID
1282: ,L_CHILD_ID
1283: ,P_MSG_CODE
1284: ,FND_GLOBAL.USER_ID
1285: ,SYSDATE
1286: ,FND_GLOBAL.USER_ID
1287: ,SYSDATE
1288: ,FND_GLOBAL.LOGIN_ID

Line 1286: ,FND_GLOBAL.USER_ID

1282: ,L_CHILD_ID
1283: ,P_MSG_CODE
1284: ,FND_GLOBAL.USER_ID
1285: ,SYSDATE
1286: ,FND_GLOBAL.USER_ID
1287: ,SYSDATE
1288: ,FND_GLOBAL.LOGIN_ID
1289: )
1290: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;

Line 1288: ,FND_GLOBAL.LOGIN_ID

1284: ,FND_GLOBAL.USER_ID
1285: ,SYSDATE
1286: ,FND_GLOBAL.USER_ID
1287: ,SYSDATE
1288: ,FND_GLOBAL.LOGIN_ID
1289: )
1290: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;
1291:
1292: IF P_MSG_TYPE = 'TIMER' THEN

Line 1322: ,FND_GLOBAL.USER_ID

1318: ,'NUMBER'
1319: ,'0'
1320: ,'Y'
1321: ,'N'
1322: ,FND_GLOBAL.USER_ID
1323: ,SYSDATE
1324: ,FND_GLOBAL.USER_ID
1325: ,SYSDATE
1326: ,FND_GLOBAL.LOGIN_ID

Line 1324: ,FND_GLOBAL.USER_ID

1320: ,'Y'
1321: ,'N'
1322: ,FND_GLOBAL.USER_ID
1323: ,SYSDATE
1324: ,FND_GLOBAL.USER_ID
1325: ,SYSDATE
1326: ,FND_GLOBAL.LOGIN_ID
1327: )
1328: RETURNING MSG_ELEMENT_ID INTO L_GRANDCHILD_ID;

Line 1326: ,FND_GLOBAL.LOGIN_ID

1322: ,FND_GLOBAL.USER_ID
1323: ,SYSDATE
1324: ,FND_GLOBAL.USER_ID
1325: ,SYSDATE
1326: ,FND_GLOBAL.LOGIN_ID
1327: )
1328: RETURNING MSG_ELEMENT_ID INTO L_GRANDCHILD_ID;
1329:
1330: -- Inserting Delay into Structures with Message Name as parent

Line 1351: ,FND_GLOBAL.USER_ID

1347: XNP_MSG_STRUCTURES_S.NEXTVAL
1348: ,L_CHILD_ID
1349: ,L_GRANDCHILD_ID
1350: ,P_MSG_CODE
1351: ,FND_GLOBAL.USER_ID
1352: ,SYSDATE
1353: ,FND_GLOBAL.USER_ID
1354: ,SYSDATE
1355: ,FND_GLOBAL.LOGIN_ID

Line 1353: ,FND_GLOBAL.USER_ID

1349: ,L_GRANDCHILD_ID
1350: ,P_MSG_CODE
1351: ,FND_GLOBAL.USER_ID
1352: ,SYSDATE
1353: ,FND_GLOBAL.USER_ID
1354: ,SYSDATE
1355: ,FND_GLOBAL.LOGIN_ID
1356: )
1357: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;

Line 1355: ,FND_GLOBAL.LOGIN_ID

1351: ,FND_GLOBAL.USER_ID
1352: ,SYSDATE
1353: ,FND_GLOBAL.USER_ID
1354: ,SYSDATE
1355: ,FND_GLOBAL.LOGIN_ID
1356: )
1357: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;
1358:
1359: -- Inserting Interval into Elements

Line 1387: ,FND_GLOBAL.USER_ID

1383: ,'NUMBER'
1384: ,'0'
1385: ,'Y'
1386: ,'N'
1387: ,FND_GLOBAL.USER_ID
1388: ,SYSDATE
1389: ,FND_GLOBAL.USER_ID
1390: ,SYSDATE
1391: ,FND_GLOBAL.LOGIN_ID

Line 1389: ,FND_GLOBAL.USER_ID

1385: ,'Y'
1386: ,'N'
1387: ,FND_GLOBAL.USER_ID
1388: ,SYSDATE
1389: ,FND_GLOBAL.USER_ID
1390: ,SYSDATE
1391: ,FND_GLOBAL.LOGIN_ID
1392: )
1393: RETURNING MSG_ELEMENT_ID INTO L_GRANDCHILD_ID;

Line 1391: ,FND_GLOBAL.LOGIN_ID

1387: ,FND_GLOBAL.USER_ID
1388: ,SYSDATE
1389: ,FND_GLOBAL.USER_ID
1390: ,SYSDATE
1391: ,FND_GLOBAL.LOGIN_ID
1392: )
1393: RETURNING MSG_ELEMENT_ID INTO L_GRANDCHILD_ID;
1394:
1395: -- Inserting Interval into Structures with Message Name as parent

Line 1416: ,FND_GLOBAL.USER_ID

1412: XNP_MSG_STRUCTURES_S.NEXTVAL
1413: ,L_CHILD_ID
1414: ,L_GRANDCHILD_ID
1415: ,P_MSG_CODE
1416: ,FND_GLOBAL.USER_ID
1417: ,SYSDATE
1418: ,FND_GLOBAL.USER_ID
1419: ,SYSDATE
1420: ,FND_GLOBAL.LOGIN_ID

Line 1418: ,FND_GLOBAL.USER_ID

1414: ,L_GRANDCHILD_ID
1415: ,P_MSG_CODE
1416: ,FND_GLOBAL.USER_ID
1417: ,SYSDATE
1418: ,FND_GLOBAL.USER_ID
1419: ,SYSDATE
1420: ,FND_GLOBAL.LOGIN_ID
1421: )
1422: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;

Line 1420: ,FND_GLOBAL.LOGIN_ID

1416: ,FND_GLOBAL.USER_ID
1417: ,SYSDATE
1418: ,FND_GLOBAL.USER_ID
1419: ,SYSDATE
1420: ,FND_GLOBAL.LOGIN_ID
1421: )
1422: RETURNING STRUCTURE_ID INTO L_STRUCTURE_ID;
1423:
1424: END IF; -- IF TIMER