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 119: FND_MSG_PUB.add;

115:
116: IF ( p_plan_id IS NULL OR
117: p_plan_id = FND_API.G_MISS_NUM ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
119: FND_MSG_PUB.add;
120: RETURN FND_API.G_RET_STS_ERROR;
121: END IF;
122:
123: IF ( p_organization_id IS NULL OR

Line 126: FND_MSG_PUB.add;

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

Line 132: FND_MSG_PUB.add;

128: END IF;
129:
130: IF ( p_results_tbl.COUNT = 0 ) THEN
131: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );
132: FND_MSG_PUB.add;
133: RETURN FND_API.G_RET_STS_ERROR;
134: END IF;
135:
136: BEGIN

Line 145: FND_MSG_PUB.add;

141:
142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );
145: FND_MSG_PUB.add;
146: RETURN FND_API.G_RET_STS_ERROR;
147: END;
148:
149: -- rroy

Line 182: FND_MSG_PUB.ADD;

178: FETCH ue_title_csr INTO l_mr_title;
179: CLOSE ue_title_csr;
180: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
181: FND_MESSAGE.Set_Token('MR_TITLE', l_mr_title);
182: FND_MSG_PUB.ADD;
183: RETURN FND_API.G_RET_STS_ERROR;
184: END IF;
185: ELSIF p_transaction_no = G_JOB_TXN_NO THEN
186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,

Line 191: FND_MSG_PUB.ADD;

187: p_visit_id => NULL,
188: p_item_instance_id => NULL);
189: IF l_return_status = FND_API.G_TRUE THEN
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: ELSIF p_transaction_no = G_OP_TXN_NO THEN
195: OPEN get_wo_from_op(l_workorder_operation_id);

Line 204: FND_MSG_PUB.ADD;

200: p_visit_id => NULL,
201: p_item_instance_id => NULL);
202: IF l_return_status = FND_API.G_TRUE THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
204: FND_MSG_PUB.ADD;
205: RETURN FND_API.G_RET_STS_ERROR;
206: END IF;
207: END IF;
208:

Line 213: FND_MSG_PUB.add;

209:
210:
211: IF ( l_organization_id <> p_organization_id ) THEN
212: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );
213: FND_MSG_PUB.add;
214: RETURN FND_API.G_RET_STS_ERROR;
215: END IF;
216:
217: IF ( p_collection_id IS NOT NULL AND

Line 222: FND_MSG_PUB.add;

218: p_collection_id <> FND_API.G_MISS_NUM ) THEN
219: FOR results_cursor IN get_plan_from_results( p_collection_id ) LOOP
220: IF ( results_cursor.plan_id <> p_plan_id ) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
222: FND_MSG_PUB.add;
223: CLOSE get_plan_from_results;
224: RETURN FND_API.G_RET_STS_ERROR;
225: END IF;
226:

Line 232: FND_MSG_PUB.add;

228: END LOOP;
229:
230: IF ( l_element_count = 1 ) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_NOT_FOUND' );
232: FND_MSG_PUB.add;
233: RETURN FND_API.G_RET_STS_ERROR;
234: END IF;
235:
236: END IF;

Line 256: FND_MSG_PUB.add;

252: END LOOP;
253:
254: IF ( l_match_found = FALSE ) THEN
255: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );
256: FND_MSG_PUB.add;
257: RETURN FND_API.G_RET_STS_ERROR;
258: END IF;
259:
260: l_match_found := FALSE;

Line 275: FND_MSG_PUB.add;

271: END LOOP;
272:
273: IF ( l_match_found = FALSE ) THEN
274: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );
275: FND_MSG_PUB.add;
276: RETURN FND_API.G_RET_STS_ERROR;
277: END IF;
278:
279: l_match_found := FALSE;

Line 326: FND_MSG_PUB.add;

322:
323: IF ( l_unit_effectivity_id IS NULL OR
324: l_object_version_number IS NULL ) THEN
325: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );
326: FND_MSG_PUB.add;
327: RETURN FND_API.G_RET_STS_ERROR;
328: END IF;
329:
330: -- Change to call capture_mr_updates

Line 342: FND_MSG_PUB.add;

338: AND object_version_number = l_object_version_number;
339:
340: IF ( SQL%ROWCOUNT = 0 ) THEN
341: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );
342: FND_MSG_PUB.add;
343: RETURN FND_API.G_RET_STS_ERROR;
344: END IF;
345:
346: ELSIF ( p_transaction_no = G_JOB_TXN_NO ) THEN

Line 351: FND_MSG_PUB.add;

347:
348: IF ( l_workorder_id IS NULL OR
349: l_object_version_number IS NULL ) THEN
350: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );
351: FND_MSG_PUB.add;
352: RETURN FND_API.G_RET_STS_ERROR;
353: END IF;
354:
355: UPDATE AHL_WORKORDERS

Line 366: FND_MSG_PUB.add;

362: AND object_version_number = l_object_version_number;
363:
364: IF ( SQL%ROWCOUNT = 0 ) THEN
365: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );
366: FND_MSG_PUB.add;
367: RETURN FND_API.G_RET_STS_ERROR;
368: END IF;
369:
370: ELSIF ( p_transaction_no = G_OP_TXN_NO ) THEN

Line 375: FND_MSG_PUB.add;

371:
372: IF ( l_workorder_operation_id IS NULL OR
373: l_object_version_number IS NULL ) THEN
374: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );
375: FND_MSG_PUB.add;
376: RETURN FND_API.G_RET_STS_ERROR;
377: END IF;
378:
379: UPDATE AHL_WORKORDER_OPERATIONS

Line 390: FND_MSG_PUB.add;

