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

150:
151: --Clear the global PL/SQL message table
152: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
153:
154: FND_MSG_PUB.initialize;
155: END IF;
156:
157: --Log Message
158: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 411: IF FND_MSG_PUB.Count_Msg > 0 THEN

407: PA_DEBUG.Reset_Err_Stack;
408:
409: -- If there are any messages in the stack then set x_return_status
410:
411: IF FND_MSG_PUB.Count_Msg > 0 THEN
412:
413: x_return_status := FND_API.G_RET_STS_ERROR;
414:
415: END IF;

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

432: END IF;
433: EXCEPTION
434: WHEN OTHERS THEN
435: -- Set the excetption Message and the stack
436: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
437: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
438: --
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: RAISE; -- This is optional depending on the needs

Line 489: FND_MSG_PUB.initialize;

485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: --Clear the global PL/SQL message table
488: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:
492: --Log Message
493: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

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

558: EXCEPTION
559: WHEN OTHERS THEN
560:
561: -- Set the excetption Message and the stack
562: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
563: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
564: --
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: RAISE; -- This is optional depending on the needs

Line 651: FND_MSG_PUB.initialize;

647:
648: --Clear the global PL/SQL message table
649: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
650:
651: FND_MSG_PUB.initialize;
652: END IF;
653: --Log Message
654: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
655: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.begin'

Line 839: x_msg_count := FND_MSG_PUB.Count_Msg;

835: --
836: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
837: --
838:
839: x_msg_count := FND_MSG_PUB.Count_Msg;
840:
841: IF x_msg_count = 1 THEN
842: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
843: ,p_msg_index => 1

Line 855: IF FND_MSG_PUB.Count_Msg >0 THEN

851: PA_DEBUG.Reset_Err_Stack;
852:
853: -- If g_error_exists is TRUE then set the x_return_status to 'E'
854:
855: IF FND_MSG_PUB.Count_Msg >0 THEN
856:
857: x_return_status := FND_API.G_RET_STS_ERROR;
858:
859: END IF;

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

873: IF p_commit = FND_API.G_TRUE THEN
874: ROLLBACK TO ASG_PUB_CREATE_ASGMT_WITH_DEF;
875: END IF;
876: -- Set the excetption Message and the stack
877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
878: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
879: --
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: RAISE; -- This is optional depending on the needs

Line 1026: FND_MSG_PUB.initialize;

1022: END IF;
1023:
1024: --Clear the global PL/SQL message table
1025: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1026: FND_MSG_PUB.initialize;
1027: END IF;
1028:
1029: --Log Message
1030: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1853: x_msg_count := FND_MSG_PUB.Count_Msg;

1849: --
1850: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
1851: --
1852:
1853: x_msg_count := FND_MSG_PUB.Count_Msg;
1854:
1855: IF x_msg_count = 1 THEN
1856: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1857: ,p_msg_index => 1

Line 1874: IF FND_MSG_PUB.Count_Msg > 0 THEN

1870: PA_DEBUG.Reset_Err_Stack;
1871:
1872: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1873:
1874: IF FND_MSG_PUB.Count_Msg > 0 THEN
1875:
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877:
1878: END IF;

Line 1905: x_msg_count := FND_MSG_PUB.Count_Msg;

1901:
1902: ----addded for 13336768
1903: WHEN FND_API.G_EXC_ERROR THEN
1904: x_return_status := FND_API.G_RET_STS_ERROR;
1905: x_msg_count := FND_MSG_PUB.Count_Msg;
1906:
1907: IF x_msg_count = 1 THEN
1908: pa_interface_utils_pub.get_messages
1909: (p_encoded => FND_API.G_TRUE,

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

1921: --clear global table of newly created assignment ids
1922: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
1923:
1924: -- Set the excetption Message and the stack
1925: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
1926: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1927: --
1928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1929: RAISE;

Line 1981: FND_MSG_PUB.initialize;

1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978:
1979: -- Clear the global PL/SQL message table
1980: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1981: FND_MSG_PUB.initialize;
1982: END IF;
1983:
1984: --Log Message
1985: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 2039: x_msg_count := FND_MSG_PUB.Count_Msg;

2035: );
2036:
2037: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2038:
2039: x_msg_count := FND_MSG_PUB.Count_Msg;
2040: IF x_msg_count = 1 THEN
2041: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2042: ,p_msg_index => 1
2043: ,p_data => x_msg_data

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

2063: EXCEPTION
2064: WHEN OTHERS THEN
2065:
2066: -- Set the excetption Message and the stack
2067: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Exec_Staff_Assign_From_Open'
2068: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2069: --
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2071: RAISE; -- This is optional depending on the needs

Line 2356: FND_MSG_PUB.initialize;

2352: END IF;
2353:
2354: --Clear the global PL/SQL message table
2355: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2356: FND_MSG_PUB.initialize;
2357: END IF;
2358:
2359: --Log Message
2360: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3139: x_msg_count := FND_MSG_PUB.Count_Msg;

3135: --
3136:
3137: CLOSE check_record_version;
3138:
3139: x_msg_count := FND_MSG_PUB.Count_Msg;
3140: IF x_msg_count = 1 THEN
3141: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
3142: ,p_msg_index => 1
3143: ,p_data => x_msg_data

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

3168: IF p_commit = FND_API.G_TRUE THEN
3169: ROLLBACK TO ASG_PUB_STAFF_ASSIGN_FROM_OPEN;
3170: END IF;
3171: -- Set the excetption Message and the stack
3172: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
3173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3174: --
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3176: RAISE; -- This is optional depending on the needs

Line 3327: FND_MSG_PUB.initialize;

3323: END IF;
3324:
3325: --Clear the global PL/SQL message table
3326: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
3327: FND_MSG_PUB.initialize;
3328: END IF;
3329:
3330: --dbms_output.put_line('In execute_update_assigment');
3331:

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

3499: EXCEPTION
3500: WHEN OTHERS THEN
3501:
3502: -- Set the excetption Message and the stack
3503: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
3504: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3505: --
3506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: RAISE; -- This is optional depending on the needs

Line 3699: fnd_msg_pub.initialize;

3695: BEGIN
3696:
3697: G_update_assignment_bulk_call := p_bulk_context;
3698:
3699: fnd_msg_pub.initialize;
3700:
3701: x_return_status_tbl := p_assignment_name_tbl;
3702: x_msg_count_tbl := p_assignment_id_tbl;
3703: x_msg_data_tbl := p_assignment_name_tbl;

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

4329: EXCEPTION
4330: WHEN OTHERS THEN
4331:
4332: -- Set the excetption Message and the stack
4333: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
4334: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4335: --
4336: x_return_status_tbl(i) := FND_API.G_RET_STS_UNEXP_ERROR ;
4337: RAISE; -- This is optional depending on the needs

Line 4510: FND_MSG_PUB.initialize;

4506: END IF;
4507:
4508: --Clear the global PL/SQL message table
4509: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
4510: FND_MSG_PUB.initialize;
4511: END IF;
4512:
4513: -- Assign the record to the local variable
4514: l_assignment_rec := p_assignment_rec;

Line 5817: x_msg_count := FND_MSG_PUB.Count_Msg;

5813:
5814: --
5815: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
5816: --
5817: x_msg_count := FND_MSG_PUB.Count_Msg;
5818: IF x_msg_count = 1 THEN
5819: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
5820: ,p_msg_index => 1
5821: ,p_data => x_msg_data

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

5852: IF p_commit = FND_API.G_TRUE THEN
5853: ROLLBACK TO ASG_PUB_UPDATE_ASSIGNMENT;
5854: END IF;
5855: -- Set the excetption Message and the stack
5856: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Update_Assignment'
5857: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5858: --
5859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5860: RAISE; -- This is optional depending on the needs

Line 5940: FND_MSG_PUB.initialize;

5936: END IF;
5937:
5938: --Clear the global PL/SQL message table
5939: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
5940: FND_MSG_PUB.initialize;
5941: END IF;
5942:
5943:
5944: --check if this assignment is the source of another assignment.

Line 6041: x_msg_count := FND_MSG_PUB.Count_Msg;

6037: END IF;
6038: --
6039: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
6040: --
6041: x_msg_count := FND_MSG_PUB.Count_Msg;
6042: IF x_msg_count = 1 THEN
6043: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
6044: ,p_msg_index => 1
6045: ,p_data => x_msg_data

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

6076: IF p_commit = FND_API.G_TRUE THEN
6077: ROLLBACK TO ASG_PUB_DELETE_ASSIGNMENT;
6078: END IF;
6079: -- Set the excetption Message and the stack
6080: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_Assignment'
6081: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6082: --
6083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6084: RAISE; -- This is optional depending on the needs

Line 6132: FND_MSG_PUB.initialize;

6128: END IF;
6129:
6130: --Clear the global PL/SQL message table
6131: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
6132: FND_MSG_PUB.initialize;
6133: END IF;
6134:
6135: --Initialize return status to success
6136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6346: x_msg_count := FND_MSG_PUB.Count_Msg;

