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 84: FND_MSG_PUB.initialize;

80:
81:
82:
83: --Clear the global PL/SQL message table
84: FND_MSG_PUB.initialize;
85:
86: -- Initialize the Error Stack
87: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');
88:

Line 376: x_msg_count := FND_MSG_PUB.Count_Msg;

372: EXCEPTION
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: x_msg_count := FND_MSG_PUB.Count_Msg;
377:
378: IF x_msg_count = 1 THEN
379: pa_interface_utils_pub.get_messages
380: (p_encoded => FND_API.G_TRUE,

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

391: -- 4537865 : RESET x_msg_data also.
392: x_msg_data := SUBSTRB(SQLERRM,1,240);
393:
394: -- Set the excetption Message and the stack
395: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
396: ,p_procedure_name => 'execute_update_schedule'
397: ,p_error_text => x_msg_data ); -- 4537865
398:
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 454: fnd_msg_pub.initialize; -- 8233045

450: --Bug#9817752 end
451:
452:
453: BEGIN
454: fnd_msg_pub.initialize; -- 8233045
455:
456: PA_SCHEDULE_PUB.G_update_schedule_bulk_call := 'Y'; -- 8233045
457:
458: /* Initializing some of the parameters */

Line 498: FND_MSG_PUB.initialize;

494: -- Initialize the return status to success
495: l_return_status_tbl(k) := FND_API.G_RET_STS_SUCCESS ;
496:
497: --Clear the global PL/SQL message table
498: FND_MSG_PUB.initialize;
499:
500: -- Initialize the Error Stack
501: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');
502:

Line 590: l_msg_count_tbl(k) := FND_MSG_PUB.Count_Msg;

586: EXCEPTION
587:
588: WHEN FND_API.G_EXC_ERROR THEN
589: l_return_status_tbl(k) := FND_API.G_RET_STS_ERROR;
590: l_msg_count_tbl(k) := FND_MSG_PUB.Count_Msg;
591:
592: IF l_msg_count_tbl(k) = 1 THEN
593: pa_interface_utils_pub.get_messages
594: (p_encoded => FND_API.G_TRUE,

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

607: -- 4537865 : RESET x_msg_data also.
608: l_msg_data_tbl(k) := SUBSTRB(SQLERRM,1,240);
609:
610: -- Set the excetption Message and the stack
611: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
612: ,p_procedure_name => 'execute_update_schedule'
613: ,p_error_text => l_msg_data_tbl(k) ); -- 4537865
614:
615: l_return_status_tbl(k) := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 683: fnd_msg_pub.initialize; -- 8233045

679:
680:
681:
682: BEGIN
683: fnd_msg_pub.initialize; -- 8233045
684:
685: PA_SCHEDULE_PUB.G_update_schedule_bulk_call := 'Y'; -- 8233045
686:
687: /* Initializing some of the parameters */

Line 730: FND_MSG_PUB.initialize;

726: -- Initialize the return status to success
727: l_return_status_tbl(k) := FND_API.G_RET_STS_SUCCESS ;
728:
729: --Clear the global PL/SQL message table
730: FND_MSG_PUB.initialize;
731:
732: -- Initialize the Error Stack
733: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');
734:

Line 819: l_msg_count_tbl(k) := FND_MSG_PUB.Count_Msg;

815: EXCEPTION
816:
817: WHEN FND_API.G_EXC_ERROR THEN
818: l_return_status_tbl(k) := FND_API.G_RET_STS_ERROR;
819: l_msg_count_tbl(k) := FND_MSG_PUB.Count_Msg;
820:
821: IF l_msg_count_tbl(k) = 1 THEN
822: pa_interface_utils_pub.get_messages
823: (p_encoded => FND_API.G_TRUE,

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

836: -- 4537865 : RESET x_msg_data also.
837: l_msg_data_tbl(k) := SUBSTRB(SQLERRM,1,240);
838:
839: -- Set the excetption Message and the stack
840: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
841: ,p_procedure_name => 'execute_update_schedule'
842: ,p_error_text => l_msg_data_tbl(k) ); -- 4537865
843:
844: l_return_status_tbl(k) := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 933: FND_MSG_PUB.initialize;

929:
930:
931: --Clear the global PL/SQL message table
932: IF (p_init_msg_list = FND_API.G_TRUE) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935:
936: -- Initialize the return status to success
937: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1062: x_msg_count := FND_MSG_PUB.Count_Msg;