386: AND object_version_number = l_object_version_number;
387:
388: IF ( SQL%ROWCOUNT = 0 ) THEN
389: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );
390: FND_MSG_PUB.add;
391: RETURN FND_API.G_RET_STS_ERROR;
392: END IF;
393:
394: ELSIF ( p_transaction_no = G_MRB_TXN_NO ) THEN

Line 526: FND_MSG_PUB.initialize;

522: SAVEPOINT submit_qa_results_PVT;
523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_boolean( p_init_msg_list ) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528:
529: l_return_status :=
530: validate_sqar_inputs

Line 687: FND_MSG_PUB.add;

683: END IF;
684:
685: IF ( l_msg_data IS NULL ) THEN
686: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
687: FND_MSG_PUB.add;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSE
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: x_msg_data := l_msg_data;

Line 755: FND_MSG_PUB.add;

751:
752: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
753: IF ( l_msg_data IS NULL ) THEN
754: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
755: FND_MSG_PUB.add;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSE
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: x_msg_data := l_msg_data;

Line 792: FND_MSG_PUB.count_and_get

788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO submit_qa_results_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.count_and_get
793: (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data

Line 806: FND_MSG_PUB.count_and_get

802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO submit_qa_results_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,
810: p_data => x_msg_data

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

816:
817: WHEN OTHERS THEN
818: ROLLBACK TO submit_qa_results_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
821: THEN
822: FND_MSG_PUB.add_exc_msg
823: (
824: p_pkg_name => G_PKG_NAME,

Line 822: FND_MSG_PUB.add_exc_msg

818: ROLLBACK TO submit_qa_results_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
821: THEN
822: FND_MSG_PUB.add_exc_msg
823: (
824: p_pkg_name => G_PKG_NAME,
825: p_procedure_name => l_api_name,
826: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 829: FND_MSG_PUB.count_and_get

825: p_procedure_name => l_api_name,
826: p_error_text => SUBSTRB(SQLERRM,1,240)
827: );
828: END IF;
829: FND_MSG_PUB.count_and_get
830: (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data

Line 877: FND_MSG_PUB.initialize;

873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: -- Initialize message list if p_init_msg_list is set to TRUE.
876: IF FND_API.to_boolean( p_init_msg_list ) THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:
880: x_char_lov_sql :=
881: QA_SS_LOV_API.get_lov_sql

Line 905: IF FND_MSG_PUB.count_msg > 0 THEN

901: value => p_value
902: );
903:
904: -- Error handling code added by balaji for bug # 4091726
905: IF FND_MSG_PUB.count_msg > 0 THEN
906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908:
909: IF ( x_char_lov_sql IS NULL ) THEN

Line 911: FND_MSG_PUB.add;

907: END IF;
908:
909: IF ( x_char_lov_sql IS NULL ) THEN
910: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );
911: FND_MSG_PUB.add;
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: IF ( G_DEBUG = 'Y' ) THEN

Line 923: FND_MSG_PUB.count_and_get

919: EXCEPTION
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: FND_MSG_PUB.count_and_get
924: (
925: p_encoded => FND_API.G_FALSE,
926: p_count => x_msg_count,
927: p_data => x_msg_data

Line 936: FND_MSG_PUB.count_and_get

932: END IF;
933:
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.count_and_get
937: (
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data

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

945: END IF;
946:
947: WHEN OTHERS THEN
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
950: THEN
951: FND_MSG_PUB.add_exc_msg
952: (
953: p_pkg_name => G_PKG_NAME,

Line 951: FND_MSG_PUB.add_exc_msg

947: WHEN OTHERS THEN
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
950: THEN
951: FND_MSG_PUB.add_exc_msg
952: (
953: p_pkg_name => G_PKG_NAME,
954: p_procedure_name => l_api_name,
955: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 958: FND_MSG_PUB.count_and_get

954: p_procedure_name => l_api_name,
955: p_error_text => SUBSTRB(SQLERRM,1,240)
956: );
957: END IF;
958: FND_MSG_PUB.count_and_get
959: (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data

Line 1000: FND_MSG_PUB.initialize;

996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: -- Initialize message list if p_init_msg_list is set to TRUE.
999: IF FND_API.to_boolean( p_init_msg_list ) THEN
1000: FND_MSG_PUB.initialize;
1001: END IF;
1002:
1003: BEGIN
1004:

Line 1022: FND_MSG_PUB.add;

1018: WHEN NO_DATA_FOUND THEN
1019: x_plan_id := NULL;
1020: IF ( p_module_type = 'JSP' ) THEN
1021: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );
1022: FND_MSG_PUB.add;
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSE
1025: RETURN;
1026: END IF;

Line 1039: FND_MSG_PUB.count_and_get

1035: EXCEPTION
1036:
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MSG_PUB.count_and_get
1040: (
1041: p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data

Line 1052: FND_MSG_PUB.count_and_get

1048: END IF;
1049:
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: FND_MSG_PUB.count_and_get
1053: (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data

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

1061: END IF;
1062:
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1066: THEN
1067: FND_MSG_PUB.add_exc_msg
1068: (
1069: p_pkg_name => G_PKG_NAME,

Line 1067: FND_MSG_PUB.add_exc_msg

1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1066: THEN
1067: FND_MSG_PUB.add_exc_msg
1068: (
1069: p_pkg_name => G_PKG_NAME,
1070: p_procedure_name => l_api_name,
1071: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1074: FND_MSG_PUB.count_and_get

1070: p_procedure_name => l_api_name,
1071: p_error_text => SUBSTRB(SQLERRM,1,240)
1072: );
1073: END IF;
1074: FND_MSG_PUB.count_and_get
1075: (
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data