APPS.AHL_PRD_WO_PUB dependencies on FND_MSG_PUB

Line 26: FND_MSG_PUB.ADD;

22: FETCH get_user_id_csr INTO l_user_id;
23: IF get_user_id_csr%NOTFOUND THEN
24: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
25: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
26: FND_MSG_PUB.ADD;
27: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
28: END IF;
29: CLOSE get_user_id_csr;
30:

Line 167: FND_MSG_PUB.Initialize;

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: IF FND_API.To_Boolean(p_init_msg_list) THEN
167: FND_MSG_PUB.Initialize;
168: END IF;
169:
170:
171:

Line 175: FND_MSG_PUB.ADD;

171:
172:
173: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
174: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
175: FND_MSG_PUB.ADD;
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
178: l_workorder_id := get_workorder_id(p_WorkorderNumber);
179: ELSE

Line 188: FND_MSG_PUB.ADD;

184: OPEN get_wo_details_csr(l_workorder_id);
185: FETCH get_wo_details_csr INTO l_wo_details;
186: IF(get_wo_details_csr%NOTFOUND)THEN
187: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
188: FND_MSG_PUB.ADD;
189: CLOSE get_wo_details_csr;
190: RAISE FND_API.G_EXC_ERROR;
191: ELSE
192: x_WO_DETAILS_REC.WorkorderId := l_wo_details.WORKORDER_ID;

Line 251: FND_MSG_PUB.Initialize;

247: x_WO_DETAILS_REC.HoldReasonCode := l_wo_details.HOLD_REASON_CODE;
248: x_WO_DETAILS_REC.HoldReason := l_wo_details.HOLD_REASON;
249: x_WO_DETAILS_REC.IsUnitQuarantined := l_wo_details.UNIT_QUARANTINE_FLAG;
250: x_WO_DETAILS_REC.IsCompleteEnabled := AHL_COMPLETIONS_PVT.Is_Complete_Enabled(l_wo_details.WORKORDER_ID, NULL, NULL, 'T');
251: FND_MSG_PUB.Initialize;
252: x_WO_DETAILS_REC.IsPartsChangeEnabled := AHL_PRD_UTIL_PKG.Is_PartChange_Enabled(l_wo_details.WORKORDER_ID,'T');
253: FND_MSG_PUB.Initialize;
254:
255: IF(x_WO_DETAILS_REC.StatusCode NOT IN ('22','7','12','1','7','4','5') AND x_WO_DETAILS_REC.IsUnitQuarantined = 'F')THEN

Line 253: FND_MSG_PUB.Initialize;

249: x_WO_DETAILS_REC.IsUnitQuarantined := l_wo_details.UNIT_QUARANTINE_FLAG;
250: x_WO_DETAILS_REC.IsCompleteEnabled := AHL_COMPLETIONS_PVT.Is_Complete_Enabled(l_wo_details.WORKORDER_ID, NULL, NULL, 'T');
251: FND_MSG_PUB.Initialize;
252: x_WO_DETAILS_REC.IsPartsChangeEnabled := AHL_PRD_UTIL_PKG.Is_PartChange_Enabled(l_wo_details.WORKORDER_ID,'T');
253: FND_MSG_PUB.Initialize;
254:
255: IF(x_WO_DETAILS_REC.StatusCode NOT IN ('22','7','12','1','7','4','5') AND x_WO_DETAILS_REC.IsUnitQuarantined = 'F')THEN
256: x_WO_DETAILS_REC.IsNonRoutineCreationEnabled := 'T';
257: ELSE

Line 266: FND_MSG_PUB.Initialize;

262: ELSE
263: x_WO_DETAILS_REC.IsUpdateEnabled := 'T';
264: END IF;
265: x_WO_DETAILS_REC.IsResTxnEnabled := AHL_PRD_UTIL_PKG.Is_ResTxn_Allowed(l_wo_details.WORKORDER_ID,'T');
266: FND_MSG_PUB.Initialize;
267: IF(l_wo_details.PLAN_ID IS NULL)THEN
268: x_WO_DETAILS_REC.IsQualityEnabled := 'N';
269: /*ELSIF(x_WO_DETAILS_REC.StatusCode IN ('22','7','12','1','7','4','5') OR x_WO_DETAILS_REC.IsUnitQuarantined = 'T')THEN
270: x_WO_DETAILS_REC.IsQualityEnabled := 'F';*/

Line 280: x_msg_count := FND_MSG_PUB.count_msg;

276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: x_msg_count := FND_MSG_PUB.count_msg;
281:
282:
283: x_msg_data := GET_MSG_DATA(x_msg_count);
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 286: x_msg_count := FND_MSG_PUB.count_msg;

282:
283: x_msg_data := GET_MSG_DATA(x_msg_count);
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: x_msg_count := FND_MSG_PUB.count_msg;
287: x_msg_data := GET_MSG_DATA(x_msg_count);
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:

Line 291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

287: x_msg_data := GET_MSG_DATA(x_msg_count);
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
292: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
293: p_procedure_name => l_api_name,
294: p_error_text => SUBSTR(SQLERRM,1,500));
295: END IF;

Line 292: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
292: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
293: p_procedure_name => l_api_name,
294: p_error_text => SUBSTR(SQLERRM,1,500));
295: END IF;
296: x_msg_count := FND_MSG_PUB.count_msg;

Line 296: x_msg_count := FND_MSG_PUB.count_msg;

292: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
293: p_procedure_name => l_api_name,
294: p_error_text => SUBSTR(SQLERRM,1,500));
295: END IF;
296: x_msg_count := FND_MSG_PUB.count_msg;
297: x_msg_data := GET_MSG_DATA(x_msg_count);
298: END get_workorder_details;
299:
300: PROCEDURE get_wo_operations_details

Line 352: FND_MSG_PUB.Initialize;

348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350:
351: IF FND_API.To_Boolean(p_init_msg_list) THEN
352: FND_MSG_PUB.Initialize;
353: END IF;
354: -- Check Error Message stack.
355: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
356: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

Line 357: FND_MSG_PUB.ADD;

353: END IF;
354: -- Check Error Message stack.
355: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
356: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
357: FND_MSG_PUB.ADD;
358: RAISE FND_API.G_EXC_ERROR;
359: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
360: l_workorder_id := get_workorder_id(p_WorkorderNumber);
361: ELSE

Line 365: x_msg_count := FND_MSG_PUB.count_msg;

361: ELSE
362: l_workorder_id := p_WorkorderId;
363: END IF;
364:
365: x_msg_count := FND_MSG_PUB.count_msg;
366: IF x_msg_count > 0 THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:

Line 378: x_msg_count := FND_MSG_PUB.count_msg;

374: ELSE
375: l_workorder_operation_id := p_WoOperationId;
376: END IF;
377:
378: x_msg_count := FND_MSG_PUB.count_msg;
379: IF x_msg_count > 0 THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:

Line 414: x_msg_count := FND_MSG_PUB.count_msg;

410: END IF;
411: l_op_index := l_op_index + 1;
412: END LOOP;
413:
414: x_msg_count := FND_MSG_PUB.count_msg;
415: IF x_msg_count > 0 THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:

Line 422: x_msg_count := FND_MSG_PUB.count_msg;

418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: x_msg_count := FND_MSG_PUB.count_msg;
423:
424:
425: x_msg_data := GET_MSG_DATA(x_msg_count);
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 428: x_msg_count := FND_MSG_PUB.count_msg;

424:
425: x_msg_data := GET_MSG_DATA(x_msg_count);
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: x_msg_count := FND_MSG_PUB.count_msg;
429: x_msg_data := GET_MSG_DATA(x_msg_count);
430: WHEN OTHERS THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432:

Line 433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

429: x_msg_data := GET_MSG_DATA(x_msg_count);
430: WHEN OTHERS THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
435: p_procedure_name => l_api_name,
436: p_error_text => SUBSTR(SQLERRM,1,500));
437: END IF;

Line 434: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

430: WHEN OTHERS THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
435: p_procedure_name => l_api_name,
436: p_error_text => SUBSTR(SQLERRM,1,500));
437: END IF;
438: x_msg_count := FND_MSG_PUB.count_msg;

Line 438: x_msg_count := FND_MSG_PUB.count_msg;

434: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
435: p_procedure_name => l_api_name,
436: p_error_text => SUBSTR(SQLERRM,1,500));
437: END IF;
438: x_msg_count := FND_MSG_PUB.count_msg;
439: x_msg_data := GET_MSG_DATA(x_msg_count);
440: END get_wo_operations_details;
441:
442: PROCEDURE get_wo_mtl_reqmts

Line 503: FND_MSG_PUB.Initialize;

499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;
501:
502: IF FND_API.To_Boolean(p_init_msg_list) THEN
503: FND_MSG_PUB.Initialize;
504: END IF;
505:
506: -- Check Error Message stack.
507: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 509: FND_MSG_PUB.ADD;

505:
506: -- Check Error Message stack.
507: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
508: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
512: l_workorder_id := get_workorder_id(p_WorkorderNumber);
513: ELSE

Line 525: x_msg_count := FND_MSG_PUB.count_msg;

521: ELSE
522: l_workorder_operation_id := p_WoOperationId;
523: END IF;
524:
525: x_msg_count := FND_MSG_PUB.count_msg;
526: IF x_msg_count > 0 THEN
527: RAISE FND_API.G_EXC_ERROR;
528: END IF;
529:

Line 548: x_msg_count := FND_MSG_PUB.count_msg;

544: l_mtl_index := l_mtl_index + 1;
545: END LOOP;
546:
547: -- Check Error Message stack.
548: x_msg_count := FND_MSG_PUB.count_msg;
549: IF x_msg_count > 0 THEN
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:

Line 556: x_msg_count := FND_MSG_PUB.count_msg;

552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: x_msg_count := FND_MSG_PUB.count_msg;
557:
558:
559: x_msg_data := GET_MSG_DATA(x_msg_count);
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 562: x_msg_count := FND_MSG_PUB.count_msg;

558:
559: x_msg_data := GET_MSG_DATA(x_msg_count);
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: x_msg_count := FND_MSG_PUB.count_msg;
563: x_msg_data := GET_MSG_DATA(x_msg_count);
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566:

Line 567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

563: x_msg_data := GET_MSG_DATA(x_msg_count);
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566:
567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
569: p_procedure_name => l_api_name,
570: p_error_text => SUBSTR(SQLERRM,1,500));
571: END IF;

Line 568: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566:
567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
569: p_procedure_name => l_api_name,
570: p_error_text => SUBSTR(SQLERRM,1,500));
571: END IF;
572: x_msg_count := FND_MSG_PUB.count_msg;

Line 572: x_msg_count := FND_MSG_PUB.count_msg;

568: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
569: p_procedure_name => l_api_name,
570: p_error_text => SUBSTR(SQLERRM,1,500));
571: END IF;
572: x_msg_count := FND_MSG_PUB.count_msg;
573: x_msg_data := GET_MSG_DATA(x_msg_count);
574: END get_wo_mtl_reqmts;
575:
576: PROCEDURE get_wo_assoc_documents

Line 678: FND_MSG_PUB.Initialize;

674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: IF FND_API.To_Boolean(p_init_msg_list) THEN
678: FND_MSG_PUB.Initialize;
679: END IF;
680:
681: -- Check Error Message stack.
682: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 684: FND_MSG_PUB.ADD;

680:
681: -- Check Error Message stack.
682: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
683: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
687: l_workorder_id := get_workorder_id(p_WorkorderNumber);
688: ELSE

Line 692: x_msg_count := FND_MSG_PUB.count_msg;

688: ELSE
689: l_workorder_id := p_WorkorderId;
690: END IF;
691:
692: x_msg_count := FND_MSG_PUB.count_msg;
693: IF x_msg_count > 0 THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:

Line 713: x_msg_count := FND_MSG_PUB.count_msg;

709: l_doc_index := l_doc_index +1;
710: END LOOP;
711:
712: -- Check Error Message stack.
713: x_msg_count := FND_MSG_PUB.count_msg;
714: IF x_msg_count > 0 THEN
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:

