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_MESSAGE

Line 598: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');

594: -- Check for the ID.
595: --
596: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
597: THEN
598: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
599: Fnd_Msg_Pub.ADD;
600: END IF;
601:
602: IF G_DEBUG='Y' THEN

Line 623: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_CRT_VST_INV');

619: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');
620: END IF;
621:
622: IF l_is_old_visit = 'Y' THEN
623: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_CRT_VST_INV');
624: Fnd_Msg_Pub.ADD;
625: RAISE Fnd_Api.G_EXC_ERROR;
626: END IF;
627:

Line 651: Fnd_Message.SET_NAME('AHL','AHL_VWP_SEQUENCE_NOT_EXISTS');

647:
648: -- If the value for the ID already exists, then
649: -- l_dummy would be populated with '1', otherwise, it receives NULL.
650: IF l_dummy IS NOT NULL THEN
651: Fnd_Message.SET_NAME('AHL','AHL_VWP_SEQUENCE_NOT_EXISTS');
652: Fnd_Msg_Pub.ADD;
653: END IF;
654:
655: END IF;

Line 677: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_EXISTS');

673:
674: -- If the value for the ID already exists, then
675: -- l_dummy would be populated with '1', otherwise, it receives NULL.
676: IF l_dummy IS NOT NULL THEN
677: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_EXISTS');
678: Fnd_Msg_Pub.ADD;
679: END IF;
680: END IF;
681:

Line 690: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');

686: END IF;
687:
688: --Check for negative
689: IF l_stages_tbl(i).Duration <= 0 THEN
690: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
691: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);
692: Fnd_Msg_Pub.ADD;
693: END IF;
694: IF l_stages_tbl(i).Stage_Num <= 0 THEN

Line 691: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);

687:
688: --Check for negative
689: IF l_stages_tbl(i).Duration <= 0 THEN
690: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
691: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);
692: Fnd_Msg_Pub.ADD;
693: END IF;
694: IF l_stages_tbl(i).Stage_Num <= 0 THEN
695: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_INV');

Line 695: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_INV');

691: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);
692: Fnd_Msg_Pub.ADD;
693: END IF;
694: IF l_stages_tbl(i).Stage_Num <= 0 THEN
695: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_INV');
696: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);
697: Fnd_Msg_Pub.ADD;
698: END IF;
699:

Line 696: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);

692: Fnd_Msg_Pub.ADD;
693: END IF;
694: IF l_stages_tbl(i).Stage_Num <= 0 THEN
695: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_INV');
696: Fnd_Message.SET_TOKEN('STAGE_NAME', l_stages_tbl(i).stage_name);
697: Fnd_Msg_Pub.ADD;
698: END IF;
699:
700: IF l_dept_id is null OR l_visit_start_date is NULL or l_visit_type_code is NULL THEN -- Set dates to null . Since this calculations need all this values to calculate

Line 992: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NOT_FOUND');

988: -- Check for the ID.
989: --
990: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
991: THEN
992: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NOT_FOUND');
993: Fnd_Msg_Pub.ADD;
994: -- Added by amagrawa based on review commenst
995: RAISE Fnd_Api.G_EXC_ERROR;
996: END IF;

Line 1004: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_STATUS_INV');

1000: open c_check_visit_status(p_visit_id);
1001: fetch c_check_visit_status into l_visit_status;
1002: if c_check_visit_status%notfound
1003: then
1004: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_STATUS_INV');
1005: Fnd_Msg_Pub.ADD;
1006: -- Added by amagrawa based on review commenst
1007: close c_check_visit_status;
1008: RAISE Fnd_Api.G_EXC_ERROR;

Line 1093: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');

1089: OPEN C_JOB(P_VISIT_ID, p_x_stages_tbl(i).STAGE_NUM );
1090: FETCH C_JOB INTO L_DUMMY;
1091: IF C_JOB%FOUND
1092: THEN
1093: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');
1094: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);
1095: Fnd_Msg_Pub.ADD;
1096: l_validate_status := Fnd_Api.G_RET_STS_ERROR;
1097: END IF;

