DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on FND_NEW_MESSAGES

Line 189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;

185: WHERE wlr.orig_system_id = team.team_id
186: AND wlr.orig_system = l_team_orig_system
187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;

Line 190: log_message12 fnd_new_messages.message_text%type := NULL;

186: AND wlr.orig_system = l_team_orig_system
187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;

Line 191: log_message13 fnd_new_messages.message_text%type := NULL;

187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:

Line 192: log_message14 fnd_new_messages.message_text%type := NULL;

188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN

Line 193: log_message36 fnd_new_messages.message_text%type := NULL;

189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN
197:

Line 194: log_message37 fnd_new_messages.message_text%type := NULL;

190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN
197:
198: log_msg_hdr4 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR4');

Line 542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;

538: WHERE wlr.orig_system = l_grp_orig_system
539: AND wlr.orig_system_id = grp.group_id
540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;

Line 543: log_message1 fnd_new_messages.message_text%type := NULL;

539: AND wlr.orig_system_id = grp.group_id
540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;

Line 544: log_message2 fnd_new_messages.message_text%type := NULL;

540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:

Line 545: log_message3 fnd_new_messages.message_text%type := NULL;

541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN

Line 546: log_message38 fnd_new_messages.message_text%type := NULL;

542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN
550:

Line 547: log_message39 fnd_new_messages.message_text%type := NULL;

543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN
550:
551: log_msg_hdr1 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR1');

Line 840: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;

836: l_display_name wf_local_roles.display_name%TYPE;
837: l_email_address wf_local_roles.email_address%TYPE;
838: l_expiration_date wf_local_roles.expiration_date%TYPE;
839:
840: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
841: log_message40 fnd_new_messages.message_text%type := NULL;
842:
843: BEGIN
844:

Line 841: log_message40 fnd_new_messages.message_text%type := NULL;

837: l_email_address wf_local_roles.email_address%TYPE;
838: l_expiration_date wf_local_roles.expiration_date%TYPE;
839:
840: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
841: log_message40 fnd_new_messages.message_text%type := NULL;
842:
843: BEGIN
844:
845: log_msg_hdr2 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR2');

Line 1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;

1190: AND wlur.user_orig_system = l_hz_orig_system
1191: AND wlur.role_orig_system = l_grp_orig_system);
1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;

Line 1195: log_message8 fnd_new_messages.message_text%type := NULL;

1191: AND wlur.role_orig_system = l_grp_orig_system);
1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:

Line 1196: log_message9 fnd_new_messages.message_text%type := NULL;

1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;

Line 1197: log_message10 fnd_new_messages.message_text%type := NULL;

1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;

Line 1198: log_message11 fnd_new_messages.message_text%type := NULL;

1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;

Line 1200: log_message19 fnd_new_messages.message_text%type := NULL;

1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;

Line 1201: log_message20 fnd_new_messages.message_text%type := NULL;

1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;

Line 1202: log_message21 fnd_new_messages.message_text%type := NULL;

1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:

Line 1204: log_message30 fnd_new_messages.message_text%type := NULL;

1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:
1207: l_end_date_active DATE;
1208: m_end_date_active DATE;

Line 1205: log_message31 fnd_new_messages.message_text%type := NULL;

1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:
1207: l_end_date_active DATE;
1208: m_end_date_active DATE;
1209: m_start_date_active DATE;

Line 1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;

1492: AND wlur.role_orig_system_id = mem.team_id
1493: AND wlur.role_orig_system = l_team_orig_system);
1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;

Line 1497: log_message15 fnd_new_messages.message_text%type := NULL;

1493: AND wlur.role_orig_system = l_team_orig_system);
1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:

Line 1498: log_message16 fnd_new_messages.message_text%type := NULL;

1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;

Line 1499: log_message17 fnd_new_messages.message_text%type := NULL;

1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;

Line 1500: log_message18 fnd_new_messages.message_text%type := NULL;

1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;

Line 1502: log_message22 fnd_new_messages.message_text%type := NULL;

1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:

Line 1503: log_message23 fnd_new_messages.message_text%type := NULL;

1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;

Line 1504: log_message24 fnd_new_messages.message_text%type := NULL;

1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;

Line 1505: log_message25 fnd_new_messages.message_text%type := NULL;

1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;

Line 1507: log_message32 fnd_new_messages.message_text%type := NULL;

1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:

Line 1508: log_message33 fnd_new_messages.message_text%type := NULL;

1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;

Line 1509: log_message34 fnd_new_messages.message_text%type := NULL;

1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;
1513: m_end_date_active DATE;

Line 1510: log_message35 fnd_new_messages.message_text%type := NULL;

1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;
1513: m_end_date_active DATE;
1514: m_start_date_active DATE;