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.

[Home] [Help]

APPS.PA_CI_TYPES_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2: /* $Header: PACITYVB.pls 120.2.12010000.11 2009/10/28 19:34:13 cklee ship $ */
3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,

Line 7: p_commit IN VARCHAR2 := FND_API.g_false,

3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,

Line 8: p_validate_only IN VARCHAR2 := FND_API.g_true,

4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,
12: p_description IN VARCHAR2,

Line 9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,
12: p_description IN VARCHAR2,
13: p_ci_type_class_code IN VARCHAR2,

Line 73: IF p_commit = FND_API.G_TRUE THEN

69:
70: BEGIN
71: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.CREATE_CI_TYPE');
72:
73: IF p_commit = FND_API.G_TRUE THEN
74: SAVEPOINT create_ci_type;
75: END IF;
76:
77: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 77: IF p_init_msg_list = FND_API.G_TRUE THEN

73: IF p_commit = FND_API.G_TRUE THEN
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';

Line 114: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

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
116: INTO x_ci_type_id
117: FROM sys.dual;
118:

Line 217: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

213: );
214: END IF;
215:
216: --Associating the dist list to the CI type
217: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
218: pa_object_dist_lists_pvt.create_object_dist_list (
219: p_validate_only => p_validate_only,
220: p_list_id => x_dist_list_id,
221: p_object_type => 'PA_CI_TYPES',

Line 233: IF p_commit = fnd_api.g_true THEN

229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data);
231: END IF;
232:
233: IF p_commit = fnd_api.g_true THEN
234: IF x_return_status = 'S' THEN
235: COMMIT;
236: ELSE
237: ROLLBACK TO create_ci_type;

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 269: IF p_commit = fnd_api.g_true THEN

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
270: ROLLBACK TO create_ci_type;
271: END IF;
272:
273: x_return_status := 'U';

Line 285: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