Line 1094: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);

1090: FETCH C_JOB INTO L_DUMMY;
1091: IF C_JOB%FOUND
1092: THEN
1093: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');
1094: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);
1095: Fnd_Msg_Pub.ADD;
1096: l_validate_status := Fnd_Api.G_RET_STS_ERROR;
1097: END IF;
1098: CLOSE C_JOB;

Line 1254: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INVLD');

1250: -- PRAKKUM :: 23-FEB-2011 :: Bug 13711800 :: Fix for Operational Visits
1251: l_stage_planned_start_time := Compute_Stage_End_Date(p_visit_id, null, l_visit_start_date, l_dept_id, l_cum_duration);
1252: -- Validate that the any of the tasks does not start before the stage starts
1253: IF l_past_task_start_date < l_stage_planned_start_time THEN
1254: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INVLD');
1255: Fnd_Msg_Pub.ADD;
1256: RAISE Fnd_Api.G_EXC_ERROR;
1257: END IF;
1258: END LOOP;

Line 1459: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_STG_DEL_INV');

1455: FETCH c_visit INTO l_visit_dets;
1456: CLOSE c_visit;
1457:
1458: IF l_visit_dets.IS_OLD_VISIT = 'Y' THEN
1459: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_STG_DEL_INV');
1460: Fnd_Msg_Pub.ADD;
1461: RAISE Fnd_Api.G_EXC_ERROR;
1462: END IF;
1463:

Line 1473: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_x_stages_tbl(i).stage_id);

1469: open c_stage_data(p_x_stages_tbl(i).STAGE_ID);
1470: fetch c_stage_data into l_stage_rec;
1471: if c_stage_data%notfound
1472: then
1473: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_x_stages_tbl(i).stage_id);
1474: Fnd_Msg_Pub.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: end if;
1477: close c_stage_data;

Line 1482: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');

1478:
1479: -- obj version number validation
1480: IF l_stage_rec.OBJECT_VERSION_NUMBER <> p_x_stages_tbl(i).OBJECT_VERSION_NUMBER
1481: THEN
1482: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');
1483: Fnd_Msg_Pub.ADD;
1484: RAISE FND_API.G_EXC_ERROR;
1485: end if;
1486:

Line 1544: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_NO_DEL_HAV_TASKS');

1540: fnd_log.string(l_log_statement,L_DEBUG,'l_stage_tasks_count :'||l_stage_tasks_count);
1541: END IF;
1542:
1543: IF l_stage_tasks_count>0 THEN
1544: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_NO_DEL_HAV_TASKS');
1545: Fnd_Msg_Pub.ADD;
1546: RAISE FND_API.G_EXC_ERROR;
1547: ELSE
1548:

Line 1889: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_stages_rec.stage_id);

1885: open c_stage_data(p_stages_rec.stage_id);
1886: fetch c_stage_data into l_stage_rec;
1887: if c_stage_data%notfound
1888: then
1889: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_stages_rec.stage_id);
1890: Fnd_Msg_Pub.ADD;
1891: x_return_status := Fnd_Api.g_ret_sts_error;
1892: return;
1893: end if;

Line 1906: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');

1902: END IF;
1903: -- obj version number validation
1904: IF l_stage_rec.OBJECT_VERSION_NUMBER <> p_stages_rec.OBJECT_VERSION_NUMBER
1905: THEN
1906: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');
1907: Fnd_Msg_Pub.ADD;
1908: x_return_status := Fnd_Api.g_ret_sts_error;
1909: return;
1910: end if;

Line 1914: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_NULL');

1910: end if;
1911:
1912: IF p_stages_rec.STAGE_NUM IS NULL
1913: THEN
1914: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_NULL');
1915: Fnd_Msg_Pub.ADD;
1916: x_return_status := Fnd_Api.g_ret_sts_error;
1917: return;
1918: end if;

Line 1926: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');

1922: THEN
1923: -- stage name is mandatory
1924: if p_stages_rec.stage_name is null or p_stages_rec.stage_name = ''
1925: then
1926: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');
1927: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);
1928: Fnd_Msg_Pub.ADD;
1929: x_return_status := Fnd_Api.g_ret_sts_error;
1930: return;

Line 1927: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);

1923: -- stage name is mandatory
1924: if p_stages_rec.stage_name is null or p_stages_rec.stage_name = ''
1925: then
1926: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');
1927: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);
1928: Fnd_Msg_Pub.ADD;
1929: x_return_status := Fnd_Api.g_ret_sts_error;
1930: return;
1931: else

Line 1937: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');

1933: open c_stage_name(p_visit_id, p_stages_rec.stage_name, p_stages_rec.stage_id);
1934: fetch c_stage_name into l_dummy;
1935: if c_stage_name%found
1936: then
1937: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');
1938: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1939: Fnd_Msg_Pub.ADD;
1940: x_return_status := Fnd_Api.g_ret_sts_error;
1941: close c_stage_name;

Line 1938: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1934: fetch c_stage_name into l_dummy;
1935: if c_stage_name%found
1936: then
1937: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');
1938: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1939: Fnd_Msg_Pub.ADD;
1940: x_return_status := Fnd_Api.g_ret_sts_error;
1941: close c_stage_name;
1942: return;

Line 1954: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');

1950: THEN
1951: -- STAGE DURATION is mandatory
1952: IF p_stages_rec.DURATION IS NULL
1953: then
1954: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');
1955: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1956: Fnd_Msg_Pub.ADD;
1957: x_return_status := Fnd_Api.g_ret_sts_error;
1958: -- duration must be positive number

Line 1955: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1951: -- STAGE DURATION is mandatory
1952: IF p_stages_rec.DURATION IS NULL
1953: then
1954: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');
1955: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1956: Fnd_Msg_Pub.ADD;
1957: x_return_status := Fnd_Api.g_ret_sts_error;
1958: -- duration must be positive number
1959: elsif p_stages_rec.duration < 0

Line 1961: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');

1957: x_return_status := Fnd_Api.g_ret_sts_error;
1958: -- duration must be positive number
1959: elsif p_stages_rec.duration < 0
1960: then
1961: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
1962: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1963: Fnd_Msg_Pub.ADD;
1964: x_return_status := Fnd_Api.g_ret_sts_error;
1965: elsif p_stages_rec.duration = 0

Line 1962: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1958: -- duration must be positive number
1959: elsif p_stages_rec.duration < 0
1960: then
1961: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
1962: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1963: Fnd_Msg_Pub.ADD;
1964: x_return_status := Fnd_Api.g_ret_sts_error;
1965: elsif p_stages_rec.duration = 0
1966: then

Line 1971: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');

1967: open c_stage_task( p_stages_rec.stage_id);
1968: fetch c_stage_task into l_dummy;
1969: if c_stage_task%found
1970: THEN
1971: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');
1972: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1973: Fnd_Msg_Pub.ADD;
1974: x_return_status := Fnd_Api.g_ret_sts_error;
1975: end if;

Line 1972: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1968: fetch c_stage_task into l_dummy;
1969: if c_stage_task%found
1970: THEN
1971: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');
1972: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1973: Fnd_Msg_Pub.ADD;
1974: x_return_status := Fnd_Api.g_ret_sts_error;
1975: end if;
1976: close c_stage_task;

Line 1979: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NON_INT');

1975: end if;
1976: close c_stage_task;
1977: elsif p_stages_rec.DURATION > trunc(l_stage_duration,0)
1978: THEN
1979: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NON_INT');
1980: Fnd_Msg_Pub.ADD;
1981: x_return_status := Fnd_Api.g_ret_sts_error;
1982:
1983: end if;

