DBA Data[Home] [Help]

APPS.ZPB_EXCEPTION_ALERT dependencies on FND_MESSAGE

Line 115: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');

111: value := v_tskparams.value;
112:
113: if value is not NULL then
114: -- Selection label
115: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');
116: l_label := FND_MESSAGE.GET;
117: value := l_label || value;
118:
119: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 116: l_label := FND_MESSAGE.GET;

112:
113: if value is not NULL then
114: -- Selection label
115: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');
116: l_label := FND_MESSAGE.GET;
117: value := l_label || value;
118:
119: wf_engine.SetItemAttrText(Itemtype => ItemType,
120: Itemkey => NEWItemKey,

Line 647: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_WF_ERREXCPRUN');

643: exception
644:
645: when others then
646: -- Encountered error when running exception request
647: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_WF_ERREXCPRUN');
648: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
649:
650: retcode :='2';
651: errbuf:=substr(sqlerrm, 1, 255);

Line 648: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

644:
645: when others then
646: -- Encountered error when running exception request
647: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_WF_ERREXCPRUN');
648: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
649:
650: retcode :='2';
651: errbuf:=substr(sqlerrm, 1, 255);
652:

Line 694: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');

690: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
691:
692: -- Following ZPB_WF_DIMNAME members have an alert
693:
694: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
695: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
696: l_label := FND_MESSAGE.GET;
697:
698:

Line 695: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);

691:
692: -- Following ZPB_WF_DIMNAME members have an alert
693:
694: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
695: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
696: l_label := FND_MESSAGE.GET;
697:
698:
699: -- put label in WF resource?

Line 696: l_label := FND_MESSAGE.GET;

692: -- Following ZPB_WF_DIMNAME members have an alert
693:
694: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
695: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
696: l_label := FND_MESSAGE.GET;
697:
698:
699: -- put label in WF resource?
700: document := document|| htf.tableOpen(cattributes=>'width=100%');

Line 1009: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

1005: from wf_users
1006: where name = thisOwner;
1007:
1008: -- add (And Shadows) display to role dispaly name
1009: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1010: l_label := FND_MESSAGE.GET;
1011: NewDispName := NewDispName || l_label;
1012:
1013: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 1010: l_label := FND_MESSAGE.GET;

1006: where name = thisOwner;
1007:
1008: -- add (And Shadows) display to role dispaly name
1009: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1010: l_label := FND_MESSAGE.GET;
1011: NewDispName := NewDispName || l_label;
1012:
1013: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1014: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisOwner);

Line 1039: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

1035: from wf_users
1036: where name = thisApprover;
1037:
1038: -- add (And Shadows) display to role dispaly name
1039: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1040: l_label := FND_MESSAGE.GET;
1041: NewDispName := NewDispName || l_label;
1042:
1043: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 1040: l_label := FND_MESSAGE.GET;

1036: where name = thisApprover;
1037:
1038: -- add (And Shadows) display to role dispaly name
1039: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1040: l_label := FND_MESSAGE.GET;
1041: NewDispName := NewDispName || l_label;
1042:
1043: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1044: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisApprover);

Line 1201: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');

1197: from ZPB_TASK_PARAMETERS
1198: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
1199:
1200: -- Following ZPB_WF_DIMNAME members have an alert
1201: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
1202: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
1203: l_label := FND_MESSAGE.GET;
1204:
1205:

Line 1202: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);

1198: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
1199:
1200: -- Following ZPB_WF_DIMNAME members have an alert
1201: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
1202: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
1203: l_label := FND_MESSAGE.GET;
1204:
1205:
1206: -- put label in WF resource?

Line 1203: l_label := FND_MESSAGE.GET;

1199:
1200: -- Following ZPB_WF_DIMNAME members have an alert
1201: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
1202: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
1203: l_label := FND_MESSAGE.GET;
1204:
1205:
1206: -- put label in WF resource?
1207: document := document|| htf.tableOpen(cattributes=>'width=100%');

Line 1459: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_NOTES');

1455: aname => 'REGISTER6');
1456:
1457:
1458: -- Notes:
1459: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_NOTES');
1460: l_label := FND_MESSAGE.GET;
1461:
1462: -- Exception results
1463: if reg1 is not NULL then

Line 1460: l_label := FND_MESSAGE.GET;

1456:
1457:
1458: -- Notes:
1459: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_NOTES');
1460: l_label := FND_MESSAGE.GET;
1461:
1462: -- Exception results
1463: if reg1 is not NULL then
1464: document := document|| htf.tableRowOpen;

Line 1688: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

1684: from wf_users
1685: where name = thisRecipient;
1686:
1687: -- add (And Shadows) display to role dispaly name
1688: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1689: l_label := FND_MESSAGE.GET;
1690: NewDispName := NewDispName || l_label;
1691:
1692: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 1689: l_label := FND_MESSAGE.GET;

1685: where name = thisRecipient;
1686:
1687: -- add (And Shadows) display to role dispaly name
1688: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1689: l_label := FND_MESSAGE.GET;
1690: NewDispName := NewDispName || l_label;
1691:
1692: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1693: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);

Line 1717: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

1713: from wf_users
1714: where name = thisApprover;
1715:
1716: -- add (And Shadows) display to role dispaly name
1717: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1718: l_label := FND_MESSAGE.GET;
1719: NewDispName := NewDispName || l_label;
1720:
1721: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 1718: l_label := FND_MESSAGE.GET;

1714: where name = thisApprover;
1715:
1716: -- add (And Shadows) display to role dispaly name
1717: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1718: l_label := FND_MESSAGE.GET;
1719: NewDispName := NewDispName || l_label;
1720:
1721: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1722: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisApprover);

Line 1921: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');

1917:
1918:
1919: if value is not NULL then
1920: -- Selection label
1921: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');
1922: l_label := FND_MESSAGE.GET;
1923: value := l_label || value;
1924:
1925: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 1922: l_label := FND_MESSAGE.GET;

1918:
1919: if value is not NULL then
1920: -- Selection label
1921: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');
1922: l_label := FND_MESSAGE.GET;
1923: value := l_label || value;
1924:
1925: wf_engine.SetItemAttrText(Itemtype => ItemType,
1926: Itemkey => ItemKey,

Line 1981: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_EXPLAINERS');

1977:
1978: ItemType := 'EPBCYCLE';
1979: ItemKey := document_id;
1980: -- Explanations not received from:
1981: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_EXPLAINERS');
1982: l_label := FND_MESSAGE.GET;
1983:
1984: --pool1
1985: l_ctr := 0;

Line 1982: l_label := FND_MESSAGE.GET;

1978: ItemType := 'EPBCYCLE';
1979: ItemKey := document_id;
1980: -- Explanations not received from:
1981: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_EXPLAINERS');
1982: l_label := FND_MESSAGE.GET;
1983:
1984: --pool1
1985: l_ctr := 0;
1986: for v_exChild in c_exceptionPool loop

Line 2030: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_APPROVERS');

2026:
2027:
2028: --pool2
2029: -- Approvals not received from:
2030: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_APPROVERS');
2031: l_label := FND_MESSAGE.GET;
2032:
2033: l_ctr := 0;
2034: for v_exChild in c_exceptionPool loop

Line 2031: l_label := FND_MESSAGE.GET;

2027:
2028: --pool2
2029: -- Approvals not received from:
2030: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_APPROVERS');
2031: l_label := FND_MESSAGE.GET;
2032:
2033: l_ctr := 0;
2034: for v_exChild in c_exceptionPool loop
2035: -- b5102962

Line 2281: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

2277: from wf_users
2278: where name = thisOwner;
2279:
2280: -- add (And Shadows) display to role dispaly name
2281: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2282: l_label := FND_MESSAGE.GET;
2283: NewDispName := NewDispName || l_label;
2284:
2285: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 2282: l_label := FND_MESSAGE.GET;

2278: where name = thisOwner;
2279:
2280: -- add (And Shadows) display to role dispaly name
2281: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2282: l_label := FND_MESSAGE.GET;
2283: NewDispName := NewDispName || l_label;
2284:
2285: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
2286: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisOwner);

Line 2308: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

2304: from wf_users
2305: where name = thisApprover;
2306:
2307: -- add (And Shadows) display to role dispaly name
2308: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2309: l_label := FND_MESSAGE.GET;
2310: NewDispName := NewDispName || l_label;
2311:
2312: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 2309: l_label := FND_MESSAGE.GET;

2305: where name = thisApprover;
2306:
2307: -- add (And Shadows) display to role dispaly name
2308: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2309: l_label := FND_MESSAGE.GET;
2310: NewDispName := NewDispName || l_label;
2311:
2312: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
2313: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisApprover);

Line 2545: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');

2541: from ZPB_TASK_PARAMETERS
2542: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
2543:
2544: -- Following ZPB_WF_DIMNAME members have an alert
2545: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
2546: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
2547: l_label := FND_MESSAGE.GET;
2548:
2549: -- put label in WF resource?

Line 2546: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);

2542: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
2543:
2544: -- Following ZPB_WF_DIMNAME members have an alert
2545: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
2546: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
2547: l_label := FND_MESSAGE.GET;
2548:
2549: -- put label in WF resource?
2550: document := document|| htf.tableOpen(cattributes=>'width=100%');

Line 2547: l_label := FND_MESSAGE.GET;

2543:
2544: -- Following ZPB_WF_DIMNAME members have an alert
2545: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');
2546: FND_MESSAGE.SET_TOKEN ('ZPB_WF_DIMNAME', l_dimname);
2547: l_label := FND_MESSAGE.GET;
2548:
2549: -- put label in WF resource?
2550: document := document|| htf.tableOpen(cattributes=>'width=100%');
2551: document := document|| htf.tableRowOpen;

Line 2713: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

2709: from wf_users
2710: where name = thisOwner;
2711:
2712: -- add (And Shadows) display to role dispaly name
2713: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2714: l_label := FND_MESSAGE.GET;
2715: NewDispName := NewDispName || l_label;
2716:
2717: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 2714: l_label := FND_MESSAGE.GET;

2710: where name = thisOwner;
2711:
2712: -- add (And Shadows) display to role dispaly name
2713: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2714: l_label := FND_MESSAGE.GET;
2715: NewDispName := NewDispName || l_label;
2716:
2717: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
2718: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisOwner);

Line 2923: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

2919: from wf_users
2920: where name = thisRecipient;
2921:
2922: -- add (And Shadows) display to role dispaly name
2923: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2924: l_label := FND_MESSAGE.GET;
2925: NewDispName := NewDispName || l_label;
2926:
2927: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 2924: l_label := FND_MESSAGE.GET;

2920: where name = thisRecipient;
2921:
2922: -- add (And Shadows) display to role dispaly name
2923: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2924: l_label := FND_MESSAGE.GET;
2925: NewDispName := NewDispName || l_label;
2926:
2927: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
2928: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);

Line 2952: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

2948: from wf_users
2949: where name = thisApprover;
2950:
2951: -- add (And Shadows) display to role dispaly name
2952: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2953: l_label := FND_MESSAGE.GET;
2954: NewDispName := NewDispName || l_label;
2955:
2956: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);

Line 2953: l_label := FND_MESSAGE.GET;

2949: where name = thisApprover;
2950:
2951: -- add (And Shadows) display to role dispaly name
2952: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
2953: l_label := FND_MESSAGE.GET;
2954: NewDispName := NewDispName || l_label;
2955:
2956: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
2957: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisApprover);