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

Line 24: FND_MSG_PUB.add;

20: BEGIN
21: IF ( p_organization_id IS NULL OR
22: p_organization_id = FND_API.G_MISS_NUM ) THEN
23: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
24: FND_MSG_PUB.add;
25: RETURN FND_API.G_RET_STS_ERROR;
26: END IF;
27:
28: IF ( p_transaction_number IS NULL OR

Line 31: FND_MSG_PUB.add;

27:
28: IF ( p_transaction_number IS NULL OR
29: p_transaction_number = FND_API.G_MISS_NUM ) THEN
30: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_TXN_NO_NULL' );
31: FND_MSG_PUB.add;
32: RETURN FND_API.G_RET_STS_ERROR;
33: END IF;
34:
35: IF ( p_col_trigger_value IS NULL OR

Line 38: FND_MSG_PUB.add;

34:
35: IF ( p_col_trigger_value IS NULL OR
36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INSPECTION_TYPE_NULL' );
38: FND_MSG_PUB.add;
39: RETURN FND_API.G_RET_STS_ERROR;
40: END IF;
41:
42: END validate_gqp_inputs;

Line 123: FND_MSG_PUB.add;

119:
120: IF ( p_plan_id IS NULL OR
121: p_plan_id = FND_API.G_MISS_NUM ) THEN
122: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
123: FND_MSG_PUB.add;
124: RETURN FND_API.G_RET_STS_ERROR;
125: END IF;
126:
127: IF ( p_organization_id IS NULL OR

Line 130: FND_MSG_PUB.add;

126:
127: IF ( p_organization_id IS NULL OR
128: p_organization_id = FND_API.G_MISS_NUM ) THEN
129: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
130: FND_MSG_PUB.add;
131: RETURN FND_API.G_RET_STS_ERROR;
132: END IF;
133:
134: IF ( p_results_tbl.COUNT = 0 ) THEN

Line 136: FND_MSG_PUB.add;

132: END IF;
133:
134: IF ( p_results_tbl.COUNT = 0 ) THEN
135: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );
136: FND_MSG_PUB.add;
137: RETURN FND_API.G_RET_STS_ERROR;
138: END IF;
139:
140: BEGIN

Line 149: FND_MSG_PUB.add;

145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );
149: FND_MSG_PUB.add;
150: RETURN FND_API.G_RET_STS_ERROR;
151: END;
152:
153: -- rroy

Line 174: FND_MSG_PUB.ADD;

170:
171: IF l_unit_locked = FND_API.G_TRUE THEN
172: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
173: FND_MESSAGE.Set_Token('MR_TITLE', L_TITLE);
174: FND_MSG_PUB.ADD;
175: RETURN FND_API.G_RET_STS_ERROR;
176: END IF;
177:
178: IF(L_STATUS_CODE IN ('ACCOMPLISHED','DEFERRED','UNRELEASED','TERMINATED','CANCELLED','DEFERRAL_PENDING'))THEN

Line 181: FND_MSG_PUB.ADD;

177:
178: IF(L_STATUS_CODE IN ('ACCOMPLISHED','DEFERRED','UNRELEASED','TERMINATED','CANCELLED','DEFERRAL_PENDING'))THEN
179: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_CAP_NALLWD');
180: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
181: FND_MSG_PUB.ADD;
182: RETURN FND_API.G_RET_STS_ERROR;
183: END IF;
184: ELSIF p_transaction_no = G_JOB_TXN_NO THEN
185: OPEN get_wo_details(l_workorder_id);

Line 191: FND_MSG_PUB.ADD;

187: CLOSE get_wo_details;
188: IF l_unit_locked = FND_API.G_TRUE THEN
189:
190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');
191: FND_MSG_PUB.ADD;
192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;
194: IF(L_STATUS_CODE IN ('1','4','5','7','12','21'))THEN
195: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_CAP_NALLWD');

Line 197: FND_MSG_PUB.ADD;

193: END IF;
194: IF(L_STATUS_CODE IN ('1','4','5','7','12','21'))THEN
195: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_CAP_NALLWD');
196: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
197: FND_MSG_PUB.ADD;
198: RETURN FND_API.G_RET_STS_ERROR;
199: END IF;
200:
201: ELSIF p_transaction_no = G_OP_TXN_NO THEN

Line 208: FND_MSG_PUB.ADD;

204: CLOSE get_op_details;
205: IF l_unit_locked = FND_API.G_TRUE THEN
206:
207: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
208: FND_MSG_PUB.ADD;
209: RETURN FND_API.G_RET_STS_ERROR;
210: END IF;
211: IF(L_STATUS_CODE IN ('1'))THEN
212: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_CAP_NALLWD');

Line 214: FND_MSG_PUB.ADD;

210: END IF;
211: IF(L_STATUS_CODE IN ('1'))THEN
212: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_CAP_NALLWD');
213: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
214: FND_MSG_PUB.ADD;
215: RETURN FND_API.G_RET_STS_ERROR;
216: END IF;
217: END IF;
218:

Line 223: FND_MSG_PUB.add;

219:
220:
221: IF ( l_organization_id <> p_organization_id ) THEN
222: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );
223: FND_MSG_PUB.add;
224: RETURN FND_API.G_RET_STS_ERROR;
225: END IF;
226:
227: IF ( p_collection_id IS NOT NULL AND

Line 232: FND_MSG_PUB.add;

228: p_collection_id <> FND_API.G_MISS_NUM ) THEN
229: FOR results_cursor IN get_plan_from_results( p_collection_id ) LOOP
230: IF ( results_cursor.plan_id <> p_plan_id ) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
232: FND_MSG_PUB.add;
233: CLOSE get_plan_from_results;
234: RETURN FND_API.G_RET_STS_ERROR;
235: END IF;
236:

Line 242: FND_MSG_PUB.add;

238: END LOOP;
239:
240: IF ( l_element_count = 1 ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_NOT_FOUND' );
242: FND_MSG_PUB.add;
243: RETURN FND_API.G_RET_STS_ERROR;
244: END IF;
245:
246: END IF;

Line 266: FND_MSG_PUB.add;

262: END LOOP;
263:
264: IF ( l_match_found = FALSE ) THEN
265: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );
266: FND_MSG_PUB.add;
267: RETURN FND_API.G_RET_STS_ERROR;
268: END IF;
269:
270: l_match_found := FALSE;

Line 285: FND_MSG_PUB.add;

281: END LOOP;
282:
283: IF ( l_match_found = FALSE ) THEN
284: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );
285: FND_MSG_PUB.add;
286: RETURN FND_API.G_RET_STS_ERROR;
287: END IF;
288:
289: l_match_found := FALSE;

Line 336: FND_MSG_PUB.add;

332:
333: IF ( l_unit_effectivity_id IS NULL OR
334: l_object_version_number IS NULL ) THEN
335: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );
336: FND_MSG_PUB.add;
337: RETURN FND_API.G_RET_STS_ERROR;
338: END IF;
339:
340: -- Change to call capture_mr_updates

Line 352: FND_MSG_PUB.add;

348: AND object_version_number = l_object_version_number;
349:
350: IF ( SQL%ROWCOUNT = 0 ) THEN
351: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );
352: FND_MSG_PUB.add;
353: RETURN FND_API.G_RET_STS_ERROR;
354: END IF;
355:
356: ELSIF ( p_transaction_no = G_JOB_TXN_NO ) THEN

Line 361: FND_MSG_PUB.add;

357:
358: IF ( l_workorder_id IS NULL OR
359: l_object_version_number IS NULL ) THEN
360: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );
361: FND_MSG_PUB.add;
362: RETURN FND_API.G_RET_STS_ERROR;
363: END IF;
364:
365: UPDATE AHL_WORKORDERS

Line 376: FND_MSG_PUB.add;

372: AND object_version_number = l_object_version_number;
373:
374: IF ( SQL%ROWCOUNT = 0 ) THEN
375: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );
376: FND_MSG_PUB.add;
377: RETURN FND_API.G_RET_STS_ERROR;
378: END IF;
379:
380: ELSIF ( p_transaction_no = G_OP_TXN_NO ) THEN

Line 385: FND_MSG_PUB.add;

381:
382: IF ( l_workorder_operation_id IS NULL OR
383: l_object_version_number IS NULL ) THEN
384: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );
385: FND_MSG_PUB.add;
386: RETURN FND_API.G_RET_STS_ERROR;
387: END IF;
388:
389: UPDATE AHL_WORKORDER_OPERATIONS

Line 400: FND_MSG_PUB.add;

396: AND object_version_number = l_object_version_number;
397:
398: IF ( SQL%ROWCOUNT = 0 ) THEN
399: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );
400: FND_MSG_PUB.add;
401: RETURN FND_API.G_RET_STS_ERROR;
402: END IF;
403:
404: ELSIF ( p_transaction_no = G_MRB_TXN_NO ) THEN

Line 536: FND_MSG_PUB.initialize;

532: SAVEPOINT submit_qa_results_PVT;
533:
534: -- Initialize message list if p_init_msg_list is set to TRUE.
535: IF FND_API.to_boolean( p_init_msg_list ) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538:
539: l_return_status :=
540: validate_sqar_inputs

Line 697: FND_MSG_PUB.add;

693: END IF;
694:
695: IF ( l_msg_data IS NULL ) THEN
696: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
697: FND_MSG_PUB.add;
698: RAISE FND_API.G_EXC_ERROR;
699: ELSE
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: x_msg_data := l_msg_data;

Line 775: FND_MSG_PUB.add;

771:
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: IF ( l_msg_data IS NULL ) THEN
774: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
775: FND_MSG_PUB.add;
776: RAISE FND_API.G_EXC_ERROR;
777: ELSE
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: x_msg_data := l_msg_data;

Line 812: FND_MSG_PUB.count_and_get

808:
809: WHEN FND_API.G_EXC_ERROR THEN
810: ROLLBACK TO submit_qa_results_PVT;
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: FND_MSG_PUB.count_and_get
813: (
814: p_encoded => FND_API.G_FALSE,
815: p_count => x_msg_count,
816: p_data => x_msg_data

Line 826: FND_MSG_PUB.count_and_get

822:
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO submit_qa_results_PVT;
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
826: FND_MSG_PUB.count_and_get
827: (
828: p_encoded => FND_API.G_FALSE,
829: p_count => x_msg_count,
830: p_data => x_msg_data

Line 840: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

836:
837: WHEN OTHERS THEN
838: ROLLBACK TO submit_qa_results_PVT;
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
841: THEN
842: FND_MSG_PUB.add_exc_msg
843: (
844: p_pkg_name => G_PKG_NAME,

Line 842: FND_MSG_PUB.add_exc_msg

838: ROLLBACK TO submit_qa_results_PVT;
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
841: THEN
842: FND_MSG_PUB.add_exc_msg
843: (
844: p_pkg_name => G_PKG_NAME,
845: p_procedure_name => l_api_name,
846: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 849: FND_MSG_PUB.count_and_get

845: p_procedure_name => l_api_name,
846: p_error_text => SUBSTRB(SQLERRM,1,240)
847: );
848: END IF;
849: FND_MSG_PUB.count_and_get
850: (
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data

Line 897: FND_MSG_PUB.initialize;

893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF FND_API.to_boolean( p_init_msg_list ) THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899:
900: x_char_lov_sql :=
901: QA_SS_LOV_API.get_lov_sql

Line 925: IF FND_MSG_PUB.count_msg > 0 THEN

921: value => p_value
922: );
923:
924: -- Error handling code added by balaji for bug # 4091726
925: IF FND_MSG_PUB.count_msg > 0 THEN
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:
929: IF ( x_char_lov_sql IS NULL ) THEN

Line 931: FND_MSG_PUB.add;

927: END IF;
928:
929: IF ( x_char_lov_sql IS NULL ) THEN
930: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );
931: FND_MSG_PUB.add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: IF ( G_DEBUG = 'Y' ) THEN

Line 943: FND_MSG_PUB.count_and_get

939: EXCEPTION
940:
941: WHEN FND_API.G_EXC_ERROR THEN
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.count_and_get
944: (
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,
947: p_data => x_msg_data

Line 956: FND_MSG_PUB.count_and_get

952: END IF;
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956: FND_MSG_PUB.count_and_get
957: (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data

Line 969: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

965: END IF;
966:
967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
969: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
970: THEN
971: FND_MSG_PUB.add_exc_msg
972: (
973: p_pkg_name => G_PKG_NAME,

Line 971: FND_MSG_PUB.add_exc_msg

967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
969: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
970: THEN
971: FND_MSG_PUB.add_exc_msg
972: (
973: p_pkg_name => G_PKG_NAME,
974: p_procedure_name => l_api_name,
975: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 978: FND_MSG_PUB.count_and_get

974: p_procedure_name => l_api_name,
975: p_error_text => SUBSTRB(SQLERRM,1,240)
976: );
977: END IF;
978: FND_MSG_PUB.count_and_get
979: (
980: p_encoded => FND_API.G_FALSE,
981: p_count => x_msg_count,
982: p_data => x_msg_data

Line 1020: FND_MSG_PUB.initialize;

1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:
1018: -- Initialize message list if p_init_msg_list is set to TRUE.
1019: IF FND_API.to_boolean( p_init_msg_list ) THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:
1023: BEGIN
1024:

Line 1042: FND_MSG_PUB.add;

1038: WHEN NO_DATA_FOUND THEN
1039: x_plan_id := NULL;
1040: IF ( p_module_type = 'JSP' ) THEN
1041: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );
1042: FND_MSG_PUB.add;
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSE
1045: RETURN;
1046: END IF;

Line 1059: FND_MSG_PUB.count_and_get

1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.count_and_get
1060: (
1061: p_encoded => FND_API.G_FALSE,
1062: p_count => x_msg_count,
1063: p_data => x_msg_data

Line 1072: FND_MSG_PUB.count_and_get

1068: END IF;
1069:
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1072: FND_MSG_PUB.count_and_get
1073: (
1074: p_encoded => FND_API.G_FALSE,
1075: p_count => x_msg_count,
1076: p_data => x_msg_data

Line 1085: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1081: END IF;
1082:
1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1086: THEN
1087: FND_MSG_PUB.add_exc_msg
1088: (
1089: p_pkg_name => G_PKG_NAME,

Line 1087: FND_MSG_PUB.add_exc_msg

1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1086: THEN
1087: FND_MSG_PUB.add_exc_msg
1088: (
1089: p_pkg_name => G_PKG_NAME,
1090: p_procedure_name => l_api_name,
1091: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1094: FND_MSG_PUB.count_and_get

1090: p_procedure_name => l_api_name,
1091: p_error_text => SUBSTRB(SQLERRM,1,240)
1092: );
1093: END IF;
1094: FND_MSG_PUB.count_and_get
1095: (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data