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

Line 171: Fnd_Msg_Pub.initialize;

167: END IF;
168: END IF;
169:
170: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
171: Fnd_Msg_Pub.initialize;
172: END IF;
173:
174: -- Initialize API return status to success
175: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 258: Fnd_Msg_Pub.Count_And_Get

254: x_stages_tbl := l_stages_tbl;
255:
256: ------------------------End of API Body------------------------------------
257: -- Standard call to get message count and if count is 1, get message info
258: Fnd_Msg_Pub.Count_And_Get
259: ( p_count => x_msg_count,
260: p_data => x_msg_data,
261: p_encoded => Fnd_Api.g_false);
262:

Line 286: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

282: EXCEPTION
283: WHEN Fnd_Api.G_EXC_ERROR THEN
284: x_return_status := Fnd_Api.G_RET_STS_ERROR;
285: ROLLBACK TO Get_Stages_Details;
286: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => Fnd_Api.g_false);
289: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 292: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

288: p_encoded => Fnd_Api.g_false);
289: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
291: ROLLBACK TO Get_Stages_Details;
292: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => Fnd_Api.g_false);
295: WHEN OTHERS THEN
296: ROLLBACK TO Get_Stages_Details;

Line 298: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

294: p_encoded => Fnd_Api.g_false);
295: WHEN OTHERS THEN
296: ROLLBACK TO Get_Stages_Details;
297: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
298: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
299: THEN
300: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
301: END IF;
302: Fnd_Msg_Pub.count_and_get (

Line 300: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

296: ROLLBACK TO Get_Stages_Details;
297: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
298: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
299: THEN
300: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
301: END IF;
302: Fnd_Msg_Pub.count_and_get (
303: p_encoded => Fnd_Api.g_false,
304: p_count => x_msg_count,

Line 302: Fnd_Msg_Pub.count_and_get (

298: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
299: THEN
300: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
301: END IF;
302: Fnd_Msg_Pub.count_and_get (
303: p_encoded => Fnd_Api.g_false,
304: p_count => x_msg_count,
305: p_data => x_msg_data );
306:

Line 362: Fnd_Msg_Pub.initialize;

358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF Fnd_Api.to_boolean(p_init_msg_list)
361: THEN
362: Fnd_Msg_Pub.initialize;
363: END IF;
364:
365: -- Initialize API return status to success
366: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 398: Fnd_Msg_Pub.ADD;

394: --
395: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
396: THEN
397: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
398: Fnd_Msg_Pub.ADD;
399: END IF;
400:
401: --
402: -- Check profile

Line 409: Fnd_Msg_Pub.ADD;

405: -- Modified by amagrawa as per review comments.
406: If l_stage_count is null
407: then
408: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_DEF');
409: Fnd_Msg_Pub.ADD;
410: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: ELSIF l_stage_count <= 0
413: then

Line 415: Fnd_Msg_Pub.ADD;

411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: ELSIF l_stage_count <= 0
413: then
414: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_GT_ZERO');
415: Fnd_Msg_Pub.ADD;
416: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: ELSIF l_stage_count <> floor(l_stage_count)
419: then

Line 421: Fnd_Msg_Pub.ADD;

417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: ELSIF l_stage_count <> floor(l_stage_count)
419: then
420: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_INT');
421: Fnd_Msg_Pub.ADD;
422: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
423: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:

Line 428: l_msg_count := Fnd_Msg_Pub.count_msg;

424: END IF;
425:
426:
427: /* --Standard check to count messages
428: l_msg_count := Fnd_Msg_Pub.count_msg;
429:
430: IF l_msg_count > 0 THEN
431: x_msg_count := l_msg_count;
432: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 492: l_msg_count := Fnd_Msg_Pub.count_msg;

488: END LOOP;
489:
490: ---------------------------End of API Body---------------------------------------
491: --Standard check to count messages
492: l_msg_count := Fnd_Msg_Pub.count_msg;
493:
494: IF l_msg_count > 0 THEN
495: X_msg_count := l_msg_count;
496: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 517: Fnd_Msg_Pub.count_and_get(

513: EXCEPTION
514: WHEN Fnd_Api.g_exc_error THEN
515: ROLLBACK TO Create_Stage;
516: x_return_status := Fnd_Api.g_ret_sts_error;
517: Fnd_Msg_Pub.count_and_get(
518: p_encoded => Fnd_Api.g_false,
519: p_count => x_msg_count,
520: p_data => x_msg_data
521: );

Line 525: Fnd_Msg_Pub.count_and_get (

521: );
522: WHEN Fnd_Api.g_exc_unexpected_error THEN
523: ROLLBACK TO Create_Stage;
524: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
525: Fnd_Msg_Pub.count_and_get (
526: p_encoded => Fnd_Api.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );

Line 533: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

529: );
530: WHEN OTHERS THEN
531: ROLLBACK TO Create_Stage;
532: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
533: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
534: THEN
535: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
536: END IF;
537: Fnd_Msg_Pub.count_and_get (

Line 535: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

531: ROLLBACK TO Create_Stage;
532: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
533: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
534: THEN
535: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
536: END IF;
537: Fnd_Msg_Pub.count_and_get (
538: p_encoded => Fnd_Api.g_false,
539: p_count => x_msg_count,

Line 537: Fnd_Msg_Pub.count_and_get (

533: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
534: THEN
535: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
536: END IF;
537: Fnd_Msg_Pub.count_and_get (
538: p_encoded => Fnd_Api.g_false,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );

Line 621: Fnd_Msg_Pub.initialize;

617:
618: -- Initialize message list if p_init_msg_list is set to TRUE.
619: IF Fnd_Api.to_boolean(p_init_msg_list)
620: THEN
621: Fnd_Msg_Pub.initialize;
622: END IF;
623:
624: -- Initialize API return status to success
625: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 643: Fnd_Msg_Pub.ADD;

639: --
640: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
641: THEN
642: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NOT_FOUND');
643: Fnd_Msg_Pub.ADD;
644: -- Added by amagrawa based on review commenst
645: RAISE Fnd_Api.G_EXC_ERROR;
646: END IF;
647:

Line 655: Fnd_Msg_Pub.ADD;

651: fetch c_check_visit_status into l_visit_status;
652: if c_check_visit_status%notfound
653: then
654: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_STATUS_INV');
655: Fnd_Msg_Pub.ADD;
656: -- Added by amagrawa based on review commenst
657: close c_check_visit_status;
658: RAISE Fnd_Api.G_EXC_ERROR;
659: end if;

Line 664: l_msg_count := Fnd_Msg_Pub.count_msg;

660: close c_check_visit_status;
661:
662: -- Commented by amagrawa as per review commenst.
663: /* --Standard check to count messages
664: l_msg_count := Fnd_Msg_Pub.count_msg;
665:
666: IF l_msg_count > 0 THEN
667: x_msg_count := l_msg_count;
668: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 718: Fnd_Msg_Pub.ADD;

714: IF C_JOB%FOUND
715: THEN
716: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');
717: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);
718: Fnd_Msg_Pub.ADD;
719: l_validate_status := Fnd_Api.G_RET_STS_ERROR;
720: END IF;
721: CLOSE C_JOB;
722: END IF;

Line 823: l_msg_count := Fnd_Msg_Pub.count_msg;

819: END IF;
820:
821:
822: --Standard check to count messages
823: l_msg_count := Fnd_Msg_Pub.count_msg;
824:
825: IF l_msg_count > 0 THEN
826: X_msg_count := l_msg_count;
827: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 848: Fnd_Msg_Pub.count_and_get(

844: EXCEPTION
845: WHEN Fnd_Api.g_exc_error THEN
846: ROLLBACK TO Update_Stages;
847: x_return_status := Fnd_Api.g_ret_sts_error;
848: Fnd_Msg_Pub.count_and_get(
849: p_encoded => Fnd_Api.g_false,
850: p_count => x_msg_count,
851: p_data => x_msg_data
852: );

Line 856: Fnd_Msg_Pub.count_and_get (

852: );
853: WHEN Fnd_Api.g_exc_unexpected_error THEN
854: ROLLBACK TO Update_Stages;
855: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
856: Fnd_Msg_Pub.count_and_get (
857: p_encoded => Fnd_Api.g_false,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );

Line 864: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

860: );
861: WHEN OTHERS THEN
862: ROLLBACK TO Update_Stages;
863: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
864: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
865: THEN
866: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
867: END IF;
868: Fnd_Msg_Pub.count_and_get (

Line 866: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

862: ROLLBACK TO Update_Stages;
863: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
864: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
865: THEN
866: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
867: END IF;
868: Fnd_Msg_Pub.count_and_get (
869: p_encoded => Fnd_Api.g_false,
870: p_count => x_msg_count,

Line 868: Fnd_Msg_Pub.count_and_get (

864: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
865: THEN
866: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
867: END IF;
868: Fnd_Msg_Pub.count_and_get (
869: p_encoded => Fnd_Api.g_false,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 921: Fnd_Msg_Pub.initialize;

917:
918: -- Initialize message list if p_init_msg_list is set to TRUE.
919: IF Fnd_Api.to_boolean(p_init_msg_list)
920: THEN
921: Fnd_Msg_Pub.initialize;
922: END IF;
923:
924: -- Initialize API return status to success
925: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 950: l_msg_count := Fnd_Msg_Pub.count_msg;

946: -- directly delete as we need to delete all stages for the visit
947:
948: ---------------------------End of API Body---------------------------------------
949: --Standard check to count messages
950: l_msg_count := Fnd_Msg_Pub.count_msg;
951:
952: IF l_msg_count > 0 THEN
953: X_msg_count := l_msg_count;
954: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 975: Fnd_Msg_Pub.count_and_get(

971: EXCEPTION
972: WHEN Fnd_Api.g_exc_error THEN
973: ROLLBACK TO Delete_Stages;
974: x_return_status := Fnd_Api.g_ret_sts_error;
975: Fnd_Msg_Pub.count_and_get(
976: p_encoded => Fnd_Api.g_false,
977: p_count => x_msg_count,
978: p_data => x_msg_data
979: );

Line 983: Fnd_Msg_Pub.count_and_get (

979: );
980: WHEN Fnd_Api.g_exc_unexpected_error THEN
981: ROLLBACK TO Delete_Stages;
982: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
983: Fnd_Msg_Pub.count_and_get (
984: p_encoded => Fnd_Api.g_false,
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );

Line 991: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

987: );
988: WHEN OTHERS THEN
989: ROLLBACK TO Delete_Stages;
990: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
991: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
992: THEN
993: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
994: END IF;
995: Fnd_Msg_Pub.count_and_get (

Line 993: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

989: ROLLBACK TO Delete_Stages;
990: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
991: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
992: THEN
993: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
994: END IF;
995: Fnd_Msg_Pub.count_and_get (
996: p_encoded => Fnd_Api.g_false,
997: p_count => x_msg_count,

Line 995: Fnd_Msg_Pub.count_and_get (

991: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
992: THEN
993: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
994: END IF;
995: Fnd_Msg_Pub.count_and_get (
996: p_encoded => Fnd_Api.g_false,
997: p_count => x_msg_count,
998: p_data => x_msg_data
999: );

Line 1066: Fnd_Msg_Pub.initialize;

1062: END IF;
1063: END IF;
1064:
1065: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1066: Fnd_Msg_Pub.initialize;
1067: END IF;
1068:
1069: IF NOT Fnd_Api.compatible_api_call (
1070: l_api_version,

Line 1085: Fnd_Msg_Pub.ADD;

1081: fetch c_stage_data into l_stage_rec;
1082: if c_stage_data%notfound
1083: then
1084: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_stages_rec.stage_id);
1085: Fnd_Msg_Pub.ADD;
1086: x_return_status := Fnd_Api.g_ret_sts_error;
1087: return;
1088: end if;
1089: close c_stage_data;

Line 1095: Fnd_Msg_Pub.ADD;

1091: -- obj version number validation
1092: IF l_stage_rec.OBJECT_VERSION_NUMBER <> p_stages_rec.OBJECT_VERSION_NUMBER
1093: THEN
1094: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');
1095: Fnd_Msg_Pub.ADD;
1096: x_return_status := Fnd_Api.g_ret_sts_error;
1097: return;
1098: end if;
1099:

Line 1103: Fnd_Msg_Pub.ADD;

1099:
1100: IF p_stages_rec.STAGE_NUM IS NULL
1101: THEN
1102: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_NULL');
1103: Fnd_Msg_Pub.ADD;
1104: x_return_status := Fnd_Api.g_ret_sts_error;
1105: return;
1106: end if;
1107:

Line 1116: Fnd_Msg_Pub.ADD;

1112: if p_stages_rec.stage_name is null or p_stages_rec.stage_name = ''
1113: then
1114: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');
1115: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);
1116: Fnd_Msg_Pub.ADD;
1117: x_return_status := Fnd_Api.g_ret_sts_error;
1118: return;
1119: else
1120: -- stage name is unique

Line 1127: Fnd_Msg_Pub.ADD;

1123: if c_stage_name%found
1124: then
1125: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');
1126: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1127: Fnd_Msg_Pub.ADD;
1128: x_return_status := Fnd_Api.g_ret_sts_error;
1129: close c_stage_name;
1130: return;
1131: end if;

Line 1144: Fnd_Msg_Pub.ADD;

1140: IF p_stages_rec.DURATION IS NULL
1141: then
1142: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');
1143: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1144: Fnd_Msg_Pub.ADD;
1145: x_return_status := Fnd_Api.g_ret_sts_error;
1146: -- duration must be positive number
1147: elsif p_stages_rec.duration < 0
1148: then

Line 1151: Fnd_Msg_Pub.ADD;

1147: elsif p_stages_rec.duration < 0
1148: then
1149: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
1150: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := Fnd_Api.g_ret_sts_error;
1153: elsif p_stages_rec.duration = 0
1154: then
1155: open c_stage_task( p_stages_rec.stage_id);

Line 1161: Fnd_Msg_Pub.ADD;

1157: if c_stage_task%found
1158: THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');
1160: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1161: Fnd_Msg_Pub.ADD;
1162: x_return_status := Fnd_Api.g_ret_sts_error;
1163: end if;
1164: close c_stage_task;
1165: elsif p_stages_rec.DURATION > trunc(l_stage_duration,0)

Line 1168: Fnd_Msg_Pub.ADD;

1164: close c_stage_task;
1165: elsif p_stages_rec.DURATION > trunc(l_stage_duration,0)
1166: THEN
1167: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NON_INT');
1168: Fnd_Msg_Pub.ADD;
1169: x_return_status := Fnd_Api.g_ret_sts_error;
1170:
1171: end if;
1172:

Line 1305: Fnd_Msg_Pub.initialize;

1301: END IF;
1302: END IF;
1303:
1304: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1305: Fnd_Msg_Pub.initialize;
1306: END IF;
1307:
1308: IF NOT Fnd_Api.compatible_api_call (
1309: l_api_version,

Line 1335: Fnd_Msg_Pub.ADD;

1331: OPEN C_STAGE_NUM(p_visit_id, p_stage_name);
1332: FETCH C_STAGE_NUM INTO L_STAGE_NUM, L_STAGE_ID;
1333: IF C_STAGE_NUM%NOTFOUND THEN
1334: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND');
1335: Fnd_Msg_Pub.ADD;
1336: x_return_status := Fnd_Api.g_ret_sts_error;
1337: ELSE
1338: -- Stage number should be between Parent Stage Number - L_MAX_PARENT, and Child Stage Number - L_MIN_CHILD
1339: IF ( L_MAX_PARENT IS NOT NULL AND L_STAGE_NUM < L_MAX_PARENT)

Line 1344: Fnd_Msg_Pub.ADD;

1340: OR ( L_MIN_CHILD IS NOT NULL AND L_STAGE_NUM > L_MIN_CHILD)
1341: THEN
1342: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
1343: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
1344: Fnd_Msg_Pub.ADD;
1345: x_return_status := Fnd_Api.g_ret_sts_error;
1346: END IF;
1347: -- SET OUT PARAM
1348: X_STAGE_ID := L_STAGE_ID;

Line 1512: Fnd_Msg_Pub.ADD;

1508:
1509: IF(c_visit_rec.START_DATE_TIME IS NULL OR c_visit_rec.START_DATE_TIME = Fnd_Api.g_miss_date)
1510: THEN
1511: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_ST_DATE');
1512: Fnd_Msg_Pub.ADD;
1513: x_valid_flag := 'N';
1514: END IF;
1515:
1516: IF(c_visit_rec.DEPARTMENT_ID IS NULL OR c_visit_rec.DEPARTMENT_ID = Fnd_Api.g_miss_num)

Line 1519: Fnd_Msg_Pub.ADD;

1515:
1516: IF(c_visit_rec.DEPARTMENT_ID IS NULL OR c_visit_rec.DEPARTMENT_ID = Fnd_Api.g_miss_num)
1517: THEN
1518: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');
1519: Fnd_Msg_Pub.ADD;
1520: x_valid_flag := 'N';
1521: ELSE
1522: -- Modified by amagrawa based on review comments
1523: -- To find if the visit dept has department shifts defined

Line 1530: Fnd_Msg_Pub.ADD;

1526: CLOSE c_dept;
1527: IF l_count=0
1528: THEN
1529: Fnd_Message.SET_NAME('AHL','AHL_VWP_VNO_DEP_SFT');
1530: Fnd_Msg_Pub.ADD;
1531: x_valid_flag := 'N';
1532: END IF;
1533: END IF;
1534:

Line 1541: Fnd_Msg_Pub.ADD;

1537: FETCH c_task_dep_exist into l_dummy;
1538: IF(c_task_dep_exist%FOUND)
1539: THEN
1540: Fnd_Message.SET_NAME('AHL','AHL_VWP_TNO_DEP_SFT');
1541: Fnd_Msg_Pub.ADD;
1542: x_valid_flag := 'N';
1543: END IF;
1544: CLOSE c_task_dep_exist;
1545:

Line 1552: Fnd_Msg_Pub.ADD;

1548: OPEN c_route_chk (p_visit_id);
1549: FETCH c_route_chk INTO c_route_chk_rec;
1550: IF c_route_chk%FOUND THEN
1551: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_MR_NOT_VAL');
1552: Fnd_Msg_Pub.ADD;
1553: x_valid_flag := 'N';
1554: END IF;
1555: CLOSE c_route_chk;
1556: