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

Line 78: fnd_msg_pub.initialize;

74: SAVEPOINT create_ci_type;
75: END IF;
76:
77: IF p_init_msg_list = FND_API.G_TRUE THEN
78: fnd_msg_pub.initialize;
79: END IF;
80:
81: x_return_status := 'S';
82: x_msg_count := 0;

Line 96: fnd_msg_pub.add();

92: -- Validate the name and short name uniqueness
93: IF (pa_ci_types_util.check_ci_type_name_exists(p_name, p_short_name)) THEN
94: x_return_status := 'E';
95: fnd_message.set_name('PA', 'PA_CI_TYPE_NAME_NOT_UNIQUE');
96: fnd_msg_pub.add();
97: END IF;
98:
99: -- Resolution Category is required when Resolution Required Flag is checked
100: IF p_resolution_required_flag = 'Y' AND

Line 104: fnd_msg_pub.add();

100: IF p_resolution_required_flag = 'Y' AND
101: p_resolution_category IS NULL THEN
102: x_return_status := 'E';
103: fnd_message.set_name('PA', 'PA_CI_TYPE_RESO_CAT_MISSING');
104: fnd_msg_pub.add();
105: END IF;
106:
107: -- End Date Active must be later than Start Date Active
108: IF p_start_date_active > p_end_date_active THEN

Line 111: fnd_msg_pub.add();

107: -- End Date Active must be later than Start Date Active
108: IF p_start_date_active > p_end_date_active THEN
109: x_return_status := 'E';
110: fnd_message.set_name('PA', 'PA_CI_TYPE_INVALID_DATES');
111: fnd_msg_pub.add();
112: END IF;
113:
114: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
115: SELECT pa_ci_types_b_s.NEXTVAL

Line 241: fnd_msg_pub.count_and_get(p_count => x_msg_count,

237: ROLLBACK TO create_ci_type;
238: END IF;
239: END IF;
240:
241: fnd_msg_pub.count_and_get(p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: pa_debug.reset_err_stack;
245:

Line 254: FND_MSG_PUB.Count_And_Get

250: IF p_commit = 'T' THEN
251: ROLLBACK TO create_ci_type;
252: END IF;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.Count_And_Get
255: (p_count => x_msg_count,
256: p_data => x_msg_data);
257:
258:

Line 265: FND_MSG_PUB.Count_And_Get

261: IF p_commit = 'T' THEN
262: ROLLBACK TO create_ci_type;
263: END IF;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: FND_MSG_PUB.Count_And_Get
266: (p_count => x_msg_count,
267: p_data => x_msg_data);
268: WHEN OTHERS THEN
269: IF p_commit = fnd_api.g_true THEN

Line 274: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

270: ROLLBACK TO create_ci_type;
271: END IF;
272:
273: x_return_status := 'U';
274: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
275: p_procedure_name => 'CREATE_CI_TYPE',
276: p_error_text => SUBSTRB(SQLERRM,1,240));
277:
278: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 278: fnd_msg_pub.count_and_get(p_count => x_msg_count,

274: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
275: p_procedure_name => 'CREATE_CI_TYPE',
276: p_error_text => SUBSTRB(SQLERRM,1,240));
277:
278: fnd_msg_pub.count_and_get(p_count => x_msg_count,
279: p_data => x_msg_data);
280: END create_ci_type;
281:
282:

Line 499: fnd_msg_pub.initialize;

495: SAVEPOINT update_ci_type;
496: END IF;
497:
498: IF p_init_msg_list = FND_API.G_TRUE THEN
499: fnd_msg_pub.initialize;
500: END IF;
501:
502: x_return_status := 'S';
503: x_msg_count := 0;

Line 776: fnd_msg_pub.add();

772: p_approval_type_code <> 'EXTERNAL_APPROVAL') then
773:
774: x_return_status := 'E';
775: fnd_message.set_name('PA', 'PA_CI_PCO_APP_METHOD_IN_USE');
776: fnd_msg_pub.add();
777: end if;
778: end if ;
779: close c_pco_st_exists;
780: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676

Line 786: fnd_msg_pub.add();

782: -- Validate the name and short name uniqueness
783: IF (pa_ci_types_util.check_ci_type_name_exists(p_name, p_short_name, p_ci_type_id)) THEN
784: x_return_status := 'E';
785: fnd_message.set_name('PA','PA_CI_TYPE_NAME_NOT_UNIQUE');
786: fnd_msg_pub.add();
787: END IF;
788:
789:
790: -- Validate the record version number

Line 807: fnd_msg_pub.add();

803: EXCEPTION
804: WHEN NO_DATA_FOUND THEN
805: x_return_status := 'E';
806: fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
807: fnd_msg_pub.add();
808: END;
809:
810: -- Cannot change the category if there is a control item using the class code
811: IF x_return_status = 'S' AND

Line 822: fnd_msg_pub.add();

818: AND ROWNUM < 2;
819:
820: x_return_status := 'E';
821: fnd_message.set_name('PA','PA_CI_TYPE_CLASS_CAT_IN_USE');
822: fnd_msg_pub.add();
823: EXCEPTION
824: WHEN NO_DATA_FOUND THEN
825: NULL;
826: END;

Line 840: fnd_msg_pub.add();

836: AND ROWNUM < 2;
837:
838: x_return_status := 'E';
839: fnd_message.set_name('PA','PA_CI_TYPE_REASON_CAT_IN_USE');
840: fnd_msg_pub.add();
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: NULL;
844: END;

Line 858: fnd_msg_pub.add();

854: AND ROWNUM < 2;
855:
856: x_return_status := 'E';
857: fnd_message.set_name('PA','PA_CI_TYPE_RESO_CAT_IN_USE');
858: fnd_msg_pub.add();
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: NULL;
862: END;

Line 870: fnd_msg_pub.add();

866: IF p_resolution_required_flag = 'Y' AND
867: p_resolution_category IS NULL THEN
868: x_return_status := 'E';
869: fnd_message.set_name('PA', 'PA_CI_TYPE_RESO_CAT_MISSING');
870: fnd_msg_pub.add();
871: END IF;
872:
873: -- Cannot change from Manual to Automatic numbering if an item exists
874: IF p_auto_number_flag = 'Y' THEN

Line 887: fnd_msg_pub.add();

883: AND ROWNUM=1;
884:
885: x_return_status := 'E';
886: fnd_message.set_name('PA', 'PA_CI_TYPE_NO_SWITCH_NUM');
887: fnd_msg_pub.add();
888: EXCEPTION
889: WHEN OTHERS THEN
890: NULL;
891: END;

Line 898: fnd_msg_pub.add();

894: -- End Date Active must be later than Start Date Active
895: IF p_start_date_active > p_end_date_active THEN
896: x_return_status := 'E';
897: fnd_message.set_name('PA', 'PA_CI_TYPE_INVALID_DATES');
898: fnd_msg_pub.add();
899: END IF;
900:
901: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
902: pa_ci_types_pkg.update_row(

Line 973: fnd_msg_pub.count_and_get(p_count => x_msg_count,

969: ROLLBACK TO update_ci_type;
970: END IF;
971: END IF;
972:
973: fnd_msg_pub.count_and_get(p_count => x_msg_count,
974: p_data => x_msg_data);
975:
976: pa_debug.reset_err_stack;
977:

Line 985: FND_MSG_PUB.Count_And_Get

981: IF p_commit = 'T' THEN
982: ROLLBACK TO update_ci_type;
983: END IF;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count,
987: p_data => x_msg_data);
988:
989:

Line 996: FND_MSG_PUB.Count_And_Get

992: IF p_commit = 'T' THEN
993: ROLLBACK TO update_ci_type;
994: END IF;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: FND_MSG_PUB.Count_And_Get
997: (p_count => x_msg_count,
998: p_data => x_msg_data);
999:
1000: WHEN OTHERS THEN

Line 1006: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

1002: ROLLBACK TO update_ci_type;
1003: END IF;
1004:
1005: x_return_status := 'U';
1006: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1007: p_procedure_name => 'UPDATE_CI_TYPE',
1008: p_error_text => SUBSTRB(SQLERRM,1,240));
1009:
1010: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1010: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1006: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1007: p_procedure_name => 'UPDATE_CI_TYPE',
1008: p_error_text => SUBSTRB(SQLERRM,1,240));
1009:
1010: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1011: p_data => x_msg_data);
1012: END update_ci_type;
1013:
1014:

Line 1053: fnd_msg_pub.initialize;

1049: SAVEPOINT delete_ci_type;
1050: END IF;
1051:
1052: IF p_init_msg_list = FND_API.G_TRUE THEN
1053: fnd_msg_pub.initialize;
1054: END IF;
1055:
1056: x_return_status := 'S';
1057: x_msg_count := 0;

Line 1070: fnd_msg_pub.add();

1066: EXCEPTION
1067: WHEN NO_DATA_FOUND THEN
1068: x_return_status := 'E';
1069: fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
1070: fnd_msg_pub.add();
1071: END;
1072:
1073: -- Cannot delete CI Type if CI exists
1074: BEGIN

Line 1082: fnd_msg_pub.add();

1078: AND ROWNUM=1;
1079:
1080: x_return_status := 'E';
1081: fnd_message.set_name('PA','PA_CI_TYPE_NO_DELETE_IN_USE');
1082: fnd_msg_pub.add();
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: NULL;
1086: END;

Line 1094: fnd_msg_pub.add();

1090: -- for financial imapct implementation/inclusion
1091: if Pa_Fp_Control_Items_Utils.validate_fp_ci_type_delete( p_ci_type_id) <> 'Y' then
1092: x_return_status := 'E';
1093: fnd_message.set_name('PA','FP_CI_TYPE_DEL_NOT_ALLOWED');
1094: fnd_msg_pub.add();
1095: end if;
1096: /* Changes for the bug# 3941304 ends here */
1097:
1098: --Deleting the associated distribution list

Line 1160: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1156: ROLLBACK TO delete_ci_type;
1157: END IF;
1158: END IF;
1159:
1160: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1161: p_data => x_msg_data);
1162:
1163: pa_debug.reset_err_stack;
1164:

Line 1172: FND_MSG_PUB.Count_And_Get

1168: IF p_commit = 'T' THEN
1169: ROLLBACK TO delete_ci_type;
1170: END IF;
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get
1173: (p_count => x_msg_count,
1174: p_data => x_msg_data);
1175:
1176:

Line 1183: FND_MSG_PUB.Count_And_Get

1179: IF p_commit = 'T' THEN
1180: ROLLBACK TO delete_ci_type;
1181: END IF;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: FND_MSG_PUB.Count_And_Get
1184: (p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:
1187: WHEN OTHERS THEN

Line 1193: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

1189: ROLLBACK TO delete_ci_type;
1190: END IF;
1191:
1192: x_return_status := 'U';
1193: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1194: p_procedure_name => 'DELETE_CI_TYPE',
1195: p_error_text => SUBSTRB(SQLERRM,1,240));
1196:
1197: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1197: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1193: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1194: p_procedure_name => 'DELETE_CI_TYPE',
1195: p_error_text => SUBSTRB(SQLERRM,1,240));
1196:
1197: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1198: p_data => x_msg_data);
1199: END delete_ci_type;
1200:
1201: END pa_ci_types_pvt;