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_PRD_NONROUTINE_PVT dependencies on FND_MSG_PUB

Line 201: FND_MSG_PUB.Initialize;

197: END IF;
198:
199: -- Initialize message list if p_init_msg_list is set to TRUE
200: IF FND_API.To_Boolean(p_init_msg_list) THEN
201: FND_MSG_PUB.Initialize;
202: END IF;
203:
204: -- Initialize Procedure return status to success
205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 381: IF (FND_MSG_PUB.count_msg > 0) THEN

377:
378: -- NR MR ER -- start
379: /*
380: -- initialize stack if any warning messages from CS APIs exist.
381: IF (FND_MSG_PUB.count_msg > 0) THEN
382: FND_MSG_PUB.Initialize;
383: END IF;
384:
385: IF (G_DEBUG = 'Y') THEN

Line 382: FND_MSG_PUB.Initialize;

378: -- NR MR ER -- start
379: /*
380: -- initialize stack if any warning messages from CS APIs exist.
381: IF (FND_MSG_PUB.count_msg > 0) THEN
382: FND_MSG_PUB.Initialize;
383: END IF;
384:
385: IF (G_DEBUG = 'Y') THEN
386: AHL_DEBUG_PUB.debug('PROC : Calling the Create Task procedure');

Line 394: l_msg_count := FND_MSG_PUB.count_msg;

390:
391: Create_task( p_x_task_tbl => p_x_sr_task_tbl,
392: x_return_status => l_return_status);
393:
394: l_msg_count := FND_MSG_PUB.count_msg;
395:
396: IF ( upper(l_return_status) <> FND_API.G_RET_STS_SUCCESS or l_msg_count>0) THEN
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;

Line 463: Fnd_Msg_Pub.ADD;

459: OPEN cs_sr_status;
460: FETCH cs_sr_status INTO l_sr_status_id;
461: IF ( cs_sr_status%NOTFOUND) THEN
462: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_STATUS_ERROR');
463: Fnd_Msg_Pub.ADD;
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: END IF;
466: */
467:

Line 539: IF (FND_MSG_PUB.count_msg > 0) THEN

535:
536: END IF;
537:
538: -- initialize stack if any warning messages from CS APIs exist.
539: IF (FND_MSG_PUB.count_msg > 0) THEN
540: FND_MSG_PUB.Initialize;
541: END IF;
542:
543: -- Standard check of p_commit

Line 540: FND_MSG_PUB.Initialize;

536: END IF;
537:
538: -- initialize stack if any warning messages from CS APIs exist.
539: IF (FND_MSG_PUB.count_msg > 0) THEN
540: FND_MSG_PUB.Initialize;
541: END IF;
542:
543: -- Standard check of p_commit
544: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 553: FND_MSG_PUB.count_and_get

549: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
550: END IF;
551:
552: -- Count and Get messages
553: FND_MSG_PUB.count_and_get
554: ( p_encoded => fnd_api.g_false,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 568: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
568: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
569: p_data => x_msg_data,
570: p_encoded => fnd_api.g_false);
571:
572: -- Disable debug

Line 581: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
581: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
582: p_data => x_msg_data,
583: p_encoded => fnd_api.g_false);
584:
585: -- Disable debug

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

589:
590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
594: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
595: p_procedure_name => 'Process_Nonroutine_Job',
596: p_error_text => SUBSTR(SQLERRM,1,240));
597: END IF;

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

590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
594: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
595: p_procedure_name => 'Process_Nonroutine_Job',
596: p_error_text => SUBSTR(SQLERRM,1,240));
597: END IF;
598: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 598: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

594: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
595: p_procedure_name => 'Process_Nonroutine_Job',
596: p_error_text => SUBSTR(SQLERRM,1,240));
597: END IF;
598: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
599: p_data => x_msg_data,
600: p_encoded => fnd_api.g_false);
601:
602: -- Disable debug

Line 691: Fnd_Msg_Pub.ADD;

687: (p_x_sr_task_rec.customer_name <> FND_API.G_MISS_CHAR) ) THEN
688: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');
689: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
690: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
691: Fnd_Msg_Pub.ADD;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: END IF;
694:
695: EXCEPTION

Line 699: Fnd_Msg_Pub.ADD;

695: EXCEPTION
696: WHEN NO_DATA_FOUND THEN
697: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_INVALID');
698: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
699: Fnd_Msg_Pub.ADD;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN
702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
703: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);

Line 704: Fnd_Msg_Pub.ADD;

700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN
702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
703: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
704: Fnd_Msg_Pub.ADD;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END;
707:
708:

Line 726: Fnd_Msg_Pub.ADD;

722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_INVALID');
725: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
726: Fnd_Msg_Pub.ADD;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN
729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
730: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);

Line 731: Fnd_Msg_Pub.ADD;

727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN
729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
730: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
731: Fnd_Msg_Pub.ADD;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: END;
734: -- NR MR ER - start
735: -- Balaji added following elseif clause to explicitly pass null to

Line 774: Fnd_Msg_Pub.ADD;

770: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
771: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
772: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
773: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
774: Fnd_Msg_Pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:
778: EXCEPTION

Line 782: Fnd_Msg_Pub.ADD;

778: EXCEPTION
779: WHEN NO_DATA_FOUND THEN
780: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
781: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
782: Fnd_Msg_Pub.ADD;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN
785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
786: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 787: Fnd_Msg_Pub.ADD;

783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN
785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
786: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
787: Fnd_Msg_Pub.ADD;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: END;
790:
791:

Line 811: Fnd_Msg_Pub.ADD;

807: EXCEPTION
808: WHEN NO_DATA_FOUND THEN
809: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
810: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
811: Fnd_Msg_Pub.ADD;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN
814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
815: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 816: Fnd_Msg_Pub.ADD;

812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN
814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
815: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
816: Fnd_Msg_Pub.ADD;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END;
819: -- NR MR ER -- start
820: -- Balaji added following elseif clause to explicitly pass null to

Line 861: Fnd_Msg_Pub.ADD;

857: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) ) THEN
858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
861: Fnd_Msg_Pub.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;
864:
865: EXCEPTION

Line 869: Fnd_Msg_Pub.ADD;

865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 874: Fnd_Msg_Pub.ADD;

870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
874: Fnd_Msg_Pub.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;
877:
878:

Line 899: Fnd_Msg_Pub.ADD;

895: EXCEPTION
896: WHEN NO_DATA_FOUND THEN
897: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
898: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
899: Fnd_Msg_Pub.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN
902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
903: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 904: Fnd_Msg_Pub.ADD;

900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN
902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
903: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
904: Fnd_Msg_Pub.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END;
907: -- NR MR ER -- start
908: -- Balaji added following elseif clause to explicitly pass null to

Line 962: Fnd_Msg_Pub.ADD;

958: -- Part of NR MR ER.
959: IF p_x_sr_task_rec.problem_code IS NULL THEN
960: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
961: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
962: Fnd_Msg_Pub.ADD;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: END IF;
965: -- NR MR ER - end
966:

Line 988: Fnd_Msg_Pub.ADD;

984: -- Part of NR MR ER
985: IF p_x_sr_task_rec.resolution_code IS NULL THEN
986: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
987: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
988: Fnd_Msg_Pub.ADD;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;
991: -- NR MR ER -- end
992:

Line 1026: Fnd_Msg_Pub.ADD;

1022: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1023: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1024: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1025: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1026: Fnd_Msg_Pub.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029:
1030:

Line 1035: Fnd_Msg_Pub.ADD;

1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1034: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1035: Fnd_Msg_Pub.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN
1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1039: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 1040: Fnd_Msg_Pub.ADD;

1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN
1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1039: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1040: Fnd_Msg_Pub.ADD;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: END;
1043:
1044:

Line 1063: Fnd_Msg_Pub.ADD;

1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1062: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1063: Fnd_Msg_Pub.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN
1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1067: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 1068: Fnd_Msg_Pub.ADD;

1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN
1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1067: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1068: Fnd_Msg_Pub.ADD;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END;
1071: -- NR MR ER -- start
1072: -- Balaji added following elseif clause to explicitly pass null to

Line 1113: Fnd_Msg_Pub.ADD;

1109: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1110: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1111: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1112: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1113: Fnd_Msg_Pub.ADD;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:
1117: EXCEPTION

Line 1121: Fnd_Msg_Pub.ADD;

1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1120: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1121: Fnd_Msg_Pub.ADD;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN
1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1125: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 1126: Fnd_Msg_Pub.ADD;

1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN
1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1125: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1126: Fnd_Msg_Pub.ADD;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END;
1129:
1130:

Line 1151: Fnd_Msg_Pub.ADD;

1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1150: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN
1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1155: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 1156: Fnd_Msg_Pub.ADD;

1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN
1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1155: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1156: Fnd_Msg_Pub.ADD;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: END;
1159: -- NR MR ER -- start
1160: -- Balaji added following elseif clause to explicitly pass null to

Line 1191: Fnd_Msg_Pub.ADD;

1187: -- Part of NR MR ER.
1188: IF p_x_sr_task_rec.problem_code IS NULL THEN
1189: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
1190: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
1191: Fnd_Msg_Pub.ADD;
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194: -- NR MR ER -- end
1195:

Line 1216: Fnd_Msg_Pub.ADD;

1212: -- Part of NR MR ER
1213: IF p_x_sr_task_rec.resolution_code IS NULL THEN
1214: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
1215: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
1216: Fnd_Msg_Pub.ADD;
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: END IF;
1219: -- NR MR ER -- end
1220:

Line 1353: Fnd_Msg_Pub.ADD;

1349: -- is null then return error message.
1350: IF (p_x_sr_task_rec.instance_id is null or p_x_sr_task_rec.instance_id = FND_API.G_MISS_NUM) THEN
1351:
1352: Fnd_Message.SET_NAME('AHL','AHL_PRD_INSTANCE_VALUE_REQ');
1353: Fnd_Msg_Pub.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355:
1356: END IF;
1357:

Line 1363: Fnd_Msg_Pub.ADD;

1359: -- return an error message.
1360: IF (p_x_sr_task_rec.originating_wo_id is null or p_x_sr_task_rec.originating_wo_id = FND_API.G_MISS_NUM) THEN
1361:
1362: Fnd_Message.SET_NAME('AHL','AHL_PRD_TASK_ORG_WOID_REQ');
1363: Fnd_Msg_Pub.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365:
1366: END IF;
1367:

Line 1379: Fnd_Msg_Pub.ADD;

1375: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1376: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1377:
1378: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1379: Fnd_Msg_Pub.ADD;
1380: RAISE FND_API.G_EXC_ERROR;
1381:
1382: END IF;
1383: END IF;

Line 1403: FND_MSG_PUB.ADD;

1399: p_item_instance_id => NULL);
1400: IF l_return_status = FND_API.G_TRUE THEN
1401: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_CRT_SR_UNTLCKD');
1402: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1403: FND_MSG_PUB.ADD;
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406: -- rroy
1407: -- ACL Changes

Line 1423: Fnd_Msg_Pub.ADD;

1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1423: Fnd_Msg_Pub.ADD;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:
1427: END IF;

Line 1446: Fnd_Msg_Pub.ADD;

1442: IF( cs_sr_status%NOTFOUND) THEN
1443: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');
1444: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1445: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1446: Fnd_Msg_Pub.ADD;
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: ELSE
1449: FETCH cs_sr_status INTO p_x_sr_task_rec.status_id;
1450: END IF;

Line 1475: Fnd_Msg_Pub.ADD;

1471: IF ( cs_sr_severity_validate%NOTFOUND) THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');
1473: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1474: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1475: Fnd_Msg_Pub.ADD;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478:
1479: CLOSE cs_sr_severity_validate;

Line 1484: Fnd_Msg_Pub.ADD;

1480: ELSE
1481: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');
1482: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1483: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1484: Fnd_Msg_Pub.ADD;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487:
1488: END IF;

Line 1507: Fnd_Msg_Pub.ADD;

1503:
1504: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');
1505: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1506: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1507: Fnd_Msg_Pub.ADD;
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509:
1510: END IF;
1511:

Line 1538: Fnd_Msg_Pub.ADD;

1534: IF ( default_party_id%NOTFOUND) THEN
1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1537: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);
1538: Fnd_Msg_Pub.ADD;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: END IF;
1541: OPEN owner_customer_type(p_x_sr_task_rec.customer_id);
1542: FETCH owner_customer_type INTO p_x_sr_task_rec.customer_type;

Line 1547: Fnd_Msg_Pub.ADD;

1543: IF ( owner_customer_type%NOTFOUND) THEN
1544: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid
1545: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1546: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1547: Fnd_Msg_Pub.ADD;
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: END IF;
1550:
1551: CLOSE owner_customer_type;

Line 1559: Fnd_Msg_Pub.ADD;

1555: IF ( default_contact%NOTFOUND ) THEN
1556: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1557: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1558: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1559: Fnd_Msg_Pub.ADD;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ELSE
1562: p_x_sr_task_rec.contact_type := 'EMPLOYEE';
1563: END IF;

Line 1575: Fnd_Msg_Pub.ADD;

1571: IF( l_owner_id <> nvl(p_x_sr_task_rec.customer_id,l_owner_id) and
1572: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1573: Fnd_Message.SET_NAME('AHL','AHL_PRD_INVALID_OWNER'); -- New Error Message Should be added
1574: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1575: Fnd_Msg_Pub.ADD;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: END IF;
1578:
1579: END IF;

Line 1597: Fnd_Msg_Pub.ADD;

1593: IF ( default_customer_type%NOTFOUND) THEN
1594: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1595: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1597: Fnd_Msg_Pub.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE
1600: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1601: END IF;

Line 1611: Fnd_Msg_Pub.ADD;

1607: IF ( default_contact%NOTFOUND ) THEN
1608: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1609: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1610: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1611: Fnd_Msg_Pub.ADD;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: ELSE
1614: p_x_sr_task_rec.contact_type := 'EMPLOYEE';
1615: END IF;

Line 1624: Fnd_Msg_Pub.ADD;

1620:
1621: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');
1622: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1623: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1624: Fnd_Msg_Pub.ADD;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1627: END IF;
1628:

Line 1640: Fnd_Msg_Pub.ADD;

1636:
1637: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');
1638: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1639: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1640: Fnd_Msg_Pub.ADD;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642:
1643: END IF;
1644:

Line 1654: Fnd_Msg_Pub.ADD;

1650:
1651: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1652: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1653: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1654: Fnd_Msg_Pub.ADD;
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656:
1657: END IF;
1658:

Line 1668: Fnd_Msg_Pub.ADD;

1664:
1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1668: Fnd_Msg_Pub.ADD;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: -- If Contact is not null but Customer is null then
1672: -- return an error message.

Line 1679: Fnd_Msg_Pub.ADD;

1675:
1676: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');
1677: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1678: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1679: Fnd_Msg_Pub.ADD;
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: END IF;
1683:

Line 1692: Fnd_Msg_Pub.ADD;

1688:
1689: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');
1690: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1691: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1692: Fnd_Msg_Pub.ADD;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694:
1695: END IF;
1696: --amsriniv. Issue 105. Begin ER 6014567

Line 1699: Fnd_Msg_Pub.ADD;

1695: END IF;
1696: --amsriniv. Issue 105. Begin ER 6014567
1697: IF (p_x_sr_task_rec.instance_quantity IS NOT NULL AND p_x_sr_task_rec.instance_quantity <= 0) THEN
1698: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');
1699: Fnd_Msg_Pub.ADD;
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: END IF;
1702:
1703: IF (upper(p_x_sr_task_rec.WO_Create_flag) = 'N') THEN

Line 1709: Fnd_Msg_Pub.ADD;

1705: FETCH check_inst_nonserial INTO l_dummy;
1706: IF (check_inst_nonserial%FOUND) THEN
1707: Fnd_Message.SET_NAME('AHL','AHL_NO_CREATE_WO_NONSER');
1708: Fnd_Message.SET_TOKEN('FIELD',l_instance_num);
1709: Fnd_Msg_Pub.ADD;
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711: END IF;
1712: CLOSE check_inst_nonserial;
1713: END IF;

Line 1723: Fnd_Msg_Pub.ADD;

1719: IF (validate_quantity%NOTFOUND) THEN
1720: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');
1721: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);
1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);

Line 1731: Fnd_Msg_Pub.ADD;

1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734: ELSE
1735: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');

Line 1736: Fnd_Msg_Pub.ADD;

1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734: ELSE
1735: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');
1736: Fnd_Msg_Pub.ADD;
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: END IF;
1739: END IF;
1740: --amsriniv. Issue 105. End ER 6014567

Line 1756: Fnd_Msg_Pub.ADD;

1752: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1753: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1754:
1755: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1756: Fnd_Msg_Pub.ADD;
1757: RAISE FND_API.G_EXC_ERROR;
1758:
1759: END IF;
1760: END IF;

Line 1779: FND_MSG_PUB.ADD;

1775: p_item_instance_id => NULL);
1776: IF l_return_status = FND_API.G_TRUE THEN
1777: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UPD_SR_UNTLCKD');
1778: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1779: FND_MSG_PUB.ADD;
1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;
1782: -- rroy
1783: -- ACL Changes

Line 1794: Fnd_Msg_Pub.ADD;

1790:
1791: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1792: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1793: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1794: Fnd_Msg_Pub.ADD;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796:
1797: END IF;
1798:

Line 1808: Fnd_Msg_Pub.ADD;

1804:
1805: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1806: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1807: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1808: Fnd_Msg_Pub.ADD;
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810:
1811: END IF;
1812:

Line 1822: Fnd_Msg_Pub.ADD;

1818:
1819: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');
1820: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1821: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1822: Fnd_Msg_Pub.ADD;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824:
1825: END IF;
1826:

Line 1837: Fnd_Msg_Pub.ADD;

1833:
1834: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');
1835: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1836: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1837: Fnd_Msg_Pub.ADD;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: END IF;
1841:

Line 1852: Fnd_Msg_Pub.ADD;

1848:
1849: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');
1850: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1851: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1852: Fnd_Msg_Pub.ADD;
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:
1856: END IF;

Line 1955: Fnd_Msg_Pub.ADD;

1951: open default_item_org_id(p_x_sr_task_rec.Originating_wo_id);
1952: Fetch default_item_org_id INTO l_service_request_rec.inventory_item_id,l_service_request_rec.inventory_org_id;
1953: IF (default_item_org_id%NOTFOUND ) THEN
1954: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');
1955: Fnd_Msg_Pub.ADD;
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: END IF;
1958:
1959: open default_incident_type_id;

Line 1964: Fnd_Msg_Pub.ADD;

1960: Fetch default_incident_type_id INTO l_service_request_rec.type_id,l_service_request_rec.type_name;
1961:
1962: IF ( default_incident_type_id%NOTFOUND) THEN
1963: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');
1964: Fnd_Msg_Pub.ADD;
1965: x_return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967: CLOSE default_item_org_id;
1968: CLOSE default_incident_type_id;

Line 2073: Fnd_Msg_Pub.ADD;

2069: EXCEPTION
2070:
2071: WHEN OTHERS THEN
2072: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');
2073: Fnd_Msg_Pub.ADD;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075:
2076: END;
2077:

Line 2271: FND_MSG_PUB.ADD;

2267: THEN
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR');
2270: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;
2274: CLOSE c_get_ue_id;
2275:

Line 2578: Fnd_Msg_Pub.ADD;

2574: If GetOrgTaskDet%Found and GetOrgTaskDet%rowcount >1
2575: Then
2576: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TASK_ID_NOT_UNIQUE');
2577: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2578: Fnd_Msg_Pub.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ElsIf GetOrgTaskDet%NotFound
2581: Then
2582: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');

Line 2584: Fnd_Msg_Pub.ADD;

2580: ElsIf GetOrgTaskDet%NotFound
2581: Then
2582: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');
2583: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2584: Fnd_Msg_Pub.ADD;
2585: RAISE FND_API.G_EXC_ERROR;
2586: End if;
2587: Close GetOrgTaskDet;
2588:

Line 2623: Fnd_Msg_Pub.ADD;

2619: IF getUnitEffectivity%NotFound
2620: Then
2621: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR'); -- New Message needed to be added
2622: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2623: Fnd_Msg_Pub.ADD;
2624: RAISE FND_API.G_EXC_ERROR;
2625: End if;
2626: Close getUnitEffectivity;
2627: l_create_job_task_tbl(i).unit_effectivity_id := l_unit_effectivity_id;

Line 2684: l_msg_count := FND_MSG_PUB.count_msg;

2680: -- even though visit validation fails. The validation errors are put in the
2681: -- error stack. In this case, the WO creation api will not be called and
2682: -- wo_id returned is null. Task is created.
2683:
2684: l_msg_count := FND_MSG_PUB.count_msg;
2685:
2686: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_count > 0) THEN
2687:
2688: IF (l_debug_UEXP >= l_debug_LEVEL) THEN