Line 721: x_msg_count := FND_MSG_PUB.count_msg;

717:
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: x_msg_count := FND_MSG_PUB.count_msg;
722:
723:
724: x_msg_data := GET_MSG_DATA(x_msg_count);
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 727: x_msg_count := FND_MSG_PUB.count_msg;

723:
724: x_msg_data := GET_MSG_DATA(x_msg_count);
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: x_msg_count := FND_MSG_PUB.count_msg;
728: x_msg_data := GET_MSG_DATA(x_msg_count);
729: WHEN OTHERS THEN
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731:

Line 732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

728: x_msg_data := GET_MSG_DATA(x_msg_count);
729: WHEN OTHERS THEN
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731:
732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
733: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
734: p_procedure_name => l_api_name,
735: p_error_text => SUBSTR(SQLERRM,1,500));
736: END IF;

Line 733: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

729: WHEN OTHERS THEN
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731:
732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
733: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
734: p_procedure_name => l_api_name,
735: p_error_text => SUBSTR(SQLERRM,1,500));
736: END IF;
737: x_msg_count := FND_MSG_PUB.count_msg;

Line 737: x_msg_count := FND_MSG_PUB.count_msg;

733: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
734: p_procedure_name => l_api_name,
735: p_error_text => SUBSTR(SQLERRM,1,500));
736: END IF;
737: x_msg_count := FND_MSG_PUB.count_msg;
738: x_msg_data := GET_MSG_DATA(x_msg_count);
739: END get_wo_assoc_documents;
740:
741: PROCEDURE get_wo_turnover_notes

Line 791: FND_MSG_PUB.Initialize;

787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789:
790: IF FND_API.To_Boolean(p_init_msg_list) THEN
791: FND_MSG_PUB.Initialize;
792: END IF;
793:
794: -- Check Error Message stack.
795: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 797: FND_MSG_PUB.ADD;

793:
794: -- Check Error Message stack.
795: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
796: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
797: FND_MSG_PUB.ADD;
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
800: l_workorder_id := get_workorder_id(p_WorkorderNumber);
801: ELSE

Line 805: x_msg_count := FND_MSG_PUB.count_msg;

801: ELSE
802: l_workorder_id := p_WorkorderId;
803: END IF;
804:
805: x_msg_count := FND_MSG_PUB.count_msg;
806: IF x_msg_count > 0 THEN
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809:

Line 823: x_msg_count := FND_MSG_PUB.count_msg;

819: l_notes_index := l_notes_index +1;
820: END LOOP;
821:
822: -- Check Error Message stack.
823: x_msg_count := FND_MSG_PUB.count_msg;
824: IF x_msg_count > 0 THEN
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827: EXCEPTION

Line 830: x_msg_count := FND_MSG_PUB.count_msg;

826: END IF;
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: x_msg_count := FND_MSG_PUB.count_msg;
831:
832:
833: x_msg_data := GET_MSG_DATA(x_msg_count);
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 836: x_msg_count := FND_MSG_PUB.count_msg;

832:
833: x_msg_data := GET_MSG_DATA(x_msg_count);
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: x_msg_count := FND_MSG_PUB.count_msg;
837: x_msg_data := GET_MSG_DATA(x_msg_count);
838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840:

Line 841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

837: x_msg_data := GET_MSG_DATA(x_msg_count);
838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840:
841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
842: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
843: p_procedure_name => l_api_name,
844: p_error_text => SUBSTR(SQLERRM,1,500));
845: END IF;

Line 842: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840:
841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
842: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
843: p_procedure_name => l_api_name,
844: p_error_text => SUBSTR(SQLERRM,1,500));
845: END IF;
846: x_msg_count := FND_MSG_PUB.count_msg;

Line 846: x_msg_count := FND_MSG_PUB.count_msg;

842: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
843: p_procedure_name => l_api_name,
844: p_error_text => SUBSTR(SQLERRM,1,500));
845: END IF;
846: x_msg_count := FND_MSG_PUB.count_msg;
847: x_msg_data := GET_MSG_DATA(x_msg_count);
848: END get_wo_turnover_notes;
849:
850: PROCEDURE get_wo_res_txns

Line 918: FND_MSG_PUB.Initialize;

914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
917: IF FND_API.To_Boolean(p_init_msg_list) THEN
918: FND_MSG_PUB.Initialize;
919: END IF;
920:
921: -- Check Error Message stack.
922: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 924: FND_MSG_PUB.ADD;

920:
921: -- Check Error Message stack.
922: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
923: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
924: FND_MSG_PUB.ADD;
925: RAISE FND_API.G_EXC_ERROR;
926: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
927: l_workorder_id := get_workorder_id(p_WorkorderNumber);
928: ELSE

Line 932: x_msg_count := FND_MSG_PUB.count_msg;

928: ELSE
929: l_workorder_id := p_WorkorderId;
930: END IF;
931:
932: x_msg_count := FND_MSG_PUB.count_msg;
933: IF x_msg_count > 0 THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936:

Line 942: FND_MSG_PUB.ADD;

938: OPEN get_operation_sequence_csr(p_WoOperationId);
939: FETCH get_operation_sequence_csr INTO l_operation_sequence;
940: IF(get_operation_sequence_csr%NOTFOUND)THEN
941: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: CLOSE get_operation_sequence_csr;
946: ELSIF (p_WoOperationId IS NULL AND p_OperationSequence IS NOT NULL)THEN

Line 950: x_msg_count := FND_MSG_PUB.count_msg;

946: ELSIF (p_WoOperationId IS NULL AND p_OperationSequence IS NOT NULL)THEN
947: l_operation_sequence := p_OperationSequence;
948: END IF;
949: -- Check Error Message stack.
950: x_msg_count := FND_MSG_PUB.count_msg;
951: IF x_msg_count > 0 THEN
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954:

Line 1031: x_msg_count := FND_MSG_PUB.count_msg;

1027: END IF;
1028: END LOOP;
1029:
1030: -- Check Error Message stack.
1031: x_msg_count := FND_MSG_PUB.count_msg;
1032: IF x_msg_count > 0 THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1040: x_msg_count := FND_MSG_PUB.count_msg;

1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_ERROR THEN
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: x_msg_count := FND_MSG_PUB.count_msg;
1041:
1042:
1043: x_msg_data := GET_MSG_DATA(x_msg_count);
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1046: x_msg_count := FND_MSG_PUB.count_msg;

1042:
1043: x_msg_data := GET_MSG_DATA(x_msg_count);
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: x_msg_count := FND_MSG_PUB.count_msg;
1047: x_msg_data := GET_MSG_DATA(x_msg_count);
1048: WHEN OTHERS THEN
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050:

Line 1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1047: x_msg_data := GET_MSG_DATA(x_msg_count);
1048: WHEN OTHERS THEN
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050:
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1052: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1053: p_procedure_name => l_api_name,
1054: p_error_text => SUBSTR(SQLERRM,1,500));
1055: END IF;

Line 1052: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1048: WHEN OTHERS THEN
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050:
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1052: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1053: p_procedure_name => l_api_name,
1054: p_error_text => SUBSTR(SQLERRM,1,500));
1055: END IF;
1056: x_msg_count := FND_MSG_PUB.count_msg;

Line 1056: x_msg_count := FND_MSG_PUB.count_msg;

1052: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1053: p_procedure_name => l_api_name,
1054: p_error_text => SUBSTR(SQLERRM,1,500));
1055: END IF;
1056: x_msg_count := FND_MSG_PUB.count_msg;
1057: x_msg_data := GET_MSG_DATA(x_msg_count);
1058: END get_wo_res_txns;
1059:
1060: PROCEDURE get_qa_plan_results

Line 1182: FND_MSG_PUB.Initialize;

1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181: IF FND_API.To_Boolean(p_init_msg_list) THEN
1182: FND_MSG_PUB.Initialize;
1183: END IF;
1184:
1185: -- Check Error Message stack.
1186: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 1188: FND_MSG_PUB.ADD;

1184:
1185: -- Check Error Message stack.
1186: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
1187: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_ERROR;
1190: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
1191: l_workorder_id := get_workorder_id(p_WorkorderNumber);
1192: ELSE

Line 1196: x_msg_count := FND_MSG_PUB.count_msg;

1192: ELSE
1193: l_workorder_id := p_WorkorderId;
1194: END IF;
1195:
1196: x_msg_count := FND_MSG_PUB.count_msg;
1197: IF x_msg_count > 0 THEN
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:

Line 1209: x_msg_count := FND_MSG_PUB.count_msg;

1205: ELSE
1206: l_workorder_operation_id := p_WoOperationId;
1207: END IF;
1208: --l_workorder_operation_id := NULL;
1209: x_msg_count := FND_MSG_PUB.count_msg;
1210: IF x_msg_count > 0 THEN
1211: RAISE FND_API.G_EXC_ERROR;
1212: END IF;
1213:

Line 1350: x_msg_count := FND_MSG_PUB.count_msg;

1346: l_result_row_index := l_result_row_index + 1;
1347: END LOOP;
1348: END IF;
1349: -- Check Error Message stack.
1350: x_msg_count := FND_MSG_PUB.count_msg;
1351:
1352: EXCEPTION
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1355: x_msg_count := FND_MSG_PUB.count_msg;

1351:
1352: EXCEPTION
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: x_msg_count := FND_MSG_PUB.count_msg;
1356:
1357:
1358: x_msg_data := GET_MSG_DATA(x_msg_count);
1359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1361: x_msg_count := FND_MSG_PUB.count_msg;

1357:
1358: x_msg_data := GET_MSG_DATA(x_msg_count);
1359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: x_msg_count := FND_MSG_PUB.count_msg;
1362: x_msg_data := GET_MSG_DATA(x_msg_count);
1363: WHEN OTHERS THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365:

Line 1366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1362: x_msg_data := GET_MSG_DATA(x_msg_count);
1363: WHEN OTHERS THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365:
1366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1367: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1368: p_procedure_name => l_api_name,
1369: p_error_text => SUBSTR(SQLERRM,1,500));
1370: END IF;

Line 1367: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1363: WHEN OTHERS THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365:
1366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1367: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1368: p_procedure_name => l_api_name,
1369: p_error_text => SUBSTR(SQLERRM,1,500));
1370: END IF;
1371: x_msg_count := FND_MSG_PUB.count_msg;

Line 1371: x_msg_count := FND_MSG_PUB.count_msg;

1367: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1368: p_procedure_name => l_api_name,
1369: p_error_text => SUBSTR(SQLERRM,1,500));
1370: END IF;
1371: x_msg_count := FND_MSG_PUB.count_msg;
1372: x_msg_data := GET_MSG_DATA(x_msg_count);
1373: END get_qa_plan_results;
1374:
1375: FUNCTION get_workorder_id(p_WorkorderNumber IN VARCHAR2) RETURN NUMBER

Line 1389: FND_MSG_PUB.ADD;

1385: OPEN get_workorder_id_csr(p_WorkorderNumber);
1386: FETCH get_workorder_id_csr INTO l_workorder_id;
1387: IF(get_workorder_id_csr%NOTFOUND)THEN
1388: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1389: FND_MSG_PUB.ADD;
1390: CLOSE get_workorder_id_csr;
1391: RAISE FND_API.G_EXC_ERROR;
1392: END IF;
1393: CLOSE get_workorder_id_csr;

Line 1412: FND_MSG_PUB.ADD;

1408: OPEN get_workorder_operation_id_csr(p_WorkorderId, p_operation_sequence);
1409: FETCH get_workorder_operation_id_csr INTO l_workorder_operation_id;
1410: IF(get_workorder_operation_id_csr%NOTFOUND)THEN
1411: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1412: FND_MSG_PUB.ADD;
1413: CLOSE get_workorder_operation_id_csr;
1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1416: CLOSE get_workorder_operation_id_csr;

Line 1513: FND_MSG_PUB.ADD;

1509:
1510: IF(l_trunover_notes_tbl IS NOT NULL AND l_trunover_notes_tbl.COUNT > 0)THEN
1511: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1512: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TRNNTREC_NALWD');
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES

Line 1571: FND_MSG_PUB.ADD;

1567: x_return_status := FND_API.G_RET_STS_SUCCESS;
1568:
1569: IF(p_CURR_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1570: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_UPD_NALWD');
1571: FND_MSG_PUB.ADD;
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;
1574:
1575: l_status_code := p_WO_DETAILS_REC.StatusCode;

Line 1582: FND_MSG_PUB.ADD;

1578: OPEN get_status_csr(p_WO_DETAILS_REC.Status);
1579: FETCH get_status_csr INTO l_status_code;
1580: IF get_status_csr%NOTFOUND THEN
1581: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');
1582: FND_MSG_PUB.ADD;
1583: CLOSE get_status_csr;
1584: RAISE FND_API.G_EXC_ERROR;
1585: ELSE
1586: CLOSE get_status_csr;

Line 1598: FND_MSG_PUB.ADD;

1594: IF validate_status_csr%NOTFOUND THEN
1595: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');
1596: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_CURR_WO_DETAILS_REC.StatusCode);
1597: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_status_code);
1598: FND_MSG_PUB.ADD;
1599: CLOSE validate_status_csr;
1600: RAISE FND_API.G_EXC_ERROR;
1601: ELSE
1602: CLOSE validate_status_csr;

Line 1643: FND_MSG_PUB.ADD;

1639: );
1640: ELSIF(l_status_code = '4')THEN
1641: IF(p_CURR_WO_DETAILS_REC.IsCompleteEnabled <> 'T')THEN
1642: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_COMP_NALWD');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: -- complete job
1647: AHL_COMPLETIONS_PVT.complete_workorder

Line 1728: FND_MSG_PUB.ADD;

1724: END IF;
1725:
1726: IF(p_OP_DETAILS_REC.IsQualityEnabled <> 'T')THEN
1727: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPQASUB_NALWD');
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_ERROR;
1730: END IF;
1731:
1732: get_qa_plan_results

Line 1859: FND_MSG_PUB.ADD;

1855: --DBMS_OUTPUT.put_line('x_return_status :i: ' || x_return_status);
1856: IF(p_Operations(i).ObjectVersionNumber IS NULL OR
1857: p_Operations(i).ObjectVersionNumber <> l_Operations(0).ObjectVersionNumber)THEN
1858: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1859: FND_MSG_PUB.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN
1863: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');

Line 1864: FND_MSG_PUB.ADD;

1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN
1863: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1864: FND_MSG_PUB.ADD;
1865: RAISE FND_API.G_EXC_ERROR;
1866: END IF;
1867: process_op_quality
1868: (

Line 1889: FND_MSG_PUB.ADD;

1885: OR p_Operations(i).ActualStartDate IS NOT NULL
1886: or p_operations(i).actualenddate is not null)then
1887: IF(p_Operations(i).StatusCode IS NOT NULL AND p_Operations(i).StatusCode NOT IN ('1','2'))THEN
1888: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1889: FND_MSG_PUB.ADD;
1890: RAISE FND_API.G_EXC_ERROR;
1891: end if;
1892: l_prd_operation_tbl(j).status_code := p_operations(i).statuscode;
1893: l_prd_operation_tbl(j).status_meaning := p_Operations(i).Status;

Line 1899: fnd_msg_pub.add;

1895: open get_op_status_code(p_operations(i).status);
1896: fetch get_op_status_code into l_prd_operation_tbl(j).status_code;
1897: if get_op_status_code%notfound then
1898: fnd_message.set_name('AHL','AHL_PRD_OPUPD_NALWD');
1899: fnd_msg_pub.add;
1900: close get_op_status_code;
1901: raise fnd_api.g_exc_error;
1902: end if;
1903: close get_op_status_code;

Line 2053: FND_MSG_PUB.ADD;

2049: RETURN;
2050: END IF;
2051: IF(p_WO_DETAILS_REC.IsQualityEnabled <> 'T')THEN
2052: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WOQASUB_NALWD');
2053: FND_MSG_PUB.ADD;
2054: RAISE FND_API.G_EXC_ERROR;
2055: END IF;
2056:
2057: get_qa_plan_results

