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

Line 146: FND_MSG_PUB.initialize;

142:
143: --Clear the global PL/SQL message table
144: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
145:
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: --Log Message
150: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 376: IF FND_MSG_PUB.Count_Msg > 0 THEN

372: PA_DEBUG.Reset_Err_Stack;
373:
374: -- If there are any messages in the stack then set x_return_status
375:
376: IF FND_MSG_PUB.Count_Msg > 0 THEN
377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379:
380: END IF;

Line 401: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'

397: END IF;
398: EXCEPTION
399: WHEN OTHERS THEN
400: -- Set the excetption Message and the stack
401: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
402: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
403: --
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: RAISE; -- This is optional depending on the needs

Line 454: FND_MSG_PUB.initialize;

450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: --Clear the global PL/SQL message table
453: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: --Log Message
458: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 527: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'

523: EXCEPTION
524: WHEN OTHERS THEN
525:
526: -- Set the excetption Message and the stack
527: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
528: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
529: --
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
531: RAISE; -- This is optional depending on the needs

Line 616: FND_MSG_PUB.initialize;

612:
613: --Clear the global PL/SQL message table
614: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
615:
616: FND_MSG_PUB.initialize;
617: END IF;
618: --Log Message
619: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
620: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.begin'

Line 804: x_msg_count := FND_MSG_PUB.Count_Msg;

800: --
801: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
802: --
803:
804: x_msg_count := FND_MSG_PUB.Count_Msg;
805:
806: IF x_msg_count = 1 THEN
807: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
808: ,p_msg_index => 1

Line 820: IF FND_MSG_PUB.Count_Msg >0 THEN

816: PA_DEBUG.Reset_Err_Stack;
817:
818: -- If g_error_exists is TRUE then set the x_return_status to 'E'
819:
820: IF FND_MSG_PUB.Count_Msg >0 THEN
821:
822: x_return_status := FND_API.G_RET_STS_ERROR;
823:
824: END IF;

Line 842: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'

838: IF p_commit = FND_API.G_TRUE THEN
839: ROLLBACK TO ASG_PUB_CREATE_ASGMT_WITH_DEF;
840: END IF;
841: -- Set the excetption Message and the stack
842: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
843: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
844: --
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: RAISE; -- This is optional depending on the needs

Line 991: FND_MSG_PUB.initialize;

987: END IF;
988:
989: --Clear the global PL/SQL message table
990: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
991: FND_MSG_PUB.initialize;
992: END IF;
993:
994: --Log Message
995: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1804: x_msg_count := FND_MSG_PUB.Count_Msg;

1800: --
1801: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
1802: --
1803:
1804: x_msg_count := FND_MSG_PUB.Count_Msg;
1805:
1806: IF x_msg_count = 1 THEN
1807: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1808: ,p_msg_index => 1

Line 1825: IF FND_MSG_PUB.Count_Msg > 0 THEN

1821: PA_DEBUG.Reset_Err_Stack;
1822:
1823: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1824:
1825: IF FND_MSG_PUB.Count_Msg > 0 THEN
1826:
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: END IF;

Line 1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'

1858: --clear global table of newly created assignment ids
1859: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
1860:
1861: -- Set the excetption Message and the stack
1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
1863: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1864: --
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: RAISE;

Line 1918: FND_MSG_PUB.initialize;

1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Clear the global PL/SQL message table
1917: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1918: FND_MSG_PUB.initialize;
1919: END IF;
1920:
1921: --Log Message
1922: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1976: x_msg_count := FND_MSG_PUB.Count_Msg;

1972: );
1973:
1974: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1975:
1976: x_msg_count := FND_MSG_PUB.Count_Msg;
1977: IF x_msg_count = 1 THEN
1978: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1979: ,p_msg_index => 1
1980: ,p_data => x_msg_data

Line 2004: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Exec_Staff_Assign_From_Open'

2000: EXCEPTION
2001: WHEN OTHERS THEN
2002:
2003: -- Set the excetption Message and the stack
2004: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Exec_Staff_Assign_From_Open'
2005: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2006: --
2007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2008: RAISE; -- This is optional depending on the needs

Line 2291: FND_MSG_PUB.initialize;

2287: END IF;
2288:
2289: --Clear the global PL/SQL message table
2290: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2291: FND_MSG_PUB.initialize;
2292: END IF;
2293:
2294: --Log Message
2295: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3057: x_msg_count := FND_MSG_PUB.Count_Msg;

3053: --
3054:
3055: CLOSE check_record_version;
3056:
3057: x_msg_count := FND_MSG_PUB.Count_Msg;
3058: IF x_msg_count = 1 THEN
3059: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
3060: ,p_msg_index => 1
3061: ,p_data => x_msg_data

Line 3090: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'

3086: IF p_commit = FND_API.G_TRUE THEN
3087: ROLLBACK TO ASG_PUB_STAFF_ASSIGN_FROM_OPEN;
3088: END IF;
3089: -- Set the excetption Message and the stack
3090: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
3091: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3092: --
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3094: RAISE; -- This is optional depending on the needs

Line 3243: FND_MSG_PUB.initialize;

3239: END IF;
3240:
3241: --Clear the global PL/SQL message table
3242: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
3243: FND_MSG_PUB.initialize;
3244: END IF;
3245:
3246: --dbms_output.put_line('In execute_update_assigment');
3247:

Line 3412: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'

3408: EXCEPTION
3409: WHEN OTHERS THEN
3410:
3411: -- Set the excetption Message and the stack
3412: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
3413: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3414: --
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: RAISE; -- This is optional depending on the needs

Line 3584: FND_MSG_PUB.initialize;

3580: END IF;
3581:
3582: --Clear the global PL/SQL message table
3583: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
3584: FND_MSG_PUB.initialize;
3585: END IF;
3586:
3587:
3588: -- Assign the record to the local variable

Line 4841: x_msg_count := FND_MSG_PUB.Count_Msg;

4837:
4838: --
4839: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
4840: --
4841: x_msg_count := FND_MSG_PUB.Count_Msg;
4842: IF x_msg_count = 1 THEN
4843: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
4844: ,p_msg_index => 1
4845: ,p_data => x_msg_data

Line 4879: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Update_Assignment'

4875: IF p_commit = FND_API.G_TRUE THEN
4876: ROLLBACK TO ASG_PUB_UPDATE_ASSIGNMENT;
4877: END IF;
4878: -- Set the excetption Message and the stack
4879: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Update_Assignment'
4880: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4881: --
4882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4883: RAISE; -- This is optional depending on the needs

Line 4964: FND_MSG_PUB.initialize;

4960: END IF;
4961:
4962: --Clear the global PL/SQL message table
4963: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
4964: FND_MSG_PUB.initialize;
4965: END IF;
4966:
4967:
4968: --check if this assignment is the source of another assignment.

Line 5065: x_msg_count := FND_MSG_PUB.Count_Msg;

5061: END IF;
5062: --
5063: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
5064: --
5065: x_msg_count := FND_MSG_PUB.Count_Msg;
5066: IF x_msg_count = 1 THEN
5067: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
5068: ,p_msg_index => 1
5069: ,p_data => x_msg_data

Line 5104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_Assignment'

5100: IF p_commit = FND_API.G_TRUE THEN
5101: ROLLBACK TO ASG_PUB_DELETE_ASSIGNMENT;
5102: END IF;
5103: -- Set the excetption Message and the stack
5104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_Assignment'
5105: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5106: --
5107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5108: RAISE; -- This is optional depending on the needs

Line 5156: FND_MSG_PUB.initialize;

5152: END IF;
5153:
5154: --Clear the global PL/SQL message table
5155: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
5156: FND_MSG_PUB.initialize;
5157: END IF;
5158:
5159: --Initialize return status to success
5160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5370: x_msg_count := FND_MSG_PUB.Count_Msg;

5366:
5367: --
5368: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
5369: --
5370: x_msg_count := FND_MSG_PUB.Count_Msg;
5371: IF x_msg_count = 1 THEN
5372: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
5373: ,p_msg_index => 1
5374: ,p_data => x_msg_data

Line 5393: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Copy_Team_Role'

5389:
5390: EXCEPTION
5391: WHEN OTHERS THEN
5392: -- Set the excetption Message and the stack
5393: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Copy_Team_Role'
5394: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5395: --
5396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5397: RAISE;

Line 5621: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN

5617: );
5618:
5619:
5620: --if p_validate_only=false and there are no errors then start the workflow process.
5621: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
5622:
5623: OPEN csr_get_tp_amt_type(l_new_assignment_id);
5624: FETCH csr_get_tp_amt_type into l_asg_tp_amount_type;
5625: CLOSE csr_get_tp_amt_type;

Line 5689: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Create_Assignments'

5685:
5686: EXCEPTION
5687: WHEN OTHERS THEN
5688: -- Set the exception Message and the stack
5689: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Create_Assignments'
5690: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5691: --
5692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5693:

Line 5929: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Create_Assignments'

5925:
5926: EXCEPTION
5927: WHEN OTHERS THEN
5928: -- Set the exception Message and the stack
5929: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Create_Assignments'
5930: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5931: --
5932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5933: RAISE;

Line 6101: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN

6097: ,x_msg_data => x_msg_data
6098: );
6099:
6100: --if p_validate_only=false and there are no errors then start the workflow process.
6101: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
6102:
6103: IF p_asgn_update_mode = 'Forecast' THEN
6104: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
6105: ELSE

Line 6172: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Update_Assignments'

6168:
6169: EXCEPTION
6170: WHEN OTHERS THEN
6171: -- Set the exception Message and the stack
6172: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Update_Assignments'
6173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6174: --
6175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6176: RAISE;

Line 6302: --should we clear the fnd_msg_pub stack right here?

6298: BEGIN
6299:
6300: --dbms_output.put_line('mass_update_assignments');
6301:
6302: --should we clear the fnd_msg_pub stack right here?
6303: --if we will pass p_init_msg_list = false to the API
6304: --so that we don't clear the stack between assignments then we
6305: --should clear the stack here before we start looping.
6306: --open issue - waiting to find out how errors will be handled

Line 6308: --FND_MSG_PUB.initialize;

6304: --so that we don't clear the stack between assignments then we
6305: --should clear the stack here before we start looping.
6306: --open issue - waiting to find out how errors will be handled
6307: --in mass assign.
6308: --FND_MSG_PUB.initialize;
6309:
6310: --assign local plsql table
6311: --update this local table for out x_success_assignment_id_tbl
6312: l_assignment_id_tbl := p_assignment_id_tbl;

Line 6522: x_msg_count := FND_MSG_PUB.Count_Msg;

6518:
6519: --
6520: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
6521: --
6522: x_msg_count := FND_MSG_PUB.Count_Msg;
6523: IF x_msg_count = 1 THEN
6524: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
6525: ,p_msg_index => 1
6526: ,p_data => x_msg_data

Line 6545: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Update_Assignment'

6541:
6542: EXCEPTION
6543: WHEN OTHERS THEN
6544: -- Set the exception Message and the stack
6545: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Update_Assignment'
6546: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6547: --
6548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6549: RAISE;

Line 6688: FND_MSG_PUB.initialize;

6684: END IF;
6685:
6686: --Clear the global PL/SQL message table
6687: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
6688: FND_MSG_PUB.initialize;
6689: END IF;
6690:
6691: BEGIN
6692: SELECT 'Y'

Line 6832: IF FND_MSG_PUB.Count_Msg > 0 THEN

6828: END IF;
6829: END IF;
6830: END;
6831:
6832: IF FND_MSG_PUB.Count_Msg > 0 THEN
6833: RAISE FND_API.G_EXC_ERROR;
6834: END IF;
6835:
6836: -- Assign the scalar parameters to the assignment record fields

Line 7002: FND_MSG_PUB.initialize;

6998: END IF;
6999:
7000: --Clear the global PL/SQL message table
7001: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
7002: FND_MSG_PUB.initialize;
7003: END IF;
7004:
7005: FOR l_rec IN asgn_details
7006: LOOP

Line 7037: x_msg_count := FND_MSG_PUB.Count_Msg;

7033:
7034: --
7035: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
7036: --
7037: x_msg_count := FND_MSG_PUB.Count_Msg;
7038: IF x_msg_count = 1 THEN
7039: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
7040: ,p_msg_index => 1
7041: ,p_data => x_msg_data

Line 7077: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_PJR_Txns'

7073: IF p_commit = FND_API.G_TRUE THEN
7074: ROLLBACK TO ASG_PUB_DELETE_PJR_TXNS;
7075: END IF;
7076: -- Set the exception Message and the stack
7077: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_PJR_Txns'
7078: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7079: --
7080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7081: RAISE; -- This is optional depending on the needs