1058: EXCEPTION
1059:
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: x_msg_count := FND_MSG_PUB.Count_Msg;
1063:
1064: IF x_msg_count = 1 THEN
1065: pa_interface_utils_pub.get_messages
1066: (p_encoded => FND_API.G_TRUE,

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

1077: -- 4537865 : RESET x_msg_data also
1078: x_msg_data := SUBSTRB(SQLERRM,1,240);
1079:
1080: -- Set the excetption Message and the stack
1081: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
1082: ,p_procedure_name => 'single_update_schedule',
1083: p_error_text => x_msg_data ); -- 4537865
1084:
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1170: FND_MSG_PUB.initialize;

1166: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1167:
1168: --Clear the global PL/SQL message table
1169: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1170: FND_MSG_PUB.initialize;
1171: END IF;
1172:
1173: -- Initialize the Error Stack
1174: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.mass_update_schedule');

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

1381: -- 4537865 : RESET x_msg_data also
1382: x_msg_data := SUBSTRB(SQLERRM,1,240);
1383:
1384: -- Set the excetption Message and the stack
1385: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
1386: ,p_procedure_name => 'mass_update_schedule'
1387: ,p_error_text => x_msg_data ); -- 4537865
1388:
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1390: x_msg_count := FND_MSG_PUB.Count_Msg;

1386: ,p_procedure_name => 'mass_update_schedule'
1387: ,p_error_text => x_msg_data ); -- 4537865
1388:
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: x_msg_count := FND_MSG_PUB.Count_Msg;
1391:
1392: RAISE; -- This is optional depending on the needs
1393: END mass_update_schedule;
1394:

Line 1491: FND_MSG_PUB.initialize;

1487: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1488:
1489: --Clear the global PL/SQL message table
1490: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1491: FND_MSG_PUB.initialize;
1492: END IF;
1493:
1494: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1495: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 1747: x_msg_count := FND_MSG_PUB.Count_Msg;

1743: ----------------------------------------------------------------------
1744: PA_SCHEDULE_UTILS.log_message(1,'End of the change_duration API ..... ');
1745: x_return_status := l_x_return_status;
1746:
1747: x_msg_count := FND_MSG_PUB.Count_Msg;
1748: If x_msg_count = 1 THEN
1749: pa_interface_utils_pub.get_messages
1750: (p_encoded => FND_API.G_TRUE ,
1751: p_msg_index => 1,

Line 1764: x_msg_count := FND_MSG_PUB.Count_Msg;

1760: WHEN l_ei_asgn_out_of_range THEN
1761: PA_UTILS.Add_Message('PA', l_error_message_code);
1762: x_return_status := FND_API.G_RET_STS_ERROR;
1763: x_msg_data := l_error_message_code;
1764: x_msg_count := FND_MSG_PUB.Count_Msg;
1765: If x_msg_count = 1 THEN
1766: pa_interface_utils_pub.get_messages
1767: (p_encoded => FND_API.G_TRUE,
1768: p_msg_index => 1,

Line 1779: x_msg_count := FND_MSG_PUB.Count_Msg;

1775: WHEN l_resource_cc_error_u THEN
1776: PA_UTILS.Add_Message('PA', l_error_message_code);
1777: x_return_status := FND_API.G_RET_STS_ERROR;
1778: x_msg_data := l_error_message_code;
1779: x_msg_count := FND_MSG_PUB.Count_Msg;
1780: If x_msg_count = 1 THEN
1781: pa_interface_utils_pub.get_messages
1782: (p_encoded => FND_API.G_TRUE,
1783: p_msg_index => 1,

Line 1794: x_msg_count := FND_MSG_PUB.Count_Msg;

1790: WHEN l_resource_cc_error_e THEN
1791: PA_UTILS.Add_Message('PA', 'CROSS_CHARGE_VALIDATION_FAILED');
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: x_msg_data := 'CROSS_CHARGE_VALIDATION_FAILED';
1794: x_msg_count := FND_MSG_PUB.Count_Msg;
1795: If x_msg_count = 1 THEN
1796: pa_interface_utils_pub.get_messages
1797: (p_encoded => FND_API.G_TRUE,
1798: p_msg_index => 1,

Line 1809: x_msg_count := FND_MSG_PUB.Count_Msg;

1805: WHEN l_resource_out_of_range THEN
1806: PA_UTILS.Add_Message( 'PA', 'PA_RESOURCE_OUT_OF_RANGE');
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: x_msg_data := 'PA_RESOURCE_OUT_OF_RANGE';
1809: x_msg_count := FND_MSG_PUB.Count_Msg;
1810: If x_msg_count = 1 THEN
1811: pa_interface_utils_pub.get_messages
1812: (p_encoded => FND_API.G_TRUE,
1813: p_msg_index => 1,

Line 1824: x_msg_count := FND_MSG_PUB.Count_Msg;

1820: WHEN l_stale_asmt_data THEN
1821: PA_UTILS.add_message('PA','PA_XC_RECORD_CHANGED');
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823: x_msg_data := 'PA_XC_RECORD_CHANGED';
1824: x_msg_count := FND_MSG_PUB.Count_Msg;
1825: If x_msg_count = 1 THEN
1826: pa_interface_utils_pub.get_messages
1827: (p_encoded => FND_API.G_TRUE,
1828: p_msg_index => 1,

Line 1839: x_msg_count := FND_MSG_PUB.Count_Msg;

1835: WHEN l_assignment_status_null THEN
1836: PA_UTILS.add_message('PA','PA_SCH_ASGN_STATUS_NULL');
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: x_msg_data := 'PA_SCH_ASGN_STATUS_NULL';
1839: x_msg_count := FND_MSG_PUB.Count_Msg;
1840: If x_msg_count = 1 THEN
1841: pa_interface_utils_pub.get_messages
1842: (p_encoded => FND_API.G_TRUE,
1843: p_msg_index => 1,

Line 1856: x_msg_count := FND_MSG_PUB.Count_Msg;

1852: 'ASMT_TYPE_POSS', l_asgn_req_poss_text,
1853: 'ASMT_TYPE', l_asgn_req_text);
1854: x_msg_data := 'PA_SCH_INVALID_FROM_DATE';
1855: x_return_status := FND_API.G_RET_STS_ERROR;
1856: x_msg_count := FND_MSG_PUB.Count_Msg;
1857: If x_msg_count = 1 THEN
1858: pa_interface_utils_pub.get_messages
1859: (p_encoded => FND_API.G_TRUE,
1860: p_msg_index => 1,

Line 1873: x_msg_count := FND_MSG_PUB.Count_Msg;

1869: 'ASMT_TYPE_POSS', l_asgn_req_poss_text,
1870: 'ASMT_TYPE', l_asgn_req_text);
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: x_msg_data := 'PA_SCH_INVALID_TO_DATE';
1873: x_msg_count := FND_MSG_PUB.Count_Msg;
1874: If x_msg_count = 1 THEN
1875: pa_interface_utils_pub.get_messages
1876: (p_encoded => FND_API.G_TRUE,
1877: p_msg_index => 1,

Line 1893: x_msg_count := FND_MSG_PUB.Count_Msg;

1889: p_token2 => 'ASGN_STATUS',
1890: p_value2 => l_assignment_status_name);
1891: x_return_status := FND_API.G_RET_STS_ERROR;
1892: x_msg_data := 'PA_ASGN_STUS_NOT_FOR_PROJ_STUS';
1893: x_msg_count := FND_MSG_PUB.Count_Msg;
1894: If x_msg_count = 1 THEN
1895: pa_interface_utils_pub.get_messages
1896: (p_encoded => FND_API.G_TRUE,
1897: p_msg_index => 1,

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

1905: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_durarion API ..'||sqlerrm);
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907: x_msg_count := 1;
1908: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1909: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1910: p_procedure_name => 'change_duration');
1911: If x_msg_count = 1 THEN
1912: pa_interface_utils_pub.get_messages
1913: (p_encoded => FND_API.G_TRUE,

Line 1986: FND_MSG_PUB.initialize;

1982: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
1983:
1984: --Clear the global PL/SQL message table
1985: IF (p_init_msg_list = FND_API.G_TRUE) THEN
1986: FND_MSG_PUB.initialize;
1987: END IF;
1988:
1989: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1990: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 2050: x_msg_count := FND_MSG_PUB.Count_Msg;

2046: END IF;
2047:
2048: PA_SCHEDULE_UTILS.log_message(1,'End of the change_hours API ... ');
2049: x_return_status := l_x_return_status;
2050: x_msg_count := FND_MSG_PUB.Count_Msg;
2051: If x_msg_count = 1 THEN
2052: pa_interface_utils_pub.get_messages
2053: (p_encoded => FND_API.G_TRUE ,
2054: p_msg_index => 1,

Line 2068: x_msg_count := FND_MSG_PUB.Count_Msg;

2064: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
2065: 'ASMT_TYPE', l_asgn_req_text);
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
2068: x_msg_count := FND_MSG_PUB.Count_Msg;
2069: If x_msg_count = 1 THEN
2070: pa_interface_utils_pub.get_messages
2071: (p_encoded => FND_API.G_TRUE,
2072: p_msg_index => 1,

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

2080: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_hours API ..'||sqlerrm);
2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2082: x_msg_count := 1;
2083: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
2084: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2085: p_procedure_name => 'change_duration');
2086: If x_msg_count = 1 THEN
2087: pa_interface_utils_pub.get_messages
2088: (p_encoded => FND_API.G_TRUE,

Line 2172: FND_MSG_PUB.initialize;

2168: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2169:
2170: --Clear the global PL/SQL message table
2171: IF (p_init_msg_list = FND_API.G_TRUE) THEN
2172: FND_MSG_PUB.initialize;
2173: END IF;
2174:
2175: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2176: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 2314: x_msg_count := FND_MSG_PUB.Count_Msg;

2310:
2311: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');
2312: x_return_status := l_x_return_status;
2313:
2314: x_msg_count := FND_MSG_PUB.Count_Msg;
2315: If x_msg_count = 1 THEN
2316: pa_interface_utils_pub.get_messages
2317: (p_encoded => FND_API.G_TRUE ,
2318: p_msg_index => 1,

Line 2332: x_msg_count := FND_MSG_PUB.Count_Msg;

2328: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
2329: 'ASMT_TYPE', l_asgn_req_text);
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
2332: x_msg_count := FND_MSG_PUB.Count_Msg;
2333: If x_msg_count = 1 THEN
2334: pa_interface_utils_pub.get_messages
2335: (p_encoded => FND_API.G_TRUE,
2336: p_msg_index => 1,

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

2344: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern API ..'||sqlerrm);
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: x_msg_count := 1;
2347: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr with substrb
2348: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2349: p_procedure_name => 'change_work_pattern');
2350: If x_msg_count = 1 THEN
2351: pa_interface_utils_pub.get_messages
2352: (p_encoded => FND_API.G_TRUE,

Line 2444: FND_MSG_PUB.initialize;

2440: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2441:
2442: --Clear the global PL/SQL message table
2443: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2444: FND_MSG_PUB.initialize;
2445: END IF;
2446:
2447: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2448: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');

Line 2567: x_msg_count := FND_MSG_PUB.Count_Msg;

2563:
2564: PA_SCHEDULE_UTILS.log_message(1,'End of the change_status API ... ');
2565: x_return_status := l_x_return_status;
2566:
2567: x_msg_count := FND_MSG_PUB.Count_Msg;
2568: If x_msg_count = 1 THEN
2569: pa_interface_utils_pub.get_messages
2570: (p_encoded => FND_API.G_TRUE ,
2571: p_msg_index => 1,

Line 2582: x_msg_count := FND_MSG_PUB.Count_Msg;

2578:
2579: EXCEPTION
2580: WHEN FND_API.G_EXC_ERROR THEN
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: x_msg_count := FND_MSG_PUB.Count_Msg;
2583:
2584: IF x_msg_count = 1 THEN
2585: pa_interface_utils_pub.get_messages
2586: (p_encoded => FND_API.G_TRUE,

Line 2595: x_msg_count := FND_MSG_PUB.Count_Msg;

2591: WHEN l_stale_asmt_data THEN
2592: PA_UTILS.add_message('PA','PA_XC_RECORD_CHANGED');
2593: x_return_status := FND_API.G_RET_STS_ERROR;
2594: x_msg_data := 'PA_XC_RECORD_CHANGED';
2595: x_msg_count := FND_MSG_PUB.Count_Msg;
2596: If x_msg_count = 1 THEN
2597: pa_interface_utils_pub.get_messages
2598: (p_encoded => FND_API.G_TRUE,
2599: p_msg_index => 1,

Line 2613: x_msg_count := FND_MSG_PUB.Count_Msg;

2609: 'A_OR_AN', l_a_an_text,
2610: 'ASMT_TYPE', l_asgn_req_text);
2611: x_return_status := FND_API.G_RET_STS_ERROR;
2612: x_msg_data := 'PA_INVALID_ASGN_CANCELLED_DATE';
2613: x_msg_count := FND_MSG_PUB.Count_Msg;
2614: If x_msg_count = 1 THEN
2615: pa_interface_utils_pub.get_messages
2616: (p_encoded => FND_API.G_TRUE,
2617: p_msg_index => 1,

Line 2629: x_msg_count := FND_MSG_PUB.Count_Msg;

2625: PA_UTILS.add_message('PA','PA_SCH_INVALID_FROM_TO_DATE',
2626: 'ASMT_TYPE', l_asgn_req_text);
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: x_msg_data := 'PA_SCH_INVALID_FROM_TO_DATE';
2629: x_msg_count := FND_MSG_PUB.Count_Msg;
2630: If x_msg_count = 1 THEN
2631: pa_interface_utils_pub.get_messages
2632: (p_encoded => FND_API.G_TRUE,
2633: p_msg_index => 1,

Line 2649: x_msg_count := FND_MSG_PUB.Count_Msg;

2645: p_token2 => 'ASGN_STATUS',
2646: p_value2 => l_assignment_status_name);
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: x_msg_data := 'PA_ASGN_STUS_NOT_FOR_PROJ_STUS';
2649: x_msg_count := FND_MSG_PUB.Count_Msg;
2650: If x_msg_count = 1 THEN
2651: pa_interface_utils_pub.get_messages
2652: (p_encoded => FND_API.G_TRUE,
2653: p_msg_index => 1,

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

2661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2662: x_msg_count := 1;
2663: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 Replaced substr with substrb
2664: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_status API ..'||sqlerrm);
2665: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2666: p_procedure_name => 'change_status');
2667: If x_msg_count = 1 THEN
2668: pa_interface_utils_pub.get_messages
2669: (p_encoded => FND_API.G_TRUE,

Line 2729: fnd_msg_pub.initialize;

2725: -- storing the status success to track the error
2726: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2727:
2728: --Clear the global PL/SQL message table
2729: fnd_msg_pub.initialize;
2730:
2731: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2732: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');

Line 2757: x_msg_count := FND_MSG_PUB.Count_Msg;

2753: FROM jtf_calendars_vl
2754: WHERE calendar_name = p_calendar_name;
2755:
2756:
2757: x_msg_count := FND_MSG_PUB.Count_Msg;
2758: If x_msg_count = 1 THEN
2759: pa_interface_utils_pub.get_messages
2760: (p_encoded => FND_API.G_TRUE ,
2761: p_msg_index => 1,

Line 2809: x_msg_count := FND_MSG_PUB.Count_Msg;

2805:
2806: PA_SCHEDULE_UTILS.log_message(1,'End of the change_calendar API ... ');
2807: x_return_status := l_x_return_status;
2808:
2809: x_msg_count := FND_MSG_PUB.Count_Msg;
2810: If x_msg_count = 1 THEN
2811: pa_interface_utils_pub.get_messages
2812: (p_encoded => FND_API.G_TRUE ,
2813: p_msg_index => 1,

Line 2827: x_msg_count := FND_MSG_PUB.Count_Msg;

2823: WHEN l_invalid_duplicate_cal_name THEN
2824: PA_UTILS.add_message('PA','PA_CALENDAR_INVALID_AMBIGOUS');
2825: x_return_status := FND_API.G_RET_STS_ERROR;
2826: x_msg_data := 'PA_CALENDAR_INVALID_AMBIGOUS';
2827: x_msg_count := FND_MSG_PUB.Count_Msg;
2828: If x_msg_count = 1 THEN
2829: pa_interface_utils_pub.get_messages
2830: (p_encoded => FND_API.G_TRUE,
2831: p_msg_index => 1,

Line 2842: x_msg_count := FND_MSG_PUB.Count_Msg;

2838: WHEN l_from_to_date_null THEN
2839: PA_UTILS.add_message('PA','PA_SCH_FROM_TO_DATE_NULL');
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841: x_msg_data := 'PA_SCH_FROM_TO_DATE_NULL';
2842: x_msg_count := FND_MSG_PUB.Count_Msg;
2843: If x_msg_count = 1 THEN
2844: pa_interface_utils_pub.get_messages
2845: (p_encoded => FND_API.G_TRUE,
2846: p_msg_index => 1,

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

2854: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_calendar API ..'||sqlerrm);
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: x_msg_count := 1;
2857: x_msg_data := substrb(SQLERRM,1,240); -- Changed substr to substrb : 4537865
2858: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2859: p_procedure_name => 'change_calendar');
2860: If x_msg_count = 1 THEN
2861: pa_interface_utils_pub.get_messages
2862: (p_encoded => FND_API.G_TRUE,

Line 2917: x_msg_count := FND_MSG_PUB.Count_Msg;

2913: PA_SCHEDULE_UTILS.log_message(1,'End of the change_schedule API ... ');
2914:
2915: x_return_status := l_x_return_status;
2916:
2917: x_msg_count := FND_MSG_PUB.Count_Msg;
2918: If x_msg_count = 1 THEN
2919: pa_interface_utils_pub.get_messages
2920: (p_encoded => FND_API.G_TRUE ,
2921: p_msg_index => 1,

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

2931: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_schedule API ..'||sqlerrm);
2932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: x_msg_count := 1;
2934: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr usage with substrb
2935: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2936: p_procedure_name => 'change_schedule');
2937: If x_msg_count = 1 THEN
2938: pa_interface_utils_pub.get_messages
2939: (p_encoded => FND_API.G_TRUE ,

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

3322: -- Calling the Timeline api to create the timeline records
3323: -- for the assignment
3324: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3325: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
3326: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
3327: PA_TIMELINE_PVT.create_timeline (
3328: p_assignment_id =>p_assignment_id ,
3329: x_return_status =>l_x_return_status ,
3330: x_msg_count =>x_msg_count ,

Line 3371: x_msg_count := FND_MSG_PUB.Count_Msg;

3367:
3368: PA_SCHEDULE_UTILS.log_message(1,'End of the change_asgn_schedule API ... ');
3369: x_return_status := l_x_return_status;
3370:
3371: x_msg_count := FND_MSG_PUB.Count_Msg;
3372:
3373: If x_msg_count = 1 THEN
3374: pa_interface_utils_pub.get_messages
3375: (p_encoded => FND_API.G_TRUE ,

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

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

Line 3476: x_msg_count := FND_MSG_PUB.Count_Msg;

3472:
3473: PA_SCHEDULE_UTILS.log_message(1,'End of the create_calendar_schedule API ... ');
3474:
3475: x_return_status := l_x_return_status;
3476: x_msg_count := FND_MSG_PUB.Count_Msg;
3477: If x_msg_count = 1 THEN
3478: pa_interface_utils_pub.get_messages
3479: (p_encoded => FND_API.G_TRUE ,
3480: p_msg_index => 1,

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

3489: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_calendar_schedule API ..'||sqlerrm);
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: x_msg_count := 1;
3492: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 changed substr to substrb
3493: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3494: p_procedure_name => 'create_calendar_schedule');
3495: If x_msg_count = 1 THEN
3496: pa_interface_utils_pub.get_messages
3497: (p_encoded => FND_API.G_TRUE,

Line 3648: x_msg_count := FND_MSG_PUB.Count_Msg;

3644: PA_SCHEDULE_UTILS.log_message(1,'ERROR: invalid calendar id at profile option ..');
3645: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3646: x_return_status := FND_API.G_RET_STS_ERROR;
3647: x_msg_data := 'PA_INVALID_PROFILE_CALENDAR_ID';
3648: x_msg_count := FND_MSG_PUB.Count_Msg;
3649:
3650: -- RESET other out params also : 4537865
3651: x_calendar_id := NULL ;
3652: x_calendar_name := NULL;

Line 3669: x_msg_count := FND_MSG_PUB.Count_Msg;

3665: PA_SCHEDULE_UTILS.log_message(1,'ERROR: Null calendar id at profile option ..');
3666: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3667: x_return_status := FND_API.G_RET_STS_ERROR;
3668: x_msg_data := 'PA_NULL_PROFILE_CALENDAR_ID';
3669: x_msg_count := FND_MSG_PUB.Count_Msg;
3670:
3671: -- RESET other out params also : 4537865
3672: x_calendar_id := NULL ;
3673: x_calendar_name := NULL;

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

3691: -- RESET other out params also : 4537865
3692: x_calendar_id := NULL ;
3693: x_calendar_name := NULL;
3694:
3695: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3696: p_procedure_name => 'get_proj_calendar_default');
3697: If x_msg_count = 1 THEN
3698: pa_interface_utils_pub.get_messages
3699: (p_encoded => FND_API.G_TRUE,

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

3821: -- to the report file. Therefore, we have to raise expected errors.
3822: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3823:
3824: IF l_debug_mode = 'Y' THEN
3825: pa_debug.write_file('CREATE_NEW_CAL_SCHEDULES: '||'LOG', 'msg_count = '||FND_MSG_PUB.Count_Msg);
3826: END IF;
3827:
3828: FOR l_counter IN 1..FND_MSG_PUB.Count_Msg LOOP
3829: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE

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

3824: IF l_debug_mode = 'Y' THEN
3825: pa_debug.write_file('CREATE_NEW_CAL_SCHEDULES: '||'LOG', 'msg_count = '||FND_MSG_PUB.Count_Msg);
3826: END IF;
3827:
3828: FOR l_counter IN 1..FND_MSG_PUB.Count_Msg LOOP
3829: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
3830: ,p_msg_index => l_counter
3831: ,p_data => x_msg_data
3832: ,p_msg_index_out => l_msg_index_out);

Line 3846: x_msg_count := FND_MSG_PUB.Count_Msg;

3842:
3843: END LOOP;
3844:
3845: x_return_status := FND_API.G_RET_STS_SUCCESS;
3846: x_msg_count := FND_MSG_PUB.Count_Msg;
3847: If x_msg_count = 1 THEN
3848: pa_interface_utils_pub.get_messages
3849: (p_encoded => FND_API.G_TRUE ,
3850: p_msg_index => 1,

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

3866: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_cal_schedules API ..'|| sqlerrm);
3867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3868: x_msg_count := 1;
3869: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substrb to substr
3870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3871: p_procedure_name => 'create_new_cal_schedules');
3872: If x_msg_count = 1 THEN
3873: pa_interface_utils_pub.get_messages
3874: (p_encoded => FND_API.G_TRUE,

Line 3975: FND_MSG_PUB.initialize;

3971:
3972: l_data varchar2(2000); -- 4537865
3973: BEGIN
3974:
3975: FND_MSG_PUB.initialize;
3976: l_count := p_hours_table.COUNT;
3977: p_end_date := p_start_date+13;
3978:
3979: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167

Line 5014: x_msg_count := FND_MSG_PUB.Count_Msg;

5010:
5011: EXCEPTION
5012: WHEN FND_API.G_EXC_ERROR THEN -- Added for Bug 3235656
5013: x_return_status := FND_API.G_RET_STS_ERROR;
5014: x_msg_count := FND_MSG_PUB.Count_Msg;
5015:
5016: -- 4537865 : RESET other out params also.
5017: x_call_timeline_st_date := NULL ;
5018: x_call_timeline_end_date := NULL ;

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

5035: -- 4537865 : RESET other out params also.
5036: x_call_timeline_st_date := NULL ;
5037: x_call_timeline_end_date := NULL ;
5038:
5039: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
5040: p_procedure_name => 'change_work_pattern_duration');
5041: IF x_msg_count = 1 THEN
5042: pa_interface_utils_pub.get_messages
5043: (p_encoded => FND_API.G_TRUE,

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

5053: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern_duration API ..'|| sqlerrm);
5054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5055: x_msg_count := 1;
5056: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Chnaged substr to substrb
5057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
5058: p_procedure_name => 'change_work_pattern_duration');
5059:
5060: -- 4537865 : RESET other out params also.
5061: x_call_timeline_st_date := NULL ;

Line 5221: FND_MSG_PUB.initialize;

5217: --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
5218: ORDER BY resource_id, assignment_id, item_date, forecast_item_type desc;
5219:
5220: BEGIN
5221: FND_MSG_PUB.initialize;
5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);

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

5811: x_msg_data := substrb(SQLERRM,1,240); -- 4537865
5812: -- RESET x_show_start_date also
5813: x_show_start_date := NULL ;
5814:
5815: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
5816: p_procedure_name => 'Populate_work_pattern_table');
5817: IF x_msg_count = 1 THEN
5818: pa_interface_utils_pub.get_messages
5819: (p_encoded => FND_API.G_TRUE,