Line 2174: FND_MSG_PUB.ADD;

2170:
2171: IF(l_res_txns_tbl IS NOT NULL AND l_res_txns_tbl.COUNT > 0)THEN
2172: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
2173: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_NALWD');
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;
2176: END IF;
2177: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns
2178: (

Line 2238: FND_MSG_PUB.Initialize;

2234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2235: END IF;
2236:
2237: IF FND_API.To_Boolean(p_init_msg_list) THEN
2238: FND_MSG_PUB.Initialize;
2239: END IF;
2240: -- Initialize API return status to success
2241:
2242: --AHL_DEBUG_PUB.debug( 'p_WO_DETAILS_REC.WorkorderId : '||p_WO_DETAILS_REC.WorkorderId);

Line 2263: FND_MSG_PUB.ADD;

2259: IF(p_WO_DETAILS_REC.ObjectVersionNumber IS NULL OR
2260: p_WO_DETAILS_REC.ObjectVersionNumber <> l_WO_DETAILS_REC.ObjectVersionNumber)THEN
2261: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');
2262: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2263: FND_MSG_PUB.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: END IF;
2266: process_turnover_notes(
2267: p_WO_DETAILS_REC => l_WO_DETAILS_REC,

Line 2348: x_msg_count := FND_MSG_PUB.count_msg;

2344: EXCEPTION
2345: WHEN FND_API.G_EXC_ERROR THEN
2346: ROLLBACK TO PROCESS_WORKORDER;
2347: x_return_status := FND_API.G_RET_STS_ERROR;
2348: x_msg_count := FND_MSG_PUB.count_msg;
2349:
2350:
2351: x_msg_data := GET_MSG_DATA(x_msg_count);
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2355: x_msg_count := FND_MSG_PUB.count_msg;

2351: x_msg_data := GET_MSG_DATA(x_msg_count);
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353: ROLLBACK TO PROCESS_WORKORDER;
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: x_msg_count := FND_MSG_PUB.count_msg;
2356: x_msg_data := GET_MSG_DATA(x_msg_count);
2357: WHEN OTHERS THEN
2358: ROLLBACK TO PROCESS_WORKORDER;
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2357: WHEN OTHERS THEN
2358: ROLLBACK TO PROCESS_WORKORDER;
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360:
2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2362: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2363: p_procedure_name => l_api_name,
2364: p_error_text => SUBSTR(SQLERRM,1,500));
2365: END IF;

Line 2362: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2358: ROLLBACK TO PROCESS_WORKORDER;
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360:
2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2362: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2363: p_procedure_name => l_api_name,
2364: p_error_text => SUBSTR(SQLERRM,1,500));
2365: END IF;
2366: x_msg_count := FND_MSG_PUB.count_msg;

Line 2366: x_msg_count := FND_MSG_PUB.count_msg;

2362: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2363: p_procedure_name => l_api_name,
2364: p_error_text => SUBSTR(SQLERRM,1,500));
2365: END IF;
2366: x_msg_count := FND_MSG_PUB.count_msg;
2367: x_msg_data := GET_MSG_DATA(x_msg_count);
2368: END process_workorder;
2369:
2370:

Line 2520: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

2516: IF (p_msg_count IS NULL)THEN
2517: RETURN NULL;
2518: END IF;
2519: IF (p_msg_count = 1) then
2520: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
2521: p_data => l_temp_msg_data,
2522: p_encoded => fnd_api.g_false);
2523: l_msg_data := '(' || 1 || ')' || l_temp_msg_data;
2524: ELSE

Line 2528: FND_MSG_PUB.get(

2524: ELSE
2525: IF (l_msg_count > 0) THEN
2526: FOR i IN 1..l_msg_count LOOP
2527:
2528: FND_MSG_PUB.get(
2529: p_encoded => 'F',
2530: p_data => l_temp_msg_data,
2531: p_msg_index_out => l_msg_index_out);
2532: IF(i = 1)THEN