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_API

Line 304: RAISE fnd_api.g_exc_error;

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.
308: new_references.order_number := x_order_number;

Line 455: RAISE FND_API.G_EXC_ERROR;*/

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)
459: )

Line 468: RAISE fnd_api.g_exc_error;

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)
472: )

Line 481: RAISE fnd_api.g_exc_error;

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))
485: ) THEN

Line 490: RAISE fnd_api.g_exc_error;

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: --
494: --

Line 547: RAISE fnd_api.g_exc_error;

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;
551: END get_fk_igs_as_doc_dlvy_typ;

Line 582: RAISE fnd_api.g_exc_error;

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;
586: END get_fk_igs_ca_inst;

Line 612: RAISE fnd_api.g_exc_error;

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;
616: END get_fk_igs_as_order_hdr;

Line 931: RAISE fnd_api.g_exc_error;

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
935: -- Call all the procedures related to Before Update.

Line 942: RAISE fnd_api.g_exc_error;

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;
946: --

Line 1125: RAISE fnd_api.g_exc_error;

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
1129: INTO x_item_number

Line 1368: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

1364: p_return_status => x_return_status,
1365: p_msg_data => x_msg_data,
1366: p_msg_count => x_msg_count
1367: );
1368: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
1369: RETURN;
1370: END IF;
1371: -- Call procedure to insert/Update record in IGS_AS_DOC_FEE_PMNT table.
1372: IF new_references.plan_id IS NOT NULL THEN

Line 1382: x_return_status := fnd_api.g_ret_sts_success;

1378: p_operation => 'I'
1379: );
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

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 1386: WHEN fnd_api.g_exc_error THEN

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);
1389: RETURN;
1390: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1387: x_return_status := fnd_api.g_ret_sts_error;

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);
1389: RETURN;
1390: WHEN fnd_api.g_exc_unexpected_error THEN
1391: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 1390: WHEN fnd_api.g_exc_unexpected_error THEN

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);
1393: RETURN;
1394: WHEN OTHERS THEN

Line 1391: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1393: RETURN;
1394: WHEN OTHERS THEN
1395: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 1395: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
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);

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 1658: RAISE fnd_api.g_exc_error;

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;
1662: IF ((tlinfo.order_number = x_order_number)

Line 2199: RAISE fnd_api.g_exc_error;

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;
2203: -- Standard call to get message count and if count is 1, get message info

Line 2202: x_return_status := fnd_api.g_ret_sts_success;

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;
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

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 2206: WHEN fnd_api.g_exc_error THEN

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);
2209: RETURN;
2210: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2207: x_return_status := fnd_api.g_ret_sts_error;

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);
2209: RETURN;
2210: WHEN fnd_api.g_exc_unexpected_error THEN
2211: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 2210: WHEN fnd_api.g_exc_unexpected_error THEN

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);
2213: RETURN;
2214: WHEN OTHERS THEN

Line 2211: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2213: RETURN;
2214: WHEN OTHERS THEN
2215: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 2215: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
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);

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 2379: RAISE fnd_api.g_exc_error;

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',
2383: x_rowid => x_rowid,

Line 2709: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

2705: p_return_status => x_return_status,
2706: p_msg_data => x_msg_data,
2707: p_msg_count => x_msg_count
2708: );
2709: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
2710: RETURN;
2711: END IF;
2712: -- Call procedure to insert/Update record in IGS_AS_DOC_FEE_PMNT table.
2713: IF new_references.plan_id IS NOT NULL THEN

Line 2792: x_return_status := fnd_api.g_ret_sts_success;

2788: END LOOP;
2789: END;
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

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 2796: WHEN fnd_api.g_exc_error THEN

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);
2799: RETURN;
2800: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2797: x_return_status := fnd_api.g_ret_sts_error;

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);
2799: RETURN;
2800: WHEN fnd_api.g_exc_unexpected_error THEN
2801: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 2800: WHEN fnd_api.g_exc_unexpected_error THEN

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);
2803: RETURN;
2804: WHEN OTHERS THEN

Line 2801: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2803: RETURN;
2804: WHEN OTHERS THEN
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 2805: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
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);

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 3260: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

3256: p_return_status => x_return_status,
3257: p_msg_data => x_msg_data,
3258: p_msg_count => x_msg_count
3259: );
3260: IF NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
3261: RETURN;
3262: END IF;
3263: -- Call procedure to insert/Update record in IGS_AS_DOC_FEE_PMNT table.
3264: IF old_references.plan_id IS NOT NULL THEN

Line 3274: x_return_status := fnd_api.g_ret_sts_success;

3270: p_operation => 'D'
3271: );
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;

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 3280: WHEN fnd_api.g_exc_error THEN

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
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

Line 3281: x_return_status := fnd_api.g_ret_sts_error;

3277: --
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;

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 3284: WHEN fnd_api.g_exc_unexpected_error THEN

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);
3287: RETURN;
3288: WHEN OTHERS THEN

Line 3285: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
3287: RETURN;
3288: WHEN OTHERS THEN
3289: x_return_status := fnd_api.g_ret_sts_unexp_error;

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 3289: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
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);

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;