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_ALERT_PKG dependencies on FND_API

Line 10: -- fnd_api.g_ret_sts_success if successful

6: -- Create an Alert Action record. Action ID will be generated from
7: -- alr_actions_s and returned in x_action_id parameter.
8: --
9: -- Output variable: x_return_status will be
10: -- fnd_api.g_ret_sts_success if successful
11: -- fnd_api.g_ret_sts_error if error
12: --
13: PROCEDURE insert_alr_actions(
14: p_application_id NUMBER,

Line 11: -- fnd_api.g_ret_sts_error if error

7: -- alr_actions_s and returned in x_action_id parameter.
8: --
9: -- Output variable: x_return_status will be
10: -- fnd_api.g_ret_sts_success if successful
11: -- fnd_api.g_ret_sts_error if error
12: --
13: PROCEDURE insert_alr_actions(
14: p_application_id NUMBER,
15: p_name VARCHAR2,

Line 124: x_return_status := fnd_api.g_ret_sts_success;

120: p_last_updated_by,
121: p_last_update_login)
122: RETURNING action_id INTO x_action_id;
123:
124: x_return_status := fnd_api.g_ret_sts_success;
125:
126: EXCEPTION WHEN OTHERS THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128:

Line 127: x_return_status := fnd_api.g_ret_sts_error;

123:
124: x_return_status := fnd_api.g_ret_sts_success;
125:
126: EXCEPTION WHEN OTHERS THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128:
129: END insert_alr_actions;
130:
131:

Line 140: -- fnd_api.g_ret_sts_success if successful

136: -- it is null, then p_application_id + p_alert_id + p_name
137: -- will be used as key.
138: --
139: -- Output variable: x_return_status will be
140: -- fnd_api.g_ret_sts_success if successful
141: -- fnd_api.g_ret_sts_error if record is not found
142: --
143: PROCEDURE update_alr_actions(
144: p_rowid VARCHAR2,

Line 141: -- fnd_api.g_ret_sts_error if record is not found

137: -- will be used as key.
138: --
139: -- Output variable: x_return_status will be
140: -- fnd_api.g_ret_sts_success if successful
141: -- fnd_api.g_ret_sts_error if record is not found
142: --
143: PROCEDURE update_alr_actions(
144: p_rowid VARCHAR2,
145: p_application_id NUMBER,

Line 271: x_return_status := fnd_api.g_ret_sts_error;

267:
268: END IF; -- p_rowid
269:
270: IF (sql%notfound) THEN
271: x_return_status := fnd_api.g_ret_sts_error;
272: ELSE
273: x_return_status := fnd_api.g_ret_sts_success;
274: END IF;
275:

Line 273: x_return_status := fnd_api.g_ret_sts_success;

269:
270: IF (sql%notfound) THEN
271: x_return_status := fnd_api.g_ret_sts_error;
272: ELSE
273: x_return_status := fnd_api.g_ret_sts_success;
274: END IF;
275:
276: END update_alr_actions;
277:

Line 285: -- fnd_api.g_ret_sts_success if successful

281: -- Return the created action_set_id and sequence into
282: -- x_action_set_id and x_sequence params.
283: --
284: -- Output variable: x_return_status will be
285: -- fnd_api.g_ret_sts_success if successful
286: -- fnd_api.g_ret_sts_error if not
287: --
288: PROCEDURE insert_alr_action_sets(
289: p_application_id NUMBER,

Line 286: -- fnd_api.g_ret_sts_error if not

282: -- x_action_set_id and x_sequence params.
283: --
284: -- Output variable: x_return_status will be
285: -- fnd_api.g_ret_sts_success if successful
286: -- fnd_api.g_ret_sts_error if not
287: --
288: PROCEDURE insert_alr_action_sets(
289: p_application_id NUMBER,
290: p_alert_id NUMBER,

Line 354: x_return_status := fnd_api.g_ret_sts_success;

350: p_last_update_login)
351: RETURNING action_set_id INTO x_action_set_id;
352:
353: x_sequence := l_sequence;
354: x_return_status := fnd_api.g_ret_sts_success;
355:
356: EXCEPTION WHEN OTHERS THEN
357: x_return_status := fnd_api.g_ret_sts_error;
358:

Line 357: x_return_status := fnd_api.g_ret_sts_error;

353: x_sequence := l_sequence;
354: x_return_status := fnd_api.g_ret_sts_success;
355:
356: EXCEPTION WHEN OTHERS THEN
357: x_return_status := fnd_api.g_ret_sts_error;
358:
359: END insert_alr_action_sets;
360:
361:

Line 370: -- fnd_api.g_ret_sts_success if successful

366: -- Return the created action_set_member_id and sequence into
367: -- x_action_set_member_id and x_sequence params.
368: --
369: -- Output variable: x_return_status will be
370: -- fnd_api.g_ret_sts_success if successful
371: -- fnd_api.g_ret_sts_error if not
372: --
373: PROCEDURE insert_alr_action_set_members(
374: p_application_id NUMBER,

Line 371: -- fnd_api.g_ret_sts_error if not

367: -- x_action_set_member_id and x_sequence params.
368: --
369: -- Output variable: x_return_status will be
370: -- fnd_api.g_ret_sts_success if successful
371: -- fnd_api.g_ret_sts_error if not
372: --
373: PROCEDURE insert_alr_action_set_members(
374: p_application_id NUMBER,
375: p_action_set_id NUMBER,

Line 442: x_return_status := fnd_api.g_ret_sts_success;

438: p_last_update_login)
439: RETURNING action_set_member_id INTO x_action_set_member_id;
440:
441: x_sequence := l_sequence;
442: x_return_status := fnd_api.g_ret_sts_success;
443:
444: EXCEPTION WHEN OTHERS THEN
445: x_return_status := fnd_api.g_ret_sts_error;
446:

Line 445: x_return_status := fnd_api.g_ret_sts_error;

441: x_sequence := l_sequence;
442: x_return_status := fnd_api.g_ret_sts_success;
443:
444: EXCEPTION WHEN OTHERS THEN
445: x_return_status := fnd_api.g_ret_sts_error;
446:
447: END insert_alr_action_set_members;
448:
449:

Line 456: -- fnd_api.g_ret_sts_success if successful

452: --
453: -- Create an alr_action_set_outputs record.
454: --
455: -- Output variable: x_return_status will be
456: -- fnd_api.g_ret_sts_success if successful
457: -- fnd_api.g_ret_sts_error if not
458: --
459: PROCEDURE insert_alr_action_set_outputs(
460: p_application_id NUMBER,

Line 457: -- fnd_api.g_ret_sts_error if not

453: -- Create an alr_action_set_outputs record.
454: --
455: -- Output variable: x_return_status will be
456: -- fnd_api.g_ret_sts_success if successful
457: -- fnd_api.g_ret_sts_error if not
458: --
459: PROCEDURE insert_alr_action_set_outputs(
460: p_application_id NUMBER,
461: p_action_set_id NUMBER,

Line 501: x_return_status := fnd_api.g_ret_sts_success;

497: WHERE a.application_id = p_application_id AND
498: a.alert_id = p_alert_id AND
499: a.enabled_flag = 'Y';
500:
501: x_return_status := fnd_api.g_ret_sts_success;
502:
503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
505: -- allow no data found

Line 506: x_return_status := fnd_api.g_ret_sts_success;

502:
503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
505: -- allow no data found
506: x_return_status := fnd_api.g_ret_sts_success;
507:
508: WHEN OTHERS THEN
509: x_return_status := fnd_api.g_ret_sts_error;
510:

Line 509: x_return_status := fnd_api.g_ret_sts_error;

505: -- allow no data found
506: x_return_status := fnd_api.g_ret_sts_success;
507:
508: WHEN OTHERS THEN
509: x_return_status := fnd_api.g_ret_sts_error;
510:
511: END insert_alr_action_set_outputs;
512:
513:

Line 518: -- fnd_api.g_ret_sts_success if successful

514: --
515: -- Create an alr_action_set_inputs record.
516: --
517: -- Output variable: x_return_status will be
518: -- fnd_api.g_ret_sts_success if successful
519: -- fnd_api.g_ret_sts_error if not
520: --
521: PROCEDURE insert_alr_action_set_inputs(
522: p_application_id NUMBER,

Line 519: -- fnd_api.g_ret_sts_error if not

515: -- Create an alr_action_set_inputs record.
516: --
517: -- Output variable: x_return_status will be
518: -- fnd_api.g_ret_sts_success if successful
519: -- fnd_api.g_ret_sts_error if not
520: --
521: PROCEDURE insert_alr_action_set_inputs(
522: p_application_id NUMBER,
523: p_action_set_id NUMBER,

Line 561: x_return_status := fnd_api.g_ret_sts_success;

557: WHERE a.application_id = p_application_id AND
558: a.alert_id = p_alert_id AND
559: a.enabled_flag = 'Y';
560:
561: x_return_status := fnd_api.g_ret_sts_success;
562:
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: -- allow no data found

Line 566: x_return_status := fnd_api.g_ret_sts_success;

562:
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: -- allow no data found
566: x_return_status := fnd_api.g_ret_sts_success;
567:
568: WHEN OTHERS THEN
569: x_return_status := fnd_api.g_ret_sts_error;
570:

Line 569: x_return_status := fnd_api.g_ret_sts_error;

565: -- allow no data found
566: x_return_status := fnd_api.g_ret_sts_success;
567:
568: WHEN OTHERS THEN
569: x_return_status := fnd_api.g_ret_sts_error;
570:
571: END insert_alr_action_set_inputs;
572:
573: