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.PA_SCHEDULE_PUB dependencies on FND_MSG_PUB

Line 81: FND_MSG_PUB.initialize;

77: -- Initialize the return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS ;
79:
80: --Clear the global PL/SQL message table
81: FND_MSG_PUB.initialize;
82:
83: -- Initialize the Error Stack
84: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');
85:

Line 370: x_msg_count := FND_MSG_PUB.Count_Msg;

366: EXCEPTION
367:
368: WHEN FND_API.G_EXC_ERROR THEN
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: x_msg_count := FND_MSG_PUB.Count_Msg;
371:
372: IF x_msg_count = 1 THEN
373: pa_interface_utils_pub.get_messages
374: (p_encoded => FND_API.G_TRUE,

Line 389: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

385: -- 4537865 : RESET x_msg_data also.
386: x_msg_data := SUBSTRB(SQLERRM,1,240);
387:
388: -- Set the excetption Message and the stack
389: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
390: ,p_procedure_name => 'execute_update_schedule'
391: ,p_error_text => x_msg_data ); -- 4537865
392:
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 469: FND_MSG_PUB.initialize;

465:
466: BEGIN
467: --Clear the global PL/SQL message table
468: IF (p_init_msg_list = FND_API.G_TRUE) THEN
469: FND_MSG_PUB.initialize;
470: END IF;
471:
472: -- Initialize the return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 594: x_msg_count := FND_MSG_PUB.Count_Msg;

590: EXCEPTION
591:
592: WHEN FND_API.G_EXC_ERROR THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: x_msg_count := FND_MSG_PUB.Count_Msg;
595:
596: IF x_msg_count = 1 THEN
597: pa_interface_utils_pub.get_messages
598: (p_encoded => FND_API.G_TRUE,

Line 613: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

609: -- 4537865 : RESET x_msg_data also
610: x_msg_data := SUBSTRB(SQLERRM,1,240);
611:
612: -- Set the excetption Message and the stack
613: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
614: ,p_procedure_name => 'single_update_schedule',
615: p_error_text => x_msg_data ); -- 4537865
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 702: FND_MSG_PUB.initialize;

698: x_return_status := FND_API.G_RET_STS_SUCCESS ;
699:
700: --Clear the global PL/SQL message table
701: IF (p_init_msg_list = FND_API.G_TRUE) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: -- Initialize the Error Stack
706: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.mass_update_schedule');

Line 917: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

913: -- 4537865 : RESET x_msg_data also
914: x_msg_data := SUBSTRB(SQLERRM,1,240);
915:
916: -- Set the excetption Message and the stack
917: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
918: ,p_procedure_name => 'mass_update_schedule'
919: ,p_error_text => x_msg_data ); -- 4537865
920:
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 922: x_msg_count := FND_MSG_PUB.Count_Msg;

918: ,p_procedure_name => 'mass_update_schedule'
919: ,p_error_text => x_msg_data ); -- 4537865
920:
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: x_msg_count := FND_MSG_PUB.Count_Msg;
923:
924: RAISE; -- This is optional depending on the needs
925: END mass_update_schedule;
926:

Line 1022: FND_MSG_PUB.initialize;

1018: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1019:
1020: --Clear the global PL/SQL message table
1021: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024:
1025: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1026: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 1275: x_msg_count := FND_MSG_PUB.Count_Msg;

1271: ----------------------------------------------------------------------
1272: PA_SCHEDULE_UTILS.log_message(1,'End of the change_duration API ..... ');
1273: x_return_status := l_x_return_status;
1274:
1275: x_msg_count := FND_MSG_PUB.Count_Msg;
1276: If x_msg_count = 1 THEN
1277: pa_interface_utils_pub.get_messages
1278: (p_encoded => FND_API.G_TRUE ,
1279: p_msg_index => 1,

Line 1292: x_msg_count := FND_MSG_PUB.Count_Msg;

1288: WHEN l_ei_asgn_out_of_range THEN
1289: PA_UTILS.Add_Message('PA', l_error_message_code);
1290: x_return_status := FND_API.G_RET_STS_ERROR;
1291: x_msg_data := l_error_message_code;
1292: x_msg_count := FND_MSG_PUB.Count_Msg;
1293: If x_msg_count = 1 THEN
1294: pa_interface_utils_pub.get_messages
1295: (p_encoded => FND_API.G_TRUE,
1296: p_msg_index => 1,

Line 1307: x_msg_count := FND_MSG_PUB.Count_Msg;

1303: WHEN l_resource_cc_error_u THEN
1304: PA_UTILS.Add_Message('PA', l_error_message_code);
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: x_msg_data := l_error_message_code;
1307: x_msg_count := FND_MSG_PUB.Count_Msg;
1308: If x_msg_count = 1 THEN
1309: pa_interface_utils_pub.get_messages
1310: (p_encoded => FND_API.G_TRUE,
1311: p_msg_index => 1,

Line 1322: x_msg_count := FND_MSG_PUB.Count_Msg;

1318: WHEN l_resource_cc_error_e THEN
1319: PA_UTILS.Add_Message('PA', 'CROSS_CHARGE_VALIDATION_FAILED');
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: x_msg_data := 'CROSS_CHARGE_VALIDATION_FAILED';
1322: x_msg_count := FND_MSG_PUB.Count_Msg;
1323: If x_msg_count = 1 THEN
1324: pa_interface_utils_pub.get_messages
1325: (p_encoded => FND_API.G_TRUE,
1326: p_msg_index => 1,

Line 1337: x_msg_count := FND_MSG_PUB.Count_Msg;

1333: WHEN l_resource_out_of_range THEN
1334: PA_UTILS.Add_Message( 'PA', 'PA_RESOURCE_OUT_OF_RANGE');
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: x_msg_data := 'PA_RESOURCE_OUT_OF_RANGE';
1337: x_msg_count := FND_MSG_PUB.Count_Msg;
1338: If x_msg_count = 1 THEN
1339: pa_interface_utils_pub.get_messages
1340: (p_encoded => FND_API.G_TRUE,
1341: p_msg_index => 1,

Line 1352: x_msg_count := FND_MSG_PUB.Count_Msg;

1348: WHEN l_stale_asmt_data THEN
1349: PA_UTILS.add_message('PA','PA_XC_RECORD_CHANGED');
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: x_msg_data := 'PA_XC_RECORD_CHANGED';
1352: x_msg_count := FND_MSG_PUB.Count_Msg;
1353: If x_msg_count = 1 THEN
1354: pa_interface_utils_pub.get_messages
1355: (p_encoded => FND_API.G_TRUE,
1356: p_msg_index => 1,

Line 1367: x_msg_count := FND_MSG_PUB.Count_Msg;

1363: WHEN l_assignment_status_null THEN
1364: PA_UTILS.add_message('PA','PA_SCH_ASGN_STATUS_NULL');
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: x_msg_data := 'PA_SCH_ASGN_STATUS_NULL';
1367: x_msg_count := FND_MSG_PUB.Count_Msg;
1368: If x_msg_count = 1 THEN
1369: pa_interface_utils_pub.get_messages
1370: (p_encoded => FND_API.G_TRUE,
1371: p_msg_index => 1,

Line 1384: x_msg_count := FND_MSG_PUB.Count_Msg;

1380: 'ASMT_TYPE_POSS', l_asgn_req_poss_text,
1381: 'ASMT_TYPE', l_asgn_req_text);
1382: x_msg_data := 'PA_SCH_INVALID_FROM_DATE';
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: x_msg_count := FND_MSG_PUB.Count_Msg;
1385: If x_msg_count = 1 THEN
1386: pa_interface_utils_pub.get_messages
1387: (p_encoded => FND_API.G_TRUE,
1388: p_msg_index => 1,

Line 1401: x_msg_count := FND_MSG_PUB.Count_Msg;

1397: 'ASMT_TYPE_POSS', l_asgn_req_poss_text,
1398: 'ASMT_TYPE', l_asgn_req_text);
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: x_msg_data := 'PA_SCH_INVALID_TO_DATE';
1401: x_msg_count := FND_MSG_PUB.Count_Msg;
1402: If x_msg_count = 1 THEN
1403: pa_interface_utils_pub.get_messages
1404: (p_encoded => FND_API.G_TRUE,
1405: p_msg_index => 1,

Line 1421: x_msg_count := FND_MSG_PUB.Count_Msg;

1417: p_token2 => 'ASGN_STATUS',
1418: p_value2 => l_assignment_status_name);
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: x_msg_data := 'PA_ASGN_STUS_NOT_FOR_PROJ_STUS';
1421: x_msg_count := FND_MSG_PUB.Count_Msg;
1422: If x_msg_count = 1 THEN
1423: pa_interface_utils_pub.get_messages
1424: (p_encoded => FND_API.G_TRUE,
1425: p_msg_index => 1,

Line 1437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1433: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_durarion API ..'||sqlerrm);
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: x_msg_count := 1;
1436: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1438: p_procedure_name => 'change_duration');
1439: If x_msg_count = 1 THEN
1440: pa_interface_utils_pub.get_messages
1441: (p_encoded => FND_API.G_TRUE,

Line 1514: FND_MSG_PUB.initialize;

1510: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
1511:
1512: --Clear the global PL/SQL message table
1513: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1514: FND_MSG_PUB.initialize;
1515: END IF;
1516:
1517: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1518: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 1578: x_msg_count := FND_MSG_PUB.Count_Msg;

1574: END IF;
1575:
1576: PA_SCHEDULE_UTILS.log_message(1,'End of the change_hours API ... ');
1577: x_return_status := l_x_return_status;
1578: x_msg_count := FND_MSG_PUB.Count_Msg;
1579: If x_msg_count = 1 THEN
1580: pa_interface_utils_pub.get_messages
1581: (p_encoded => FND_API.G_TRUE ,
1582: p_msg_index => 1,

Line 1596: x_msg_count := FND_MSG_PUB.Count_Msg;

1592: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
1593: 'ASMT_TYPE', l_asgn_req_text);
1594: x_return_status := FND_API.G_RET_STS_ERROR;
1595: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
1596: x_msg_count := FND_MSG_PUB.Count_Msg;
1597: If x_msg_count = 1 THEN
1598: pa_interface_utils_pub.get_messages
1599: (p_encoded => FND_API.G_TRUE,
1600: p_msg_index => 1,

Line 1612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1608: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_hours API ..'||sqlerrm);
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: x_msg_count := 1;
1611: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1613: p_procedure_name => 'change_duration');
1614: If x_msg_count = 1 THEN
1615: pa_interface_utils_pub.get_messages
1616: (p_encoded => FND_API.G_TRUE,

Line 1700: FND_MSG_PUB.initialize;

1696: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
1697:
1698: --Clear the global PL/SQL message table
1699: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1700: FND_MSG_PUB.initialize;
1701: END IF;
1702:
1703: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1704: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 1842: x_msg_count := FND_MSG_PUB.Count_Msg;

1838:
1839: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');
1840: x_return_status := l_x_return_status;
1841:
1842: x_msg_count := FND_MSG_PUB.Count_Msg;
1843: If x_msg_count = 1 THEN
1844: pa_interface_utils_pub.get_messages
1845: (p_encoded => FND_API.G_TRUE ,
1846: p_msg_index => 1,

Line 1860: x_msg_count := FND_MSG_PUB.Count_Msg;

1856: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
1857: 'ASMT_TYPE', l_asgn_req_text);
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
1860: x_msg_count := FND_MSG_PUB.Count_Msg;
1861: If x_msg_count = 1 THEN
1862: pa_interface_utils_pub.get_messages
1863: (p_encoded => FND_API.G_TRUE,
1864: p_msg_index => 1,

Line 1876: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1872: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern API ..'||sqlerrm);
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: x_msg_count := 1;
1875: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr with substrb
1876: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1877: p_procedure_name => 'change_work_pattern');
1878: If x_msg_count = 1 THEN
1879: pa_interface_utils_pub.get_messages
1880: (p_encoded => FND_API.G_TRUE,

Line 1972: FND_MSG_PUB.initialize;

1968: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
1969:
1970: --Clear the global PL/SQL message table
1971: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1972: FND_MSG_PUB.initialize;
1973: END IF;
1974:
1975: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1976: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 2095: x_msg_count := FND_MSG_PUB.Count_Msg;

2091:
2092: PA_SCHEDULE_UTILS.log_message(1,'End of the change_status API ... ');
2093: x_return_status := l_x_return_status;
2094:
2095: x_msg_count := FND_MSG_PUB.Count_Msg;
2096: If x_msg_count = 1 THEN
2097: pa_interface_utils_pub.get_messages
2098: (p_encoded => FND_API.G_TRUE ,
2099: p_msg_index => 1,

Line 2110: x_msg_count := FND_MSG_PUB.Count_Msg;

2106:
2107: EXCEPTION
2108: WHEN FND_API.G_EXC_ERROR THEN
2109: x_return_status := FND_API.G_RET_STS_ERROR;
2110: x_msg_count := FND_MSG_PUB.Count_Msg;
2111:
2112: IF x_msg_count = 1 THEN
2113: pa_interface_utils_pub.get_messages
2114: (p_encoded => FND_API.G_TRUE,

Line 2123: x_msg_count := FND_MSG_PUB.Count_Msg;

2119: WHEN l_stale_asmt_data THEN
2120: PA_UTILS.add_message('PA','PA_XC_RECORD_CHANGED');
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: x_msg_data := 'PA_XC_RECORD_CHANGED';
2123: x_msg_count := FND_MSG_PUB.Count_Msg;
2124: If x_msg_count = 1 THEN
2125: pa_interface_utils_pub.get_messages
2126: (p_encoded => FND_API.G_TRUE,
2127: p_msg_index => 1,

Line 2141: x_msg_count := FND_MSG_PUB.Count_Msg;

2137: 'A_OR_AN', l_a_an_text,
2138: 'ASMT_TYPE', l_asgn_req_text);
2139: x_return_status := FND_API.G_RET_STS_ERROR;
2140: x_msg_data := 'PA_INVALID_ASGN_CANCELLED_DATE';
2141: x_msg_count := FND_MSG_PUB.Count_Msg;
2142: If x_msg_count = 1 THEN
2143: pa_interface_utils_pub.get_messages
2144: (p_encoded => FND_API.G_TRUE,
2145: p_msg_index => 1,

Line 2157: x_msg_count := FND_MSG_PUB.Count_Msg;

2153: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
2154: 'ASMT_TYPE', l_asgn_req_text);
2155: x_return_status := FND_API.G_RET_STS_ERROR;
2156: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
2157: x_msg_count := FND_MSG_PUB.Count_Msg;
2158: If x_msg_count = 1 THEN
2159: pa_interface_utils_pub.get_messages
2160: (p_encoded => FND_API.G_TRUE,
2161: p_msg_index => 1,

Line 2177: x_msg_count := FND_MSG_PUB.Count_Msg;

2173: p_token2 => 'ASGN_STATUS',
2174: p_value2 => l_assignment_status_name);
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: x_msg_data := 'PA_ASGN_STUS_NOT_FOR_PROJ_STUS';
2177: x_msg_count := FND_MSG_PUB.Count_Msg;
2178: If x_msg_count = 1 THEN
2179: pa_interface_utils_pub.get_messages
2180: (p_encoded => FND_API.G_TRUE,
2181: p_msg_index => 1,

Line 2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: x_msg_count := 1;
2191: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 Replaced substr with substrb
2192: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_status API ..'||sqlerrm);
2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2194: p_procedure_name => 'change_status');
2195: If x_msg_count = 1 THEN
2196: pa_interface_utils_pub.get_messages
2197: (p_encoded => FND_API.G_TRUE,

Line 2257: fnd_msg_pub.initialize;

2253: -- storing the status success to track the error
2254: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2255:
2256: --Clear the global PL/SQL message table
2257: fnd_msg_pub.initialize;
2258:
2259: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2260: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2261: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');

Line 2285: x_msg_count := FND_MSG_PUB.Count_Msg;

2281: FROM jtf_calendars_vl
2282: WHERE calendar_name = p_calendar_name;
2283:
2284:
2285: x_msg_count := FND_MSG_PUB.Count_Msg;
2286: If x_msg_count = 1 THEN
2287: pa_interface_utils_pub.get_messages
2288: (p_encoded => FND_API.G_TRUE ,
2289: p_msg_index => 1,

Line 2337: x_msg_count := FND_MSG_PUB.Count_Msg;

2333:
2334: PA_SCHEDULE_UTILS.log_message(1,'End of the change_calendar API ... ');
2335: x_return_status := l_x_return_status;
2336:
2337: x_msg_count := FND_MSG_PUB.Count_Msg;
2338: If x_msg_count = 1 THEN
2339: pa_interface_utils_pub.get_messages
2340: (p_encoded => FND_API.G_TRUE ,
2341: p_msg_index => 1,

Line 2355: x_msg_count := FND_MSG_PUB.Count_Msg;

2351: WHEN l_invalid_duplicate_cal_name THEN
2352: PA_UTILS.add_message('PA','PA_CALENDAR_INVALID_AMBIGOUS');
2353: x_return_status := FND_API.G_RET_STS_ERROR;
2354: x_msg_data := 'PA_CALENDAR_INVALID_AMBIGOUS';
2355: x_msg_count := FND_MSG_PUB.Count_Msg;
2356: If x_msg_count = 1 THEN
2357: pa_interface_utils_pub.get_messages
2358: (p_encoded => FND_API.G_TRUE,
2359: p_msg_index => 1,

Line 2370: x_msg_count := FND_MSG_PUB.Count_Msg;

2366: WHEN l_from_to_date_null THEN
2367: PA_UTILS.add_message('PA','PA_SCH_FROM_TO_DATE_NULL');
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: x_msg_data := 'PA_SCH_FROM_TO_DATE_NULL';
2370: x_msg_count := FND_MSG_PUB.Count_Msg;
2371: If x_msg_count = 1 THEN
2372: pa_interface_utils_pub.get_messages
2373: (p_encoded => FND_API.G_TRUE,
2374: p_msg_index => 1,

Line 2386: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2382: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_calendar API ..'||sqlerrm);
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2384: x_msg_count := 1;
2385: x_msg_data := substrb(SQLERRM,1,240); -- Changed substr to substrb : 4537865
2386: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2387: p_procedure_name => 'change_calendar');
2388: If x_msg_count = 1 THEN
2389: pa_interface_utils_pub.get_messages
2390: (p_encoded => FND_API.G_TRUE,

Line 2445: x_msg_count := FND_MSG_PUB.Count_Msg;

2441: PA_SCHEDULE_UTILS.log_message(1,'End of the change_schedule API ... ');
2442:
2443: x_return_status := l_x_return_status;
2444:
2445: x_msg_count := FND_MSG_PUB.Count_Msg;
2446: If x_msg_count = 1 THEN
2447: pa_interface_utils_pub.get_messages
2448: (p_encoded => FND_API.G_TRUE ,
2449: p_msg_index => 1,

Line 2463: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2459: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_schedule API ..'||sqlerrm);
2460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2461: x_msg_count := 1;
2462: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr usage with substrb
2463: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2464: p_procedure_name => 'change_schedule');
2465: If x_msg_count = 1 THEN
2466: pa_interface_utils_pub.get_messages
2467: (p_encoded => FND_API.G_TRUE ,

Line 2846: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);

2842: -- Calling the Timeline api to create the timeline records
2843: -- for the assignment
2844: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2845: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
2846: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
2847: PA_TIMELINE_PVT.create_timeline (
2848: p_assignment_id =>p_assignment_id ,
2849: x_return_status =>l_x_return_status ,
2850: x_msg_count =>x_msg_count ,

Line 2891: x_msg_count := FND_MSG_PUB.Count_Msg;

2887:
2888: PA_SCHEDULE_UTILS.log_message(1,'End of the change_asgn_schedule API ... ');
2889: x_return_status := l_x_return_status;
2890:
2891: x_msg_count := FND_MSG_PUB.Count_Msg;
2892:
2893: If x_msg_count = 1 THEN
2894: pa_interface_utils_pub.get_messages
2895: (p_encoded => FND_API.G_TRUE ,

Line 2911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2907: ||sqlerrm);
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909: x_msg_count := 1;
2910: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
2911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2912: p_procedure_name => 'change_asgn_schedule');
2913: If x_msg_count = 1 THEN
2914: pa_interface_utils_pub.get_messages
2915: (p_encoded => FND_API.G_TRUE ,

Line 2996: x_msg_count := FND_MSG_PUB.Count_Msg;

2992:
2993: PA_SCHEDULE_UTILS.log_message(1,'End of the create_calendar_schedule API ... ');
2994:
2995: x_return_status := l_x_return_status;
2996: x_msg_count := FND_MSG_PUB.Count_Msg;
2997: If x_msg_count = 1 THEN
2998: pa_interface_utils_pub.get_messages
2999: (p_encoded => FND_API.G_TRUE ,
3000: p_msg_index => 1,

Line 3013: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

3009: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_calendar_schedule API ..'||sqlerrm);
3010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3011: x_msg_count := 1;
3012: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 changed substr to substrb
3013: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3014: p_procedure_name => 'create_calendar_schedule');
3015: If x_msg_count = 1 THEN
3016: pa_interface_utils_pub.get_messages
3017: (p_encoded => FND_API.G_TRUE,

Line 3168: x_msg_count := FND_MSG_PUB.Count_Msg;

3164: PA_SCHEDULE_UTILS.log_message(1,'ERROR: invalid calendar id at profile option ..');
3165: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: x_msg_data := 'PA_INVALID_PROFILE_CALENDAR_ID';
3168: x_msg_count := FND_MSG_PUB.Count_Msg;
3169:
3170: -- RESET other out params also : 4537865
3171: x_calendar_id := NULL ;
3172: x_calendar_name := NULL;

Line 3189: x_msg_count := FND_MSG_PUB.Count_Msg;

3185: PA_SCHEDULE_UTILS.log_message(1,'ERROR: Null calendar id at profile option ..');
3186: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3187: x_return_status := FND_API.G_RET_STS_ERROR;
3188: x_msg_data := 'PA_NULL_PROFILE_CALENDAR_ID';
3189: x_msg_count := FND_MSG_PUB.Count_Msg;
3190:
3191: -- RESET other out params also : 4537865
3192: x_calendar_id := NULL ;
3193: x_calendar_name := NULL;

Line 3215: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

3211: -- RESET other out params also : 4537865
3212: x_calendar_id := NULL ;
3213: x_calendar_name := NULL;
3214:
3215: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3216: p_procedure_name => 'get_proj_calendar_default');
3217: If x_msg_count = 1 THEN
3218: pa_interface_utils_pub.get_messages
3219: (p_encoded => FND_API.G_TRUE,

Line 3345: pa_debug.write_file('CREATE_NEW_CAL_SCHEDULES: '||'LOG', 'msg_count = '||FND_MSG_PUB.Count_Msg);

3341: -- to the report file. Therefore, we have to raise expected errors.
3342: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3343:
3344: IF l_debug_mode = 'Y' THEN
3345: pa_debug.write_file('CREATE_NEW_CAL_SCHEDULES: '||'LOG', 'msg_count = '||FND_MSG_PUB.Count_Msg);
3346: END IF;
3347:
3348: FOR l_counter IN 1..FND_MSG_PUB.Count_Msg LOOP
3349: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE

Line 3348: FOR l_counter IN 1..FND_MSG_PUB.Count_Msg LOOP

3344: IF l_debug_mode = 'Y' THEN
3345: pa_debug.write_file('CREATE_NEW_CAL_SCHEDULES: '||'LOG', 'msg_count = '||FND_MSG_PUB.Count_Msg);
3346: END IF;
3347:
3348: FOR l_counter IN 1..FND_MSG_PUB.Count_Msg LOOP
3349: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
3350: ,p_msg_index => l_counter
3351: ,p_data => x_msg_data
3352: ,p_msg_index_out => l_msg_index_out);

Line 3366: x_msg_count := FND_MSG_PUB.Count_Msg;

3362:
3363: END LOOP;
3364:
3365: x_return_status := FND_API.G_RET_STS_SUCCESS;
3366: x_msg_count := FND_MSG_PUB.Count_Msg;
3367: If x_msg_count = 1 THEN
3368: pa_interface_utils_pub.get_messages
3369: (p_encoded => FND_API.G_TRUE ,
3370: p_msg_index => 1,

Line 3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

3386: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_cal_schedules API ..'|| sqlerrm);
3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388: x_msg_count := 1;
3389: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substrb to substr
3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3391: p_procedure_name => 'create_new_cal_schedules');
3392: If x_msg_count = 1 THEN
3393: pa_interface_utils_pub.get_messages
3394: (p_encoded => FND_API.G_TRUE,

Line 3495: FND_MSG_PUB.initialize;

3491:
3492: l_data varchar2(2000); -- 4537865
3493: BEGIN
3494:
3495: FND_MSG_PUB.initialize;
3496: l_count := p_hours_table.COUNT;
3497: p_end_date := p_start_date+13;
3498:
3499: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167

Line 4534: x_msg_count := FND_MSG_PUB.Count_Msg;

4530:
4531: EXCEPTION
4532: WHEN FND_API.G_EXC_ERROR THEN -- Added for Bug 3235656
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: x_msg_count := FND_MSG_PUB.Count_Msg;
4535:
4536: -- 4537865 : RESET other out params also.
4537: x_call_timeline_st_date := NULL ;
4538: x_call_timeline_end_date := NULL ;

Line 4559: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

4555: -- 4537865 : RESET other out params also.
4556: x_call_timeline_st_date := NULL ;
4557: x_call_timeline_end_date := NULL ;
4558:
4559: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
4560: p_procedure_name => 'change_work_pattern_duration');
4561: IF x_msg_count = 1 THEN
4562: pa_interface_utils_pub.get_messages
4563: (p_encoded => FND_API.G_TRUE,

Line 4577: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

4573: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern_duration API ..'|| sqlerrm);
4574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4575: x_msg_count := 1;
4576: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Chnaged substr to substrb
4577: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
4578: p_procedure_name => 'change_work_pattern_duration');
4579:
4580: -- 4537865 : RESET other out params also.
4581: x_call_timeline_st_date := NULL ;

Line 4741: FND_MSG_PUB.initialize;

4737: --AND asgn.status_code=nvl(p_status_code, asgn.status_code) 3235675 This is not needed, Also this is incorrect if status_code is null
4738: ORDER BY resource_id, assignment_id, item_date, forecast_item_type desc;
4739:
4740: BEGIN
4741: FND_MSG_PUB.initialize;
4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);

Line 5335: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

5331: x_msg_data := substrb(SQLERRM,1,240); -- 4537865
5332: -- RESET x_show_start_date also
5333: x_show_start_date := NULL ;
5334:
5335: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
5336: p_procedure_name => 'Populate_work_pattern_table');
5337: IF x_msg_count = 1 THEN
5338: pa_interface_utils_pub.get_messages
5339: (p_encoded => FND_API.G_TRUE,