6342:
6343: --
6344: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
6345: --
6346: x_msg_count := FND_MSG_PUB.Count_Msg;
6347: IF x_msg_count = 1 THEN
6348: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
6349: ,p_msg_index => 1
6350: ,p_data => x_msg_data

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

6365:
6366: EXCEPTION
6367: WHEN OTHERS THEN
6368: -- Set the excetption Message and the stack
6369: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Copy_Team_Role'
6370: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6371: --
6372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6373: RAISE;

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

6593: );
6594:
6595:
6596: --if p_validate_only=false and there are no errors then start the workflow process.
6597: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
6598:
6599: OPEN csr_get_tp_amt_type(l_new_assignment_id);
6600: FETCH csr_get_tp_amt_type into l_asg_tp_amount_type;
6601: CLOSE csr_get_tp_amt_type;

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

6661:
6662: EXCEPTION
6663: WHEN OTHERS THEN
6664: -- Set the exception Message and the stack
6665: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Create_Assignments'
6666: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6667: --
6668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6669:

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

6901:
6902: EXCEPTION
6903: WHEN OTHERS THEN
6904: -- Set the exception Message and the stack
6905: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Create_Assignments'
6906: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6907: --
6908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6909: RAISE;

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

7073: ,x_msg_data => x_msg_data
7074: );
7075:
7076: --if p_validate_only=false and there are no errors then start the workflow process.
7077: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
7078:
7079: IF p_asgn_update_mode = 'Forecast' THEN
7080: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
7081: ELSE

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

7144:
7145: EXCEPTION
7146: WHEN OTHERS THEN
7147: -- Set the exception Message and the stack
7148: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Update_Assignments'
7149: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7150: --
7151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7152: RAISE;

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

7274: BEGIN
7275:
7276: --dbms_output.put_line('mass_update_assignments');
7277:
7278: --should we clear the fnd_msg_pub stack right here?
7279: --if we will pass p_init_msg_list = false to the API
7280: --so that we don't clear the stack between assignments then we
7281: --should clear the stack here before we start looping.
7282: --open issue - waiting to find out how errors will be handled

Line 7284: --FND_MSG_PUB.initialize;

7280: --so that we don't clear the stack between assignments then we
7281: --should clear the stack here before we start looping.
7282: --open issue - waiting to find out how errors will be handled
7283: --in mass assign.
7284: --FND_MSG_PUB.initialize;
7285:
7286: --assign local plsql table
7287: --update this local table for out x_success_assignment_id_tbl
7288: l_assignment_id_tbl := p_assignment_id_tbl;

Line 7498: x_msg_count := FND_MSG_PUB.Count_Msg;

7494:
7495: --
7496: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
7497: --
7498: x_msg_count := FND_MSG_PUB.Count_Msg;
7499: IF x_msg_count = 1 THEN
7500: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
7501: ,p_msg_index => 1
7502: ,p_data => x_msg_data

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

7517:
7518: EXCEPTION
7519: WHEN OTHERS THEN
7520: -- Set the exception Message and the stack
7521: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Update_Assignment'
7522: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7523: --
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: RAISE;

Line 7664: FND_MSG_PUB.initialize;

7660: END IF;
7661:
7662: --Clear the global PL/SQL message table
7663: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
7664: FND_MSG_PUB.initialize;
7665: END IF;
7666:
7667: BEGIN
7668: SELECT 'Y'

Line 7808: IF FND_MSG_PUB.Count_Msg > 0 THEN

7804: END IF;
7805: END IF;
7806: END;
7807:
7808: IF FND_MSG_PUB.Count_Msg > 0 THEN
7809: RAISE FND_API.G_EXC_ERROR;
7810: END IF;
7811:
7812: -- Assign the scalar parameters to the assignment record fields

Line 7978: FND_MSG_PUB.initialize;

7974: END IF;
7975:
7976: --Clear the global PL/SQL message table
7977: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
7978: FND_MSG_PUB.initialize;
7979: END IF;
7980:
7981: FOR l_rec IN asgn_details
7982: LOOP

Line 8013: x_msg_count := FND_MSG_PUB.Count_Msg;

8009:
8010: --
8011: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
8012: --
8013: x_msg_count := FND_MSG_PUB.Count_Msg;
8014: IF x_msg_count = 1 THEN
8015: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
8016: ,p_msg_index => 1
8017: ,p_data => x_msg_data

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

8049: IF p_commit = FND_API.G_TRUE THEN
8050: ROLLBACK TO ASG_PUB_DELETE_PJR_TXNS;
8051: END IF;
8052: -- Set the exception Message and the stack
8053: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_PJR_Txns'
8054: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
8055: --
8056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8057: RAISE; -- This is optional depending on the needs