Line 2155: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND');

2151: -- VWP ER-12424063:: tchimira :: 1-JUN-2011:: start
2152: OPEN c_get_stage_id(p_stage_name, p_visit_id);
2153: FETCH c_get_stage_id INTO l_stage_id, l_stage_num;
2154: IF c_get_stage_id%NOTFOUND THEN
2155: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND');
2156: Fnd_Msg_Pub.ADD;
2157: x_return_status := Fnd_Api.g_ret_sts_error;
2158: END IF;
2159: CLOSE c_get_stage_id;

Line 2182: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');

2178: -- If any of the successive parents of passed task id falls in any of the successive children
2179: -- of the passed stage id, then throw an error
2180: IF l_task_stage_id = child_stage_rec.object_id THEN
2181: -- throw error
2182: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2183: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
2184: Fnd_Msg_Pub.ADD;
2185: x_return_status := Fnd_Api.g_ret_sts_error;
2186: END IF;

Line 2183: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);

2179: -- of the passed stage id, then throw an error
2180: IF l_task_stage_id = child_stage_rec.object_id THEN
2181: -- throw error
2182: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2183: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
2184: Fnd_Msg_Pub.ADD;
2185: x_return_status := Fnd_Api.g_ret_sts_error;
2186: END IF;
2187: END LOOP;

Line 2213: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');

2209: -- If any of the successive children of passed task id falls in any of the successive parent
2210: -- of the passed stage id, then throw an error
2211: IF l_task_stage_id = parent_stage_rec.subject_id THEN
2212: -- throw error
2213: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2214: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
2215: Fnd_Msg_Pub.ADD;
2216: x_return_status := Fnd_Api.g_ret_sts_error;
2217: END IF;

Line 2214: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);

2210: -- of the passed stage id, then throw an error
2211: IF l_task_stage_id = parent_stage_rec.subject_id THEN
2212: -- throw error
2213: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2214: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
2215: Fnd_Msg_Pub.ADD;
2216: x_return_status := Fnd_Api.g_ret_sts_error;
2217: END IF;
2218: END LOOP;

Line 2395: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_ST_DATE');

2391: CLOSE c_Visit;
2392:
2393: IF(c_visit_rec.START_DATE_TIME IS NULL OR c_visit_rec.START_DATE_TIME = Fnd_Api.g_miss_date)
2394: THEN
2395: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_ST_DATE');
2396: Fnd_Msg_Pub.ADD;
2397: x_valid_flag := 'N';
2398: END IF;
2399:

Line 2402: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');

2398: END IF;
2399:
2400: IF(c_visit_rec.DEPARTMENT_ID IS NULL OR c_visit_rec.DEPARTMENT_ID = Fnd_Api.g_miss_num)
2401: THEN
2402: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');
2403: Fnd_Msg_Pub.ADD;
2404: x_valid_flag := 'N';
2405: ELSE
2406: -- Modified by amagrawa based on review comments

Line 2413: Fnd_Message.SET_NAME('AHL','AHL_VWP_VNO_DEP_SFT');

2409: FETCH c_dept INTO l_count;
2410: CLOSE c_dept;
2411: IF l_count=0
2412: THEN
2413: Fnd_Message.SET_NAME('AHL','AHL_VWP_VNO_DEP_SFT');
2414: Fnd_Msg_Pub.ADD;
2415: x_valid_flag := 'N';
2416: END IF;
2417: END IF;

Line 2424: Fnd_Message.SET_NAME('AHL','AHL_VWP_TNO_DEP_SFT');

2420: open c_task_dep_exist(p_visit_id);
2421: FETCH c_task_dep_exist into l_dummy;
2422: IF(c_task_dep_exist%FOUND)
2423: THEN
2424: Fnd_Message.SET_NAME('AHL','AHL_VWP_TNO_DEP_SFT');
2425: Fnd_Msg_Pub.ADD;
2426: x_valid_flag := 'N';
2427: END IF;
2428: CLOSE c_task_dep_exist;

Line 2435: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_MR_NOT_VAL');

2431: -- Modified by amagrawa based on review comments
2432: OPEN c_route_chk (p_visit_id);
2433: FETCH c_route_chk INTO c_route_chk_rec;
2434: IF c_route_chk%FOUND THEN
2435: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_MR_NOT_VAL');
2436: Fnd_Msg_Pub.ADD;
2437: x_valid_flag := 'N';
2438: END IF;
2439: CLOSE c_route_chk;

Line 2475: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_STG_ID_CYC');

2471: START WITH OBJECT_ID = P_CHILD_STAGE_ID
2472: CONNECT BY PRIOR OBJECT_ID =SUBJECT_ID;
2473: EXCEPTION
2474: WHEN l_cyclic_loop THEN
2475: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_STG_ID_CYC');
2476: FND_MESSAGE.SET_TOKEN('STAGE_NUMBER',P_PARENT_STAGE_NUMBER);
2477: FND_MSG_PUB.ADD;
2478: x_return_status := FND_API.G_RET_STS_ERROR;
2479:

Line 2476: FND_MESSAGE.SET_TOKEN('STAGE_NUMBER',P_PARENT_STAGE_NUMBER);

2472: CONNECT BY PRIOR OBJECT_ID =SUBJECT_ID;
2473: EXCEPTION
2474: WHEN l_cyclic_loop THEN
2475: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_STG_ID_CYC');
2476: FND_MESSAGE.SET_TOKEN('STAGE_NUMBER',P_PARENT_STAGE_NUMBER);
2477: FND_MSG_PUB.ADD;
2478: x_return_status := FND_API.G_RET_STS_ERROR;
2479:
2480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2651: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_STG_RULE_DUP'); --a stage rule already exists between these stages

2647: fnd_log.string(l_log_statement,L_DEBUG_KEY,': l_duplicated_count is :' ||l_duplicated_count );
2648: END IF;
2649:
2650: IF l_duplicated_count IS NOT NULL AND l_duplicated_count > 1 THEN
2651: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_STG_RULE_DUP'); --a stage rule already exists between these stages
2652: FND_MSG_PUB.ADD;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655: --PRAKKUM :: VWPE :: ER 12424063 :: 15-APR-2011 :: to find duplicate rules :: END

Line 2661: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_STG_STATUS_RULE');

2657: --PRAKKUM :: VWPE :: ER 12424063 :: 31-MAY-2011 :: to validate whether all rules are over planning stages or not :: START
2658: l_invalid_rules_count :=0; --Initialization
2659: FOR l_invalid_stage_rules_rec IN c_get_invalid_rule_stages (p_stage_rule_rec.SUBJECT_STAGE_ID,p_stage_rule_rec.OBJECT_STAGE_ID)
2660: LOOP
2661: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_STG_STATUS_RULE');
2662: Fnd_Message.SET_TOKEN('STAGE_NUM', l_invalid_stage_rules_rec.STAGE_NUM);
2663: FND_MSG_PUB.ADD;
2664: l_invalid_rules_count := l_invalid_rules_count+1;
2665: END LOOP;

Line 2662: Fnd_Message.SET_TOKEN('STAGE_NUM', l_invalid_stage_rules_rec.STAGE_NUM);

2658: l_invalid_rules_count :=0; --Initialization
2659: FOR l_invalid_stage_rules_rec IN c_get_invalid_rule_stages (p_stage_rule_rec.SUBJECT_STAGE_ID,p_stage_rule_rec.OBJECT_STAGE_ID)
2660: LOOP
2661: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_STG_STATUS_RULE');
2662: Fnd_Message.SET_TOKEN('STAGE_NUM', l_invalid_stage_rules_rec.STAGE_NUM);
2663: FND_MSG_PUB.ADD;
2664: l_invalid_rules_count := l_invalid_rules_count+1;
2665: END LOOP;
2666:

Line 2818: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');

2814: OPEN c_validate_stage_tasks(l_parent_stages_rec.subject_id,l_child_stages_rec.object_id);
2815: FETCH c_validate_stage_tasks INTO l_dummy;
2816: IF c_validate_stage_tasks%FOUND THEN
2817: CLOSE c_validate_stage_tasks;
2818: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2819: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_child_stage_num); -- Stage rule for violates already defined task rule
2820: Fnd_Msg_Pub.ADD;
2821: RAISE FND_API.G_EXC_ERROR;
2822: END IF;

Line 2819: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_child_stage_num); -- Stage rule for violates already defined task rule

2815: FETCH c_validate_stage_tasks INTO l_dummy;
2816: IF c_validate_stage_tasks%FOUND THEN
2817: CLOSE c_validate_stage_tasks;
2818: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
2819: --Fnd_Message.SET_TOKEN('STAGE_NUM', l_child_stage_num); -- Stage rule for violates already defined task rule
2820: Fnd_Msg_Pub.ADD;
2821: RAISE FND_API.G_EXC_ERROR;
2822: END IF;
2823: CLOSE c_validate_stage_tasks;

Line 2832: FND_MESSAGE.SET_NAME('AHL','AHL_STG_RULE_PRED'); --a stage cannot have more than one predecessors

2828: --If the previous stage number of the subject_stage_id is not null, then check if that is equal to parent stage number.
2829: --If not equal, throw an error since a stage cannot have more than one predecessors.
2830: IF(l_prev_stage_num IS NOT NULL) THEN
2831: IF (l_prev_stage_num <> l_parent_stage_num) THEN
2832: FND_MESSAGE.SET_NAME('AHL','AHL_STG_RULE_PRED'); --a stage cannot have more than one predecessors
2833: FND_MESSAGE.SET_TOKEN('STAGE_NUM',l_child_stage_num);
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_ERROR;
2836: END IF;

Line 2833: FND_MESSAGE.SET_TOKEN('STAGE_NUM',l_child_stage_num);

2829: --If not equal, throw an error since a stage cannot have more than one predecessors.
2830: IF(l_prev_stage_num IS NOT NULL) THEN
2831: IF (l_prev_stage_num <> l_parent_stage_num) THEN
2832: FND_MESSAGE.SET_NAME('AHL','AHL_STG_RULE_PRED'); --a stage cannot have more than one predecessors
2833: FND_MESSAGE.SET_TOKEN('STAGE_NUM',l_child_stage_num);
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_ERROR;
2836: END IF;
2837: END IF;

Line 2951: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');

2947: -- Check for the ID.
2948:
2949: IF (l_visit_id = Fnd_Api.g_miss_num OR l_visit_id IS Null)
2950: THEN
2951: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
2952: Fnd_Msg_Pub.ADD;
2953: RAISE Fnd_Api.G_EXC_ERROR;
2954: END IF;
2955:

Line 4421: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_RUL_NFOUND');

4417: FETCH c_stage_link_dets INTO l_Stage_link_dets;
4418: CLOSE c_stage_link_dets;
4419:
4420: IF l_Stage_link_dets.STAGE_LINK_ID IS NULL THEN
4421: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_RUL_NFOUND');
4422: Fnd_Msg_Pub.ADD;
4423: RAISE Fnd_Api.G_EXC_ERROR;
4424: END IF;
4425:

Line 4453: Fnd_Message.SET_NAME('AHL','AHL_VSP_STG_INVALID_ID');

