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.IGS_AS_DOC_DETAILS_PKG dependencies on FND_MSG_PUB

Line 303: fnd_msg_pub.ADD;

299: AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))
300: ) THEN
301: CLOSE cur_old_ref_values;
302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
303: fnd_msg_pub.ADD;
304: RAISE fnd_api.g_exc_error;
305: END IF;
306: CLOSE cur_old_ref_values;
307: -- Populate New Values.

Line 454: FND_MSG_PUB.ADD;

450: /* ELSIF NOT igs_as_doc_dlvy_typ_pkg.get_pk_For_validation (
451: new_references.delivery_method_type
452: ) THEN
453: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
454: FND_MSG_PUB.ADD;
455: RAISE FND_API.G_EXC_ERROR;*/
456: END IF;
457: IF (((old_references.fgrade_cal_type = new_references.fgrade_cal_type)
458: AND (old_references.fgrade_seq_num = new_references.fgrade_seq_num)

Line 467: fnd_msg_pub.ADD;

463: ) THEN
464: NULL;
465: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (new_references.fgrade_cal_type, new_references.fgrade_seq_num) THEN
466: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_error;
469: END IF;
470: IF (((old_references.deghold_cal_type = new_references.deghold_cal_type)
471: AND (old_references.deghold_seq_num = new_references.deghold_seq_num)

Line 480: fnd_msg_pub.ADD;

476: ) THEN
477: NULL;
478: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (new_references.deghold_cal_type, new_references.deghold_seq_num) THEN
479: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
480: fnd_msg_pub.ADD;
481: RAISE fnd_api.g_exc_error;
482: END IF;
483: IF (((old_references.order_number = new_references.order_number))
484: OR ((new_references.order_number IS NULL))

Line 489: fnd_msg_pub.ADD;

485: ) THEN
486: NULL;
487: ELSIF NOT igs_as_order_hdr_pkg.get_pk_for_validation (new_references.order_number) THEN
488: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
489: fnd_msg_pub.ADD;
490: RAISE fnd_api.g_exc_error;
491: END IF;
492: END check_parent_existance;
493: --

Line 546: fnd_msg_pub.ADD;

542: FETCH cur_rowid INTO lv_rowid;
543: IF (cur_rowid%FOUND) THEN
544: CLOSE cur_rowid;
545: fnd_message.set_name ('IGS', 'IGS_AS_TIINFO_TDELY_FK');
546: fnd_msg_pub.ADD;
547: RAISE fnd_api.g_exc_error;
548: RETURN;
549: END IF;
550: CLOSE cur_rowid;

Line 581: fnd_msg_pub.ADD;

577: FETCH cur_rowid INTO lv_rowid;
578: IF (cur_rowid%FOUND) THEN
579: CLOSE cur_rowid;
580: fnd_message.set_name ('IGS', 'IGS_AS_TIINFO_CA_FK');
581: fnd_msg_pub.ADD;
582: RAISE fnd_api.g_exc_error;
583: RETURN;
584: END IF;
585: CLOSE cur_rowid;

Line 611: fnd_msg_pub.ADD;

607: FETCH cur_rowid INTO lv_rowid;
608: IF (cur_rowid%FOUND) THEN
609: CLOSE cur_rowid;
610: fnd_message.set_name ('IGS', 'IGS_AS_TIINFO_ORDHDR_FK');
611: fnd_msg_pub.ADD;
612: RAISE fnd_api.g_exc_error;
613: RETURN;
614: END IF;
615: CLOSE cur_rowid;

Line 930: fnd_msg_pub.ADD;

926: IF (p_action = 'INSERT') THEN
927: -- Call all the procedures related to Before Insert.
928: IF (get_pk_for_validation (new_references.item_number)) THEN
929: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;
932: END IF;
933: check_parent_existance;
934: ELSIF (p_action = 'UPDATE') THEN

Line 941: fnd_msg_pub.ADD;

937: ELSIF (p_action = 'VALIDATE_INSERT') THEN
938: -- Call all the procedures related to Before Insert.
939: IF (get_pk_for_validation (new_references.item_number)) THEN
940: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
941: fnd_msg_pub.ADD;
942: RAISE fnd_api.g_exc_error;
943: END IF;
944: END IF;
945: END before_dml;

Line 1097: fnd_msg_pub.initialize;

1093: x_program_id NUMBER;
1094: x_program_application_id NUMBER;
1095: x_program_update_date DATE;
1096: BEGIN
1097: fnd_msg_pub.initialize;
1098: x_last_update_date := SYSDATE;
1099: IF (x_mode = 'I') THEN
1100: x_last_updated_by := 1;
1101: x_last_update_login := 0;

Line 1124: fnd_msg_pub.ADD;

1120: x_program_update_date := SYSDATE;
1121: END IF;
1122: ELSE
1123: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1124: fnd_msg_pub.ADD;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;
1127: IF x_item_number IS NULL THEN
1128: SELECT igs_as_doc_details_s.NEXTVAL

Line 1384: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1380: END IF;
1381: -- Initialize API return status to success.
1382: x_return_status := fnd_api.g_ret_sts_success;
1383: -- Standard call to get message count and if count is 1, get message info
1384: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1385: EXCEPTION
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1388: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1384: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1385: EXCEPTION
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1389: RETURN;
1390: WHEN fnd_api.g_exc_unexpected_error THEN
1391: x_return_status := fnd_api.g_ret_sts_unexp_error;
1392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1388: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1389: RETURN;
1390: WHEN fnd_api.g_exc_unexpected_error THEN
1391: x_return_status := fnd_api.g_ret_sts_unexp_error;
1392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1393: RETURN;
1394: WHEN OTHERS THEN
1395: x_return_status := fnd_api.g_ret_sts_unexp_error;
1396: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 1398: fnd_msg_pub.ADD;

1394: WHEN OTHERS THEN
1395: x_return_status := fnd_api.g_ret_sts_unexp_error;
1396: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1397: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
1398: fnd_msg_pub.ADD;
1399: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1400: RETURN;
1401: END insert_row;
1402: --

Line 1399: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1395: x_return_status := fnd_api.g_ret_sts_unexp_error;
1396: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1397: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
1398: fnd_msg_pub.ADD;
1399: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1400: RETURN;
1401: END insert_row;
1402: --
1403: --

Line 1651: fnd_msg_pub.initialize;

1647: WHERE ROWID = x_rowid
1648: FOR UPDATE NOWAIT;
1649: tlinfo c1%ROWTYPE;
1650: BEGIN
1651: fnd_msg_pub.initialize;
1652: OPEN c1;
1653: FETCH c1 INTO tlinfo;
1654: IF (c1%NOTFOUND) THEN
1655: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 1657: fnd_msg_pub.ADD;

1653: FETCH c1 INTO tlinfo;
1654: IF (c1%NOTFOUND) THEN
1655: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1656: CLOSE c1;
1657: fnd_msg_pub.ADD;
1658: RAISE fnd_api.g_exc_error;
1659: RETURN;
1660: END IF;
1661: CLOSE c1;

Line 2198: fnd_msg_pub.ADD;

2194: ) THEN
2195: NULL;
2196: ELSE
2197: fnd_message.set_name ('FND', '*' || x_rowid || '*');
2198: fnd_msg_pub.ADD;
2199: RAISE fnd_api.g_exc_error;
2200: END IF;
2201: -- Initialize API return status to success.
2202: x_return_status := fnd_api.g_ret_sts_success;

Line 2204: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2200: END IF;
2201: -- Initialize API return status to success.
2202: x_return_status := fnd_api.g_ret_sts_success;
2203: -- Standard call to get message count and if count is 1, get message info
2204: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2205: EXCEPTION
2206: WHEN fnd_api.g_exc_error THEN
2207: x_return_status := fnd_api.g_ret_sts_error;
2208: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2208: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2204: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2205: EXCEPTION
2206: WHEN fnd_api.g_exc_error THEN
2207: x_return_status := fnd_api.g_ret_sts_error;
2208: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2209: RETURN;
2210: WHEN fnd_api.g_exc_unexpected_error THEN
2211: x_return_status := fnd_api.g_ret_sts_unexp_error;
2212: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2212: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2208: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2209: RETURN;
2210: WHEN fnd_api.g_exc_unexpected_error THEN
2211: x_return_status := fnd_api.g_ret_sts_unexp_error;
2212: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: RETURN;
2214: WHEN OTHERS THEN
2215: x_return_status := fnd_api.g_ret_sts_unexp_error;
2216: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2218: fnd_msg_pub.ADD;

2214: WHEN OTHERS THEN
2215: x_return_status := fnd_api.g_ret_sts_unexp_error;
2216: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2217: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2218: fnd_msg_pub.ADD;
2219: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2220: RETURN;
2221: END lock_row;
2222: --

Line 2219: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2215: x_return_status := fnd_api.g_ret_sts_unexp_error;
2216: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2217: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2218: fnd_msg_pub.ADD;
2219: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2220: RETURN;
2221: END lock_row;
2222: --
2223: --

Line 2362: fnd_msg_pub.initialize;

2358: x_program_id NUMBER;
2359: x_program_application_id NUMBER;
2360: x_program_update_date DATE;
2361: BEGIN
2362: fnd_msg_pub.initialize;
2363: x_last_update_date := SYSDATE;
2364: IF (x_mode = 'I') THEN
2365: x_last_updated_by := 1;
2366: x_last_update_login := 0;

Line 2378: fnd_msg_pub.ADD;

2374: x_last_update_login := -1;
2375: END IF;
2376: ELSE
2377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
2378: fnd_msg_pub.ADD;
2379: RAISE fnd_api.g_exc_error;
2380: END IF;
2381: before_dml (
2382: p_action => 'UPDATE',

Line 2794: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2790: END IF;
2791: -- Initialize API return status to success.
2792: x_return_status := fnd_api.g_ret_sts_success;
2793: -- Standard call to get message count and if count is 1, get message info
2794: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2795: EXCEPTION
2796: WHEN fnd_api.g_exc_error THEN
2797: x_return_status := fnd_api.g_ret_sts_error;
2798: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2798: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2794: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2795: EXCEPTION
2796: WHEN fnd_api.g_exc_error THEN
2797: x_return_status := fnd_api.g_ret_sts_error;
2798: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2799: RETURN;
2800: WHEN fnd_api.g_exc_unexpected_error THEN
2801: x_return_status := fnd_api.g_ret_sts_unexp_error;
2802: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2802: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2798: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2799: RETURN;
2800: WHEN fnd_api.g_exc_unexpected_error THEN
2801: x_return_status := fnd_api.g_ret_sts_unexp_error;
2802: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2803: RETURN;
2804: WHEN OTHERS THEN
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2808: fnd_msg_pub.ADD;

2804: WHEN OTHERS THEN
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2807: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2808: fnd_msg_pub.ADD;
2809: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2810: RETURN;
2811: END update_row;
2812: --

Line 2809: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2807: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2808: fnd_msg_pub.ADD;
2809: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2810: RETURN;
2811: END update_row;
2812: --
2813: --

Line 3226: fnd_msg_pub.initialize;

3222: WHERE order_number = p_order_number
3223: AND item_number <> p_item_number;
3224: l_rowid VARCHAR2 (26);
3225: BEGIN
3226: fnd_msg_pub.initialize;
3227: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
3228: DELETE FROM igs_as_doc_details
3229: WHERE ROWID = x_rowid;
3230: IF (SQL%NOTFOUND) THEN

Line 3276: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3272: END IF;
3273: -- Initialize API return status to success.
3274: x_return_status := fnd_api.g_ret_sts_success;
3275: -- Standard call to get message count and if count is 1, get message info
3276: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3277: --
3278: RETURN;
3279: EXCEPTION
3280: WHEN fnd_api.g_exc_error THEN

Line 3282: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3278: RETURN;
3279: EXCEPTION
3280: WHEN fnd_api.g_exc_error THEN
3281: x_return_status := fnd_api.g_ret_sts_error;
3282: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3283: RETURN;
3284: WHEN fnd_api.g_exc_unexpected_error THEN
3285: x_return_status := fnd_api.g_ret_sts_unexp_error;
3286: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 3286: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3282: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3283: RETURN;
3284: WHEN fnd_api.g_exc_unexpected_error THEN
3285: x_return_status := fnd_api.g_ret_sts_unexp_error;
3286: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3287: RETURN;
3288: WHEN OTHERS THEN
3289: x_return_status := fnd_api.g_ret_sts_unexp_error;
3290: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 3292: fnd_msg_pub.ADD;

3288: WHEN OTHERS THEN
3289: x_return_status := fnd_api.g_ret_sts_unexp_error;
3290: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3291: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3292: fnd_msg_pub.ADD;
3293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3294: RETURN;
3295: END delete_row;
3296: END igs_as_doc_details_pkg;

Line 3293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3289: x_return_status := fnd_api.g_ret_sts_unexp_error;
3290: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3291: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3292: fnd_msg_pub.ADD;
3293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3294: RETURN;
3295: END delete_row;
3296: END igs_as_doc_details_pkg;