eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SS_IMPORT_WF dependencies on WF_NOTIFICATION

Line 175: x_nid_user := wf_notification.send

171: x_buyer_name;
172:
173: WHILE qri%found LOOP
174:
175: x_nid_user := wf_notification.send
176: (x_user_name,
177: itemtype ,
178: 'FAILURE_DETECTED_TO_USER');
179: set_message_attr(x_nid_user);

Line 180: x_nid_supervisor := wf_notification.send

176: (x_user_name,
177: itemtype ,
178: 'FAILURE_DETECTED_TO_USER');
179: set_message_attr(x_nid_user);
180: x_nid_supervisor := wf_notification.send
181: (x_last_updated_name,
182: itemtype,
183: 'FAILURE_DETECTED_TO_SUPERVISOR');
184: set_message_attr(x_nid_supervisor);

Line 187: x_nid_buyer := wf_notification.send

183: 'FAILURE_DETECTED_TO_SUPERVISOR');
184: set_message_attr(x_nid_supervisor);
185:
186: IF x_buyer_name IS NOT NULL THEN
187: x_nid_buyer := wf_notification.send
188: (x_buyer_name,
189: itemtype,
190: 'FAILURE_DETECTED_TO_BUYER');
191: set_message_attr(x_nid_buyer);

Line 216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);

212: --
213:
214: PROCEDURE set_message_attr(id IN NUMBER) IS
215: BEGIN
216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);
217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);

Line 217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);

213:
214: PROCEDURE set_message_attr(id IN NUMBER) IS
215: BEGIN
216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);
217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);

Line 218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);

214: PROCEDURE set_message_attr(id IN NUMBER) IS
215: BEGIN
216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);
217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);
222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);

Line 219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);

215: BEGIN
216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);
217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);
222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);
223: END set_message_attr;

Line 220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);

216: wf_notification.setattrdate(id, 'CREATION_DATE', x_creation_date);
217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);
222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);
223: END set_message_attr;
224:

Line 221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);

217: wf_notification.setattrtext(id, 'PLAN_NAME', x_plan_name);
218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);
222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);
223: END set_message_attr;
224:
225:

Line 222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);

218: wf_notification.setattrnumber(id, 'ERROR_ROWS', x_error_rows);
219: wf_notification.setattrtext(id, 'USER_NAME', x_user_name);
220: wf_notification.setattrtext(id, 'BUYER_NAME', x_buyer_name);
221: wf_notification.setattrtext(id, 'ORGANIZATION_CODE', x_organization_code);
222: wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);
223: END set_message_attr;
224:
225:
226: --

Line 489: --sent using wf_notification.send

485:
486: --
487: --Its not enough if the item level attributes are set.
488: --We also have to set the message attributes, for each message
489: --sent using wf_notification.send
490: --
491:
492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);

Line 492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');

488: --We also have to set the message attributes, for each message
489: --sent using wf_notification.send
490: --
491:
492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);

Line 493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);

489: --sent using wf_notification.send
490: --
491:
492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);

Line 494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);

490: --
491:
492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);

Line 495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);

491:
492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);

Line 496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);

492: x_nid := wf_notification.send(x_buyer_name, itemtype, 'RESULTS_SAVED_TO_BUYER');
493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);

Line 497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);

493: wf_notification.setattrtext(x_nid, 'BUYER_NAME', x_buyer_name);
494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);

Line 498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);

494: wf_notification.setattrtext(x_nid, 'PLAN_NAME', x_plan_name);
495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);

Line 499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);

495: wf_notification.setattrtext(x_nid, 'USER_NAME', x_user_name);
496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);

Line 500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);

496: wf_notification.setattrtext(x_nid, 'ITEM', x_item);
497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);

Line 501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);

497: wf_notification.setattrtext(x_nid, 'SUPPLIER_NAME', x_supplier_name);
498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);
505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);

Line 502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);

498: wf_notification.setattrtext(x_nid, 'CONTACT_NAME', x_contact_name);
499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);
505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);
506:

Line 503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);

499: wf_notification.setattrtext(x_nid, 'CONTACT_PHONE', x_contact_phone);
500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);
505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);
506:
507: END IF;

Line 504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);

500: wf_notification.setattrtext(x_nid, 'PO_NUMBER', x_po_number);
501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);
505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);
506:
507: END IF;
508:

Line 505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);

501: wf_notification.setattrnumber(x_nid, 'ORGANIZATION_ID', x_org_id);
502: wf_notification.setattrtext(x_nid, 'ORGANIZATION_CODE', x_org_code);
503: wf_notification.setattrtext(x_nid, 'ORGANIZATION_NAME', x_org_name);
504: wf_notification.setattrtext(x_nid, 'OPEN_CIMDF_COMMAND', x_cimdf);
505: wf_notification.setattrtext(x_nid, 'OPEN_RSINF_COMMAND', x_rsinf);
506:
507: END IF;
508:
509: END send;