4449: FETCH c_stage_details INTO l_stg_stage_number,l_prev_stage_planned_end_date;
4450: CLOSE c_stage_details;
4451:
4452: IF l_stg_stage_number IS NULL THEN
4453: Fnd_Message.SET_NAME('AHL','AHL_VSP_STG_INVALID_ID');
4454: Fnd_Msg_Pub.ADD;
4455: RAISE Fnd_Api.G_EXC_ERROR;
4456: END IF;
4457:

Line 4486: Fnd_Message.SET_NAME('AHL','AHL_VWP_RULE_PREDECESSOR');

4482: END IF;*/
4483:
4484: IF l_prev_stg_num is NOT NULL THEN -- Two predessors validation
4485: IF l_prev_stg_num <> l_stg_stage_number THEN
4486: Fnd_Message.SET_NAME('AHL','AHL_VWP_RULE_PREDECESSOR');
4487: Fnd_Msg_Pub.ADD;
4488: RAISE Fnd_Api.G_EXC_ERROR;
4489: END IF;
4490: END IF;

Line 4499: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_INVALID_RULE');

4495: l_stage_rule_record.object_STAGE_ID := l_Stage_link_dets.object_ID;
4496: l_stage_rule_record.RELATION_TYPE := l_Stage_link_dets.RELATION_TYPE;
4497:
4498: IF l_stage_rule_record.subject_STAGE_ID = l_stage_rule_record.object_STAGE_ID THEN
4499: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_INVALID_RULE');
4500: Fnd_Msg_Pub.ADD;
4501: RAISE Fnd_Api.G_EXC_ERROR;
4502: END IF;
4503:

Line 4768: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');

4764: IF l_dept_id IS NULL THEN
4765: IF (l_log_statement >= l_log_current_level) THEN
4766: fnd_log.string(l_log_statement,L_DEBUG,' No Dept Id' );
4767: END IF;
4768: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');
4769: Fnd_Msg_Pub.ADD;
4770: RAISE Fnd_Api.G_EXC_ERROR;
4771: END IF;
4772:

Line 4777: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ST_DATE_NULL');

4773: IF l_visit_start_date IS NULL THEN
4774: IF (l_log_statement >= l_log_current_level) THEN
4775: fnd_log.string(l_log_statement,L_DEBUG,' No visit start date' );
4776: END IF;
4777: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ST_DATE_NULL');
4778: Fnd_Msg_Pub.ADD;
4779: RAISE Fnd_Api.G_EXC_ERROR;
4780: END IF;
4781:

Line 4786: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_MAND');

4782: IF ( l_visit_limited_dets.visit_type_code IS NULL AND l_visit_limited_dets.IS_OLD_VISIT <> 'Y' ) THEN
4783: IF (l_log_statement >= l_log_current_level) THEN
4784: fnd_log.string(l_log_statement,L_DEBUG,' No visit type code' );
4785: END IF;
4786: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_MAND');
4787: Fnd_Msg_Pub.ADD;
4788: RAISE Fnd_Api.G_EXC_ERROR;
4789: END IF;
4790:

Line 5152: Fnd_Message.SET_NAME('AHL','AHL_VWP_MAND_STG_RULE');

5148: IF (l_log_statement >= l_log_current_level) THEN
5149: fnd_log.string(l_log_statement,L_DEBUG,'Invalid stage rule');
5150: END IF;
5151:
5152: Fnd_Message.SET_NAME('AHL','AHL_VWP_MAND_STG_RULE');
5153: Fnd_Msg_Pub.ADD;
5154: RAISE Fnd_Api.G_EXC_ERROR;
5155:
5156: END IF;

Line 5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');

5936: fnd_log.string(l_log_statement,L_DEBUG,'Invalid Stage Num is :' ||invalid_stage_numbers.STAGE_NUM );
5937: END IF;
5938:
5939: IF p_caller_id = 'R' THEN -- If validation failed during stage rule addition
5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');
5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);

Line 5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);

5937: END IF;
5938:
5939: IF p_caller_id = 'R' THEN -- If validation failed during stage rule addition
5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');
5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));

Line 5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);

5938:
5939: IF p_caller_id = 'R' THEN -- If validation failed during stage rule addition
5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');
5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;

Line 5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));

5939: IF p_caller_id = 'R' THEN -- If validation failed during stage rule addition
5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');
5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;
5947: ELSE

Line 5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);

5940: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_R_STAGE_NUMS');
5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;
5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');

Line 5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));

5941: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5942: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5943: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;
5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);

Line 5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');

5944: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;
5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);

Line 5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);

5945: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5946: Fnd_Msg_Pub.ADD;
5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));

Line 5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);

5946: Fnd_Msg_Pub.ADD;
5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5954: Fnd_Msg_Pub.ADD;

Line 5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));

5947: ELSE
5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5954: Fnd_Msg_Pub.ADD;
5955: END IF;

Line 5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);

5948: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_STAGE_NUMS');
5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5954: Fnd_Msg_Pub.ADD;
5955: END IF;
5956: l_isValidationFailed := true;

Line 5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));

5949: FND_MESSAGE.SET_TOKEN('STAGE_NUM',invalid_stage_numbers.STAGE_NUM);
5950: Fnd_Message.SET_TOKEN('STG_ST_DATE', invalid_stage_numbers.planned_start_date);
5951: Fnd_Message.SET_TOKEN('STG_ST_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_start_date,'HH24:MI:SS'));
5952: Fnd_Message.SET_TOKEN('STG_ED_DATE', invalid_stage_numbers.planned_end_date);
5953: Fnd_Message.SET_TOKEN('STG_ED_TIMESTAMP', TO_CHAR(invalid_stage_numbers.planned_end_date,'HH24:MI:SS'));
5954: Fnd_Msg_Pub.ADD;
5955: END IF;
5956: l_isValidationFailed := true;
5957:

Line 6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');

6217: fnd_log.string(l_log_statement,L_DEBUG,' Stage Planned End Date --@>'|| TO_CHAR(l_stages_rec.planned_end_date,'DD-MON-YYYY HH24:MI:SS'));
6218: fnd_log.string(l_log_statement,L_DEBUG,' Visit Planned End Date --@>'|| TO_CHAR(l_stages_rec.close_date_time,'DD-MON-YYYY HH24:MI:SS'));
6219: END IF;
6220:
6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');
6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);

Line 6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);

6218: fnd_log.string(l_log_statement,L_DEBUG,' Visit Planned End Date --@>'|| TO_CHAR(l_stages_rec.close_date_time,'DD-MON-YYYY HH24:MI:SS'));
6219: END IF;
6220:
6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');
6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);
6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));

Line 6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);

6219: END IF;
6220:
6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');
6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);
6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));
6227: Fnd_Msg_Pub.ADD;

Line 6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));

6220:
6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');
6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);
6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));
6227: Fnd_Msg_Pub.ADD;
6228:

Line 6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);

6221: Fnd_Message.SET_NAME('AHL','AHL_VWP_INV_STAGE_DATE');
6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);
6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));
6227: Fnd_Msg_Pub.ADD;
6228:
6229: l_isValidationFailed := 'Y';

Line 6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));

6222: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stages_rec.stage_num);
6223: Fnd_Message.SET_TOKEN('STAGE_DATE', l_stages_rec.planned_end_date);
6224: Fnd_Message.SET_TOKEN('STAGE_TIMESTAMP', TO_CHAR(l_stages_rec.planned_end_date,'HH24:MI:SS'));
6225: Fnd_Message.SET_TOKEN('VISIT_END_DATE', l_stages_rec.close_date_time);
6226: Fnd_Message.SET_TOKEN('VISIT_END_TIMESTAMP', TO_CHAR(l_stages_rec.close_date_time,'HH24:MI:SS'));
6227: Fnd_Msg_Pub.ADD;
6228:
6229: l_isValidationFailed := 'Y';
6230: END LOOP;