281:
282:
283: PROCEDURE update_ci_type (
284: p_api_version IN NUMBER := 1.0,
285: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
286: p_commit IN VARCHAR2 := FND_API.g_false,
287: p_validate_only IN VARCHAR2 := FND_API.g_true,
288: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
289: p_ci_type_id IN NUMBER,

Line 286: p_commit IN VARCHAR2 := FND_API.g_false,

282:
283: PROCEDURE update_ci_type (
284: p_api_version IN NUMBER := 1.0,
285: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
286: p_commit IN VARCHAR2 := FND_API.g_false,
287: p_validate_only IN VARCHAR2 := FND_API.g_true,
288: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
289: p_ci_type_id IN NUMBER,
290: p_name IN VARCHAR2,

Line 287: p_validate_only IN VARCHAR2 := FND_API.g_true,

283: PROCEDURE update_ci_type (
284: p_api_version IN NUMBER := 1.0,
285: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
286: p_commit IN VARCHAR2 := FND_API.g_false,
287: p_validate_only IN VARCHAR2 := FND_API.g_true,
288: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
289: p_ci_type_id IN NUMBER,
290: p_name IN VARCHAR2,
291: p_short_name IN VARCHAR2,

Line 288: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

284: p_api_version IN NUMBER := 1.0,
285: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
286: p_commit IN VARCHAR2 := FND_API.g_false,
287: p_validate_only IN VARCHAR2 := FND_API.g_true,
288: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
289: p_ci_type_id IN NUMBER,
290: p_name IN VARCHAR2,
291: p_short_name IN VARCHAR2,
292: p_description IN VARCHAR2,

Line 494: IF p_commit = FND_API.G_TRUE THEN

490:
491: BEGIN
492: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.UPDATE_CI_TYPE');
493:
494: IF p_commit = FND_API.G_TRUE THEN
495: SAVEPOINT update_ci_type;
496: END IF;
497:
498: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 498: IF p_init_msg_list = FND_API.G_TRUE THEN

494: IF p_commit = FND_API.G_TRUE THEN
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';

Line 901: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

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(
903: x_ci_type_id => p_ci_type_id,
904: x_ci_type_class_code => p_ci_type_class_code,
905: x_auto_number_flag => p_auto_number_flag,

Line 965: IF p_commit = fnd_api.g_true THEN

961: X_LAST_UPDATE_LOGIN => p_last_update_login
962: );
963: END IF;
964:
965: IF p_commit = fnd_api.g_true THEN
966: IF x_return_status = 'S' THEN
967: COMMIT;
968: ELSE
969: ROLLBACK TO update_ci_type;

Line 984: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 995: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1001: IF p_commit = fnd_api.g_true THEN

997: (p_count => x_msg_count,
998: p_data => x_msg_data);
999:
1000: WHEN OTHERS THEN
1001: IF p_commit = fnd_api.g_true THEN
1002: ROLLBACK TO update_ci_type;
1003: END IF;
1004:
1005: x_return_status := 'U';

Line 1017: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

1013:
1014:
1015: PROCEDURE delete_ci_type (
1016: p_api_version IN NUMBER := 1.0,
1017: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1018: p_commit IN VARCHAR2 := FND_API.g_false,
1019: p_validate_only IN VARCHAR2 := FND_API.g_true,
1020: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1021: p_ci_type_id IN NUMBER,

Line 1018: p_commit IN VARCHAR2 := FND_API.g_false,

1014:
1015: PROCEDURE delete_ci_type (
1016: p_api_version IN NUMBER := 1.0,
1017: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1018: p_commit IN VARCHAR2 := FND_API.g_false,
1019: p_validate_only IN VARCHAR2 := FND_API.g_true,
1020: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1021: p_ci_type_id IN NUMBER,
1022: p_record_version_number IN NUMBER,

Line 1019: p_validate_only IN VARCHAR2 := FND_API.g_true,

1015: PROCEDURE delete_ci_type (
1016: p_api_version IN NUMBER := 1.0,
1017: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1018: p_commit IN VARCHAR2 := FND_API.g_false,
1019: p_validate_only IN VARCHAR2 := FND_API.g_true,
1020: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1021: p_ci_type_id IN NUMBER,
1022: p_record_version_number IN NUMBER,
1023: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1020: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

1016: p_api_version IN NUMBER := 1.0,
1017: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1018: p_commit IN VARCHAR2 := FND_API.g_false,
1019: p_validate_only IN VARCHAR2 := FND_API.g_true,
1020: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1021: p_ci_type_id IN NUMBER,
1022: p_record_version_number IN NUMBER,
1023: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1024: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1048: IF p_commit = FND_API.G_TRUE THEN

1044: l_temp VARCHAR2(1);
1045: BEGIN
1046: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.DELETE_CI_TYPE');
1047:
1048: IF p_commit = FND_API.G_TRUE THEN
1049: SAVEPOINT delete_ci_type;
1050: END IF;
1051:
1052: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 1052: IF p_init_msg_list = FND_API.G_TRUE THEN

1048: IF p_commit = FND_API.G_TRUE THEN
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';

Line 1099: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

1095: end if;
1096: /* Changes for the bug# 3941304 ends here */
1097:
1098: --Deleting the associated distribution list
1099: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1100: pa_object_dist_lists_pvt.delete_assoc_dist_lists (
1101: p_validate_only => p_validate_only,
1102: p_object_type => 'PA_CI_TYPES',
1103: p_object_id => p_ci_type_id,

Line 1110: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

1106: x_msg_data => x_msg_data);
1107: END IF;
1108:
1109: --Deleting the CI type usage
1110: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1111: FOR rec IN c_ci_type_usage LOOP
1112: pa_ci_type_usage_pvt.delete_ci_type_usage (
1113: p_validate_only => p_validate_only,
1114: p_ci_type_usage_id => rec.ci_type_usage_id,

Line 1126: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

1122: END LOOP;
1123: END IF;
1124:
1125: --Deleting the impact type usage
1126: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1127: FOR rec IN c_impact_type_usage LOOP
1128: pa_ci_impact_type_usage_pvt.delete_ci_impact_type_usage (
1129: p_validate_only => p_validate_only,
1130: p_ci_impact_type_usage_id => rec.ci_impact_type_usage_id,

Line 1143: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

1139: END LOOP;
1140: END IF;
1141:
1142: --Deleting the CI type itself
1143: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1144: pa_ci_types_pkg.delete_row(
1145: x_ci_type_id => p_ci_type_id);
1146:
1147: --Deleting the association from pa_obj_status_lists

Line 1152: IF p_commit = fnd_api.g_true THEN

1148: pa_obj_status_lists_pkg.delete_row(
1149: x_obj_status_list_id => p_obj_status_list_id);
1150: END IF;
1151:
1152: IF p_commit = fnd_api.g_true THEN
1153: IF x_return_status = 'S' THEN
1154: COMMIT;
1155: ELSE
1156: ROLLBACK TO delete_ci_type;

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1188: IF p_commit = fnd_api.g_true THEN

1184: (p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:
1187: WHEN OTHERS THEN
1188: IF p_commit = fnd_api.g_true THEN
1189: ROLLBACK TO delete_ci_type;
1190: END IF;
1191:
1192: x_return_status := 'U';