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.JTF_ASSIGN_PUB dependencies on FND_MESSAGE

Line 1005: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');

1001: l_api_name := l_api_name_1;
1002:
1003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1004: -- Unexpected Execution Error from call to Calendar
1005: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1006: fnd_msg_pub.add;
1007: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1008: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1009: -- Removed Comment to Show error message Bug # 2919389

Line 1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

1091: p_data => x_msg_data
1092: );
1093:
1094: WHEN OTHERS THEN
1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1096: fnd_message.set_token('P_SQLCODE',SQLCODE);
1097: fnd_message.set_token('P_SQLERRM',SQLERRM);
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;

Line 1096: fnd_message.set_token('P_SQLCODE',SQLCODE);

1092: );
1093:
1094: WHEN OTHERS THEN
1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1096: fnd_message.set_token('P_SQLCODE',SQLCODE);
1097: fnd_message.set_token('P_SQLERRM',SQLERRM);
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;
1100:

Line 1097: fnd_message.set_token('P_SQLERRM',SQLERRM);

1093:
1094: WHEN OTHERS THEN
1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1096: fnd_message.set_token('P_SQLCODE',SQLCODE);
1097: fnd_message.set_token('P_SQLERRM',SQLERRM);
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;
1100:
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1098: fnd_message.set_token('P_API_NAME',l_api_name);

1094: WHEN OTHERS THEN
1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1096: fnd_message.set_token('P_SQLCODE',SQLCODE);
1097: fnd_message.set_token('P_SQLERRM',SQLERRM);
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;
1100:
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 1308: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');

1304: l_api_name := l_api_name_1;
1305:
1306: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1307: -- Unexpected Execution Error from call to Calendar
1308: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1309: fnd_msg_pub.add;
1310: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1311: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1312: -- Removed Comment to Show error message Bug # 2919389

Line 1478: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');

1474: l_api_name := l_api_name_1;
1475:
1476: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1477: -- Unexpected Execution Error from call to Calendar
1478: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1479: fnd_msg_pub.add;
1480: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1481: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1482: -- Removed Comment to Show error message Bug # 2919389

Line 1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

1600: p_data => x_msg_data
1601: );
1602:
1603: WHEN OTHERS THEN
1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;

Line 1605: fnd_message.set_token('P_SQLCODE',SQLCODE);

1601: );
1602:
1603: WHEN OTHERS THEN
1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;
1609:

Line 1606: fnd_message.set_token('P_SQLERRM',SQLERRM);

1602:
1603: WHEN OTHERS THEN
1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1607: fnd_message.set_token('P_API_NAME',l_api_name);

1603: WHEN OTHERS THEN
1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 1726: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');

1722: l_business_process_date := sysdate;
1723: END IF;
1724:
1725: IF (l_cur_contracts_installed.application_id IS NULL) THEN
1726: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1727: fnd_msg_pub.add;
1728: RAISE fnd_api.g_exc_error;
1729: ELSE
1730:

Line 1739: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');

1735: l_status,
1736: l_industry
1737: ) THEN
1738: IF ( UPPER(l_status) <> 'I' ) THEN
1739: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1740: fnd_msg_pub.add;
1741: RAISE fnd_api.g_exc_error;
1742: END IF;
1743: ELSE

Line 1744: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');

1740: fnd_msg_pub.add;
1741: RAISE fnd_api.g_exc_error;
1742: END IF;
1743: ELSE
1744: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1745: fnd_msg_pub.add;
1746: RAISE fnd_api.g_exc_error;
1747: END IF;
1748: END IF;

Line 1801: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_CONTRACTS_API'||''''||');'||

1797:
1798:
1799: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1800: -- Unexpected Execution Error from call to Contracts API
1801: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_CONTRACTS_API'||''''||');'||
1802: 'fnd_msg_pub.add;
1803: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1804: RAISE fnd_api.g_exc_error;
1805: ELSE

Line 2008: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

2004: l_api_name := l_api_name_1;
2005:
2006: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2007: -- Unexpected Execution Error from call to Get_contracts_resources
2008: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2009: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2010: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2011: fnd_msg_pub.add;
2012: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 2009: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

2005:
2006: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2007: -- Unexpected Execution Error from call to Get_contracts_resources
2008: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2009: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2010: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2011: fnd_msg_pub.add;
2012: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2013: RAISE fnd_api.g_exc_error;

Line 2010: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');

2006: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2007: -- Unexpected Execution Error from call to Get_contracts_resources
2008: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2009: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2010: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2011: fnd_msg_pub.add;
2012: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2013: RAISE fnd_api.g_exc_error;
2014: ELSE

Line 2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

2036: p_data => x_msg_data
2037: );
2038:
2039: WHEN OTHERS THEN
2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2041: fnd_message.set_token('P_SQLCODE',SQLCODE);
2042: fnd_message.set_token('P_SQLERRM',SQLERRM);
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;

Line 2041: fnd_message.set_token('P_SQLCODE',SQLCODE);

2037: );
2038:
2039: WHEN OTHERS THEN
2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2041: fnd_message.set_token('P_SQLCODE',SQLCODE);
2042: fnd_message.set_token('P_SQLERRM',SQLERRM);
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;
2045:

Line 2042: fnd_message.set_token('P_SQLERRM',SQLERRM);

2038:
2039: WHEN OTHERS THEN
2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2041: fnd_message.set_token('P_SQLCODE',SQLCODE);
2042: fnd_message.set_token('P_SQLERRM',SQLERRM);
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;
2045:
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2043: fnd_message.set_token('P_API_NAME',l_api_name);

2039: WHEN OTHERS THEN
2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2041: fnd_message.set_token('P_SQLCODE',SQLCODE);
2042: fnd_message.set_token('P_SQLERRM',SQLERRM);
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;
2045:
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 2450: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

2446: l_api_name := l_api_name_1;
2447:
2448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2449: -- Unexpected Execution Error from call to Get_contracts_resources
2450: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2451: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2452: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2453: fnd_msg_pub.add;
2454: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 2451: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

2447:
2448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2449: -- Unexpected Execution Error from call to Get_contracts_resources
2450: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2451: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2452: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2453: fnd_msg_pub.add;
2454: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2455: RAISE fnd_api.g_exc_error;

Line 2452: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');

2448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2449: -- Unexpected Execution Error from call to Get_contracts_resources
2450: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2451: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2452: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2453: fnd_msg_pub.add;
2454: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2455: RAISE fnd_api.g_exc_error;
2456: ELSE

Line 2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

2478: p_data => x_msg_data
2479: );
2480:
2481: WHEN OTHERS THEN
2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2483: fnd_message.set_token('P_SQLCODE',SQLCODE);
2484: fnd_message.set_token('P_SQLERRM',SQLERRM);
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;

Line 2483: fnd_message.set_token('P_SQLCODE',SQLCODE);

2479: );
2480:
2481: WHEN OTHERS THEN
2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2483: fnd_message.set_token('P_SQLCODE',SQLCODE);
2484: fnd_message.set_token('P_SQLERRM',SQLERRM);
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;
2487:

Line 2484: fnd_message.set_token('P_SQLERRM',SQLERRM);

2480:
2481: WHEN OTHERS THEN
2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2483: fnd_message.set_token('P_SQLCODE',SQLCODE);
2484: fnd_message.set_token('P_SQLERRM',SQLERRM);
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;
2487:
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2485: fnd_message.set_token('P_API_NAME',l_api_name);

2481: WHEN OTHERS THEN
2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2483: fnd_message.set_token('P_SQLCODE',SQLCODE);
2484: fnd_message.set_token('P_SQLERRM',SQLERRM);
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;
2487:
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 2785: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');

2781: THEN
2782: OPEN cur_task_id;
2783: FETCH cur_task_id INTO l_cur_task_id;
2784: IF ( cur_task_id%NOTFOUND ) THEN
2785: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
2786: fnd_msg_pub.add;
2787: RAISE fnd_api.g_exc_error;
2788: ELSE
2789: l_task_source_code := l_cur_task_id.source_object_type_code;

Line 2823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');

2819: l_cp_id,
2820: l_planned_end_date;
2821:
2822: IF ( cur_cs_incidents%NOTFOUND ) THEN
2823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
2824: fnd_msg_pub.add;
2825: RAISE fnd_api.g_exc_error;
2826: ELSE
2827: l_contract_flag := 'Y';

Line 2889: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

2885: );
2886:
2887: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2888: -- Unexpected Execution Error from call to Get_contracts_resources
2889: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2890: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2891: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2892: fnd_msg_pub.add;
2893: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 2890: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');

2886:
2887: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2888: -- Unexpected Execution Error from call to Get_contracts_resources
2889: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2890: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2891: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2892: fnd_msg_pub.add;
2893: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2894: RAISE fnd_api.g_exc_error;

Line 2891: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

2887: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2888: -- Unexpected Execution Error from call to Get_contracts_resources
2889: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2890: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2891: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2892: fnd_msg_pub.add;
2893: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2894: RAISE fnd_api.g_exc_error;
2895: ELSE

Line 2931: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

2927: );
2928:
2929: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2930: -- Unexpected Execution Error from call to Get_contracts_resources
2931: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2932: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2933: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2934: fnd_msg_pub.add;
2935: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 2932: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');

2928:
2929: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2930: -- Unexpected Execution Error from call to Get_contracts_resources
2931: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2932: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2933: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2934: fnd_msg_pub.add;
2935: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2936: RAISE fnd_api.g_exc_error;

Line 2933: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

2929: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2930: -- Unexpected Execution Error from call to Get_contracts_resources
2931: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2932: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2933: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2934: fnd_msg_pub.add;
2935: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2936: RAISE fnd_api.g_exc_error;
2937: ELSE

Line 2992: fnd_message.set_name('JTF', 'JTF_AM_TASK_CREATED_BY_SR');

2988:
2989: -- If there are NO preferred engineers then call territory API
2990:
2991: IF (l_task_source_code = 'SR') THEN
2992: fnd_message.set_name('JTF', 'JTF_AM_TASK_CREATED_BY_SR');
2993: fnd_msg_pub.add;
2994: RAISE fnd_api.g_exc_error;
2995:
2996: /* Query the View which is a combination of Task and Service Request

Line 3048: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

3044: l_api_name := l_api_name_1;
3045:
3046: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3047: -- Unexpected Execution Error from call to Territory Manager
3048: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3049: fnd_msg_pub.add;
3050: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3051: RAISE fnd_api.g_exc_error;
3052: ELSE

Line 3151: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

3147: l_api_name := l_api_name_1;
3148:
3149: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3150: -- Unexpected Execution Error from call to Get_contracts_resources
3151: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3152: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3153: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3154: fnd_msg_pub.add;
3155: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3152: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

3148:
3149: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3150: -- Unexpected Execution Error from call to Get_contracts_resources
3151: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3152: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3153: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3154: fnd_msg_pub.add;
3155: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3156: RAISE fnd_api.g_exc_error;

Line 3153: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

3149: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3150: -- Unexpected Execution Error from call to Get_contracts_resources
3151: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3152: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3153: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3154: fnd_msg_pub.add;
3155: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3156: RAISE fnd_api.g_exc_error;
3157: ELSE

Line 3165: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

3161: -- end if; -- if p_calendar_flag = Y
3162:
3163: IF ( p_calendar_flag = 'Y' AND
3164: x_assign_resources_tbl.count = 0 ) THEN
3165: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3166: fnd_msg_pub.add;
3167: -- RAISE fnd_api.g_exc_error;
3168: END IF;
3169:

Line 3178: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

3174: x_exc_res => l_excluded_resource_tbl);
3175: END IF;
3176:
3177: ELSE -- No resources returned from the Territory API
3178: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3179: fnd_msg_pub.add;
3180: -- RAISE fnd_api.g_exc_error;
3181: END IF;
3182:

Line 3184: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

3180: -- RAISE fnd_api.g_exc_error;
3181: END IF;
3182:
3183: ELSE -- Territory Flag is NO
3184: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3185: fnd_msg_pub.add;
3186: -- RAISE fnd_api.g_exc_error;
3187: END IF;
3188:

Line 3264: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

3260: l_api_name := l_api_name_1;
3261:
3262: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3263: -- Unexpected Execution Error from call to Territory Manager for TASKS
3264: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3265: fnd_msg_pub.add;
3266: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3267: RAISE fnd_api.g_exc_error;
3268: ELSE

Line 3368: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

3364: l_api_name := l_api_name_1;
3365:
3366: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3367: -- Unexpected Execution Error from call to Get_contracts_resources
3368: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3369: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3370: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3371: fnd_msg_pub.add;
3372: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3369: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

3365:
3366: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3367: -- Unexpected Execution Error from call to Get_contracts_resources
3368: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3369: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3370: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3371: fnd_msg_pub.add;
3372: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3373: RAISE fnd_api.g_exc_error;

Line 3370: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

3366: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3367: -- Unexpected Execution Error from call to Get_contracts_resources
3368: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3369: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3370: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3371: fnd_msg_pub.add;
3372: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3373: RAISE fnd_api.g_exc_error;
3374: ELSE

Line 3382: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

3378: -- end if; -- if p_calendar_flag = Y
3379:
3380: IF ( p_calendar_flag = 'Y' AND
3381: x_assign_resources_tbl.count = 0 ) THEN
3382: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3383: fnd_msg_pub.add;
3384: -- RAISE fnd_api.g_exc_error;
3385: END IF;
3386:

Line 3388: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

3384: -- RAISE fnd_api.g_exc_error;
3385: END IF;
3386:
3387: ELSE -- No resources returned from the Territory API
3388: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3389: fnd_msg_pub.add;
3390: -- RAISE fnd_api.g_exc_error;
3391: END IF;
3392:

Line 3400: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

3396: -- removed code which fetches Resources even if Calendar Flag is checked.
3397: -- This was done as we don't want to fetch all resources blindly any time.
3398: -- Fix for Bug 3308883.
3399:
3400: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3401: fnd_msg_pub.add;
3402: END IF; -- End of Territory_Flag = 'Y'
3403:
3404: END IF; -- End of l_task_source_code = 'SR'

Line 3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

3521: p_data => x_msg_data
3522: );
3523:
3524: WHEN OTHERS THEN
3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3526: fnd_message.set_token('P_SQLCODE',SQLCODE);
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;

Line 3526: fnd_message.set_token('P_SQLCODE',SQLCODE);

3522: );
3523:
3524: WHEN OTHERS THEN
3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3526: fnd_message.set_token('P_SQLCODE',SQLCODE);
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3527: fnd_message.set_token('P_SQLERRM',SQLERRM);

3523:
3524: WHEN OTHERS THEN
3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3526: fnd_message.set_token('P_SQLCODE',SQLCODE);
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 3528: fnd_message.set_token('P_API_NAME',l_api_name);

3524: WHEN OTHERS THEN
3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3526: fnd_message.set_token('P_SQLCODE',SQLCODE);
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
3532: FND_MSG_PUB.Add_Exc_Msg

Line 3902: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');

3898: l_expected_end_date; -- Added by SBARAT on 10/12/2004 for Bug 4052202
3899: --l_planned_end_date; -- Commented by SBARAT on 10/12/2004 for Bug 4052202
3900:
3901: IF ( cur_cs_incidents%NOTFOUND ) THEN
3902: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
3903: fnd_msg_pub.add;
3904: RAISE fnd_api.g_exc_error;
3905: /*
3906: ELSE

Line 3961: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

3957: );
3958:
3959: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3960: -- Unexpected Execution Error from call to Get_contracts_resources
3961: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3962: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
3963: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
3964: fnd_msg_pub.add;
3965: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3962: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');

3958:
3959: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3960: -- Unexpected Execution Error from call to Get_contracts_resources
3961: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3962: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
3963: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
3964: fnd_msg_pub.add;
3965: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3966: RAISE fnd_api.g_exc_error;

Line 3963: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

3959: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3960: -- Unexpected Execution Error from call to Get_contracts_resources
3961: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3962: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
3963: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
3964: fnd_msg_pub.add;
3965: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3966: RAISE fnd_api.g_exc_error;
3967: ELSE

Line 3998: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

3994: );
3995:
3996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3997: -- Unexpected Execution Error from call to Get_contracts_resources
3998: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3999: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
4000: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4001: fnd_msg_pub.add;
4002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3999: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');

3995:
3996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3997: -- Unexpected Execution Error from call to Get_contracts_resources
3998: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3999: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
4000: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4001: fnd_msg_pub.add;
4002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4003: RAISE fnd_api.g_exc_error;

Line 4000: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

3996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3997: -- Unexpected Execution Error from call to Get_contracts_resources
3998: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3999: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
4000: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4001: fnd_msg_pub.add;
4002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4003: RAISE fnd_api.g_exc_error;
4004: ELSE

Line 4040: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

4036: x_msg_data =>x_msg_data);
4037:
4038: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4039: -- Unexpected Execution Error from call to Get_contracts_resources
4040: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4041: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4042: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4043: fnd_msg_pub.add;
4044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 4041: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

4037:
4038: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4039: -- Unexpected Execution Error from call to Get_contracts_resources
4040: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4041: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4042: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4043: fnd_msg_pub.add;
4044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4045: RAISE fnd_api.g_exc_error;

Line 4042: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

4038: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4039: -- Unexpected Execution Error from call to Get_contracts_resources
4040: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4041: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4042: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4043: fnd_msg_pub.add;
4044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4045: RAISE fnd_api.g_exc_error;
4046: ELSE

Line 4065: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

4061: x_msg_data =>x_msg_data);
4062:
4063: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4064: -- Unexpected Execution Error from call to Get_contracts_resources
4065: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4066: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4067: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4068: fnd_msg_pub.add;
4069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 4066: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

4062:
4063: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4064: -- Unexpected Execution Error from call to Get_contracts_resources
4065: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4066: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4067: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4068: fnd_msg_pub.add;
4069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4070: RAISE fnd_api.g_exc_error;

Line 4067: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

4063: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4064: -- Unexpected Execution Error from call to Get_contracts_resources
4065: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4066: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4067: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4068: fnd_msg_pub.add;
4069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4070: RAISE fnd_api.g_exc_error;
4071: ELSE

Line 4247: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

4243: l_api_name := l_api_name_1;
4244:
4245: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4246: -- Unexpected Execution Error from call to Territory Manager
4247: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4248: fnd_msg_pub.add;
4249: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4250: RAISE fnd_api.g_exc_error;
4251: ELSE

Line 4277: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

4273: -- removed code which fetches Resources even if Calendar Flag is checked.
4274: -- This was done as we don't want to fetch all resources blindly any time.
4275: -- Fix for Bug 3308883.
4276:
4277: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4278: fnd_msg_pub.add;
4279: END IF; -- End of p_territory_flag = 'Y'
4280:
4281: ELSIF

Line 4373: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

4369: -- dbms_output.put_line('Count of TM :: '||l_assign_resources_tbl.count);
4370:
4371: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4372: -- Unexpected Execution Error from call to Territory Manager
4373: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4374: fnd_msg_pub.add;
4375: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4376: RAISE fnd_api.g_exc_error;
4377: ELSE

Line 4404: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

4400: -- removed code which fetches Resources even if Calendar Flag is checked.
4401: -- This was done as we don't want to fetch all resources blindly any time.
4402: -- Fix for Bug 3308883.
4403:
4404: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4405: fnd_msg_pub.add;
4406: END IF; -- End of p_territory_flag = 'Y'
4407:
4408: END IF; -- End of p_sr_rec IS NOT NULL or p_sr_task_rec IS NOT NULL

Line 4489: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

4485: l_api_name := l_api_name_1;
4486:
4487: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4488: -- Unexpected Execution Error from call to Get_contracts_resources
4489: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4490: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4491: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4492: fnd_msg_pub.add;
4493: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 4490: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

4486:
4487: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4488: -- Unexpected Execution Error from call to Get_contracts_resources
4489: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4490: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4491: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4492: fnd_msg_pub.add;
4493: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4494: RAISE fnd_api.g_exc_error;

Line 4491: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

4487: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4488: -- Unexpected Execution Error from call to Get_contracts_resources
4489: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4490: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4491: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4492: fnd_msg_pub.add;
4493: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4494: RAISE fnd_api.g_exc_error;
4495: ELSE

Line 4504: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

4500:
4501:
4502: IF ( p_calendar_flag = 'Y' AND
4503: x_assign_resources_tbl.count = 0 ) THEN
4504: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
4505: fnd_msg_pub.add;
4506: -- RAISE fnd_api.g_exc_error;
4507: END IF;
4508:

Line 4531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

4527: x_msg_data =>x_msg_data);
4528:
4529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4530: -- Unexpected Execution Error from call to Get_contracts_resources
4531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4532: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4534: fnd_msg_pub.add;
4535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 4532: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

4528:
4529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4530: -- Unexpected Execution Error from call to Get_contracts_resources
4531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4532: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4534: fnd_msg_pub.add;
4535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4536: RAISE fnd_api.g_exc_error;

Line 4533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

4529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4530: -- Unexpected Execution Error from call to Get_contracts_resources
4531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4532: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4534: fnd_msg_pub.add;
4535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4536: RAISE fnd_api.g_exc_error;
4537: ELSE

Line 4544: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

4540: END IF;
4541: END IF; -- end of security check
4542: ELSE -- No resources returned from the Territory API
4543:
4544: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4545: fnd_msg_pub.add;
4546: -- RAISE fnd_api.g_exc_error;
4547: END IF;
4548:

Line 4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

4903: p_data => x_msg_data
4904: );
4905:
4906: WHEN OTHERS THEN
4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4908: fnd_message.set_token('P_SQLCODE',SQLCODE);
4909: fnd_message.set_token('P_SQLERRM',SQLERRM);
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;

Line 4908: fnd_message.set_token('P_SQLCODE',SQLCODE);

4904: );
4905:
4906: WHEN OTHERS THEN
4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4908: fnd_message.set_token('P_SQLCODE',SQLCODE);
4909: fnd_message.set_token('P_SQLERRM',SQLERRM);
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;
4912:

Line 4909: fnd_message.set_token('P_SQLERRM',SQLERRM);

4905:
4906: WHEN OTHERS THEN
4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4908: fnd_message.set_token('P_SQLCODE',SQLCODE);
4909: fnd_message.set_token('P_SQLERRM',SQLERRM);
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;
4912:
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4910: fnd_message.set_token('P_API_NAME',l_api_name);

4906: WHEN OTHERS THEN
4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4908: fnd_message.set_token('P_SQLCODE',SQLCODE);
4909: fnd_message.set_token('P_SQLERRM',SQLERRM);
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;
4912:
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 5254: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');

5250: IF (p_resource_type IS NOT NULL) THEN
5251: OPEN cur_resource_type;
5252: FETCH cur_resource_type INTO l_cur_resource_type;
5253: IF ( cur_resource_type%NOTFOUND) THEN
5254: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
5255: fnd_msg_pub.add;
5256: RAISE fnd_api.g_exc_error;
5257: END IF;
5258: CLOSE cur_resource_type;

Line 5474: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DR_ID');

5470: l_expected_end_date; --Added by SBARAT on 10/12/2004 for bug 4052202
5471: --l_planned_end_date; --Commented out by SBARAT on 10/12/2004 for bug 4052202
5472:
5473: IF ( cur_cs_incidents%NOTFOUND ) THEN
5474: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DR_ID');
5475: fnd_msg_pub.add;
5476: RAISE fnd_api.g_exc_error;
5477: END IF;
5478:

Line 5531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5527: );
5528:
5529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5530: -- Unexpected Execution Error from call to Get_contracts_resources
5531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5532: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5534: fnd_msg_pub.add;
5535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5532: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');

5528:
5529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5530: -- Unexpected Execution Error from call to Get_contracts_resources
5531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5532: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5534: fnd_msg_pub.add;
5535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5536: RAISE fnd_api.g_exc_error;

Line 5533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5529: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5530: -- Unexpected Execution Error from call to Get_contracts_resources
5531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5532: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5534: fnd_msg_pub.add;
5535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5536: RAISE fnd_api.g_exc_error;
5537: ELSE

Line 5568: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5564: );
5565:
5566: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5567: -- Unexpected Execution Error from call to Get_contracts_resources
5568: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5569: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
5570: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5571: fnd_msg_pub.add;
5572: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5569: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');

5565:
5566: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5567: -- Unexpected Execution Error from call to Get_contracts_resources
5568: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5569: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
5570: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5571: fnd_msg_pub.add;
5572: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5573: RAISE fnd_api.g_exc_error;

Line 5570: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5566: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5567: -- Unexpected Execution Error from call to Get_contracts_resources
5568: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5569: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
5570: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5571: fnd_msg_pub.add;
5572: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5573: RAISE fnd_api.g_exc_error;
5574: ELSE

Line 5610: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5606: x_msg_data =>x_msg_data);
5607:
5608: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5609: -- Unexpected Execution Error from call to Get_contracts_resources
5610: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5611: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5612: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5613: fnd_msg_pub.add;
5614: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5611: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

5607:
5608: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5609: -- Unexpected Execution Error from call to Get_contracts_resources
5610: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5611: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5612: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5613: fnd_msg_pub.add;
5614: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5615: RAISE fnd_api.g_exc_error;

Line 5612: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5608: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5609: -- Unexpected Execution Error from call to Get_contracts_resources
5610: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5611: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5612: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5613: fnd_msg_pub.add;
5614: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5615: RAISE fnd_api.g_exc_error;
5616: ELSE

Line 5635: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5631: x_msg_data =>x_msg_data);
5632:
5633: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5634: -- Unexpected Execution Error from call to Get_contracts_resources
5635: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5636: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5637: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5638: fnd_msg_pub.add;
5639: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5636: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

5632:
5633: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5634: -- Unexpected Execution Error from call to Get_contracts_resources
5635: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5636: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5637: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5638: fnd_msg_pub.add;
5639: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5640: RAISE fnd_api.g_exc_error;

Line 5637: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5633: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5634: -- Unexpected Execution Error from call to Get_contracts_resources
5635: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5636: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5637: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5638: fnd_msg_pub.add;
5639: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5640: RAISE fnd_api.g_exc_error;
5641: ELSE

Line 5740: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

5736: l_api_name := l_api_name_1;
5737:
5738: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5739: -- Unexpected Execution Error from call to Territory Manager
5740: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
5741: fnd_msg_pub.add;
5742: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5743: RAISE fnd_api.g_exc_error;
5744: ELSE

Line 5764: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

5760: END IF;
5761:
5762: ELSE -- Territory Flag is NO
5763:
5764: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5765: fnd_msg_pub.add;
5766:
5767: END IF; -- End of p_territory_flag = 'Y'
5768:

Line 5834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5830: l_api_name := l_api_name_1;
5831:
5832: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5833: -- Unexpected Execution Error from call to Get_contracts_resources
5834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5835: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5837: fnd_msg_pub.add;
5838: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5835: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

5831:
5832: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5833: -- Unexpected Execution Error from call to Get_contracts_resources
5834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5835: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5837: fnd_msg_pub.add;
5838: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5839: RAISE fnd_api.g_exc_error;

Line 5836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5832: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5833: -- Unexpected Execution Error from call to Get_contracts_resources
5834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5835: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5837: fnd_msg_pub.add;
5838: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5839: RAISE fnd_api.g_exc_error;
5840: ELSE

Line 5847: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

5843: END IF; -- end of x_return_status check
5844:
5845: IF ( p_calendar_flag = 'Y' AND
5846: l_assign_resources_tbl.count = 0 ) THEN
5847: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
5848: fnd_msg_pub.add;
5849: END IF;
5850:
5851:

Line 5872: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

5868: x_msg_data =>x_msg_data);
5869:
5870: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5871: -- Unexpected Execution Error from call to Get_contracts_resources
5872: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5873: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5874: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5875: fnd_msg_pub.add;
5876: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5873: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');

5869:
5870: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5871: -- Unexpected Execution Error from call to Get_contracts_resources
5872: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5873: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5874: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5875: fnd_msg_pub.add;
5876: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5877: RAISE fnd_api.g_exc_error;

Line 5874: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

5870: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5871: -- Unexpected Execution Error from call to Get_contracts_resources
5872: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5873: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5874: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5875: fnd_msg_pub.add;
5876: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5877: RAISE fnd_api.g_exc_error;
5878: ELSE

Line 5885: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

5881: END IF;
5882: END IF; -- end of security check
5883: ELSE -- No resources returned from the Territory API
5884:
5885: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5886: fnd_msg_pub.add;
5887: END IF;
5888:
5889:

Line 6268: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

6264: END IF; -- Auto Select Flag
6265:
6266: ELSE
6267: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
6268: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6269: fnd_msg_pub.add;
6270: END IF;
6271:
6272:

Line 6299: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

6295:
6296:
6297: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6298: -- Unexpected Execution Error from call to assign_dr_resource
6299: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6300: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6301: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6302: fnd_msg_pub.add;
6303:

Line 6300: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

6296:
6297: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6298: -- Unexpected Execution Error from call to assign_dr_resource
6299: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6300: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6301: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6302: fnd_msg_pub.add;
6303:
6304: ELSE

Line 6301: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

6297: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6298: -- Unexpected Execution Error from call to assign_dr_resource
6299: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6300: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6301: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6302: fnd_msg_pub.add;
6303:
6304: ELSE
6305: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

Line 6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

6307:
6308:
6309: Exception
6310: When Others Then
6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6312: fnd_message.set_token('P_SQLCODE',SQLCODE);
6313: fnd_message.set_token('P_SQLERRM',SQLERRM);
6314: fnd_message.set_token('P_API_NAME',l_api_name);
6315: FND_MSG_PUB.add;

Line 6312: fnd_message.set_token('P_SQLCODE',SQLCODE);

6308:
6309: Exception
6310: When Others Then
6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6312: fnd_message.set_token('P_SQLCODE',SQLCODE);
6313: fnd_message.set_token('P_SQLERRM',SQLERRM);
6314: fnd_message.set_token('P_API_NAME',l_api_name);
6315: FND_MSG_PUB.add;
6316: End;

Line 6313: fnd_message.set_token('P_SQLERRM',SQLERRM);

6309: Exception
6310: When Others Then
6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6312: fnd_message.set_token('P_SQLCODE',SQLCODE);
6313: fnd_message.set_token('P_SQLERRM',SQLERRM);
6314: fnd_message.set_token('P_API_NAME',l_api_name);
6315: FND_MSG_PUB.add;
6316: End;
6317:

Line 6314: fnd_message.set_token('P_API_NAME',l_api_name);

6310: When Others Then
6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6312: fnd_message.set_token('P_SQLCODE',SQLCODE);
6313: fnd_message.set_token('P_SQLERRM',SQLERRM);
6314: fnd_message.set_token('P_API_NAME',l_api_name);
6315: FND_MSG_PUB.add;
6316: End;
6317:
6318:

Line 6348: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

6344:
6345:
6346: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6347: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6348: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6349: fnd_msg_pub.add;
6350: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6351: RAISE fnd_api.g_exc_error;
6352: ELSE

Line 6378: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

6374:
6375:
6376: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
6377: -- Execution Error from call to Assignment Manager Workflow Hook
6378: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6379: fnd_msg_pub.add;
6380: RAISE fnd_api.g_exc_error;
6381: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6382: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 6383: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

6379: fnd_msg_pub.add;
6380: RAISE fnd_api.g_exc_error;
6381: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6382: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6383: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6384: fnd_msg_pub.add;
6385: RAISE fnd_api.g_exc_unexpected_error;
6386: END IF;
6387:

Line 6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

6419: p_data => x_msg_data
6420: );
6421:
6422: WHEN OTHERS THEN
6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6424: fnd_message.set_token('P_SQLCODE',SQLCODE);
6425: fnd_message.set_token('P_SQLERRM',SQLERRM);
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;

Line 6424: fnd_message.set_token('P_SQLCODE',SQLCODE);

6420: );
6421:
6422: WHEN OTHERS THEN
6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6424: fnd_message.set_token('P_SQLCODE',SQLCODE);
6425: fnd_message.set_token('P_SQLERRM',SQLERRM);
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;
6428:

Line 6425: fnd_message.set_token('P_SQLERRM',SQLERRM);

6421:
6422: WHEN OTHERS THEN
6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6424: fnd_message.set_token('P_SQLCODE',SQLCODE);
6425: fnd_message.set_token('P_SQLERRM',SQLERRM);
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;
6428:
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6426: fnd_message.set_token('P_API_NAME',l_api_name);

6422: WHEN OTHERS THEN
6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6424: fnd_message.set_token('P_SQLCODE',SQLCODE);
6425: fnd_message.set_token('P_SQLERRM',SQLERRM);
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;
6428:
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6430: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 6682: fnd_message.set_name('JTF', 'JTF_AM_INVALID_OPPR_ID');

6678:
6679: OPEN cur_oppr FOR l_dynamic_sql USING p_opportunity_id;
6680: FETCH cur_oppr INTO l_assign_resources_rec;
6681: IF (cur_oppr%NOTFOUND) THEN
6682: fnd_message.set_name('JTF', 'JTF_AM_INVALID_OPPR_ID');
6683: fnd_msg_pub.add;
6684: RAISE fnd_api.g_exc_error;
6685: END IF;
6686: CLOSE cur_oppr;

Line 6803: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

6799:
6800:
6801: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6802: -- Unexpected Execution Error from call to Territory Manager
6803: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
6804: fnd_msg_pub.add;
6805: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6806: RAISE fnd_api.g_exc_error;
6807: ELSE

Line 6910: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

6906: l_api_name := l_api_name_1;
6907:
6908: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6909: -- Unexpected Execution Error from call to Get_contracts_resources
6910: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6911: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6912: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6913: fnd_msg_pub.add;
6914: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 6911: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

6907:
6908: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6909: -- Unexpected Execution Error from call to Get_contracts_resources
6910: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6911: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6912: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6913: fnd_msg_pub.add;
6914: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6915: RAISE fnd_api.g_exc_error;

Line 6912: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');

6908: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6909: -- Unexpected Execution Error from call to Get_contracts_resources
6910: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6911: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6912: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6913: fnd_msg_pub.add;
6914: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6915: RAISE fnd_api.g_exc_error;
6916: ELSE

Line 6924: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

6920: end if; -- if p_calendar_flag = Y
6921:
6922: IF ( p_calendar_flag = 'Y' AND
6923: x_assign_resources_tbl.count = 0 ) THEN
6924: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
6925: fnd_msg_pub.add;
6926: -- RAISE fnd_api.g_exc_error;
6927: END IF;
6928:

Line 6953: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

6949:
6950: END IF; -- end of auto select flag
6951:
6952: ELSE -- No resources returned from the Territory API
6953: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6954: fnd_msg_pub.add;
6955: -- RAISE fnd_api.g_exc_error;
6956: END IF;
6957:

Line 6959: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

6955: -- RAISE fnd_api.g_exc_error;
6956: END IF;
6957:
6958: ELSE -- Territory Flag is NO
6959: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6960: fnd_msg_pub.add;
6961: -- RAISE fnd_api.g_exc_error;
6962: END IF;
6963:

Line 6986: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

6982:
6983:
6984: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6985: -- Unexpected Execution Error from call to assign_sr_resource
6986: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6987: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6988: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6989: fnd_msg_pub.add;
6990:

Line 6987: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

6983:
6984: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6985: -- Unexpected Execution Error from call to assign_sr_resource
6986: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6987: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6988: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6989: fnd_msg_pub.add;
6990:
6991: ELSE

Line 6988: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');

6984: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6985: -- Unexpected Execution Error from call to assign_sr_resource
6986: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6987: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6988: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6989: fnd_msg_pub.add;
6990:
6991: ELSE
6992: x_assign_resources_tbl.delete;

Line 6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

6995:
6996:
6997: Exception
6998: When OTHERS Then
6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7000: fnd_message.set_token('P_SQLCODE',SQLCODE);
7001: fnd_message.set_token('P_SQLERRM',SQLERRM);
7002: fnd_message.set_token('P_API_NAME',l_api_name);
7003: FND_MSG_PUB.add;

Line 7000: fnd_message.set_token('P_SQLCODE',SQLCODE);

6996:
6997: Exception
6998: When OTHERS Then
6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7000: fnd_message.set_token('P_SQLCODE',SQLCODE);
7001: fnd_message.set_token('P_SQLERRM',SQLERRM);
7002: fnd_message.set_token('P_API_NAME',l_api_name);
7003: FND_MSG_PUB.add;
7004: End;

Line 7001: fnd_message.set_token('P_SQLERRM',SQLERRM);

6997: Exception
6998: When OTHERS Then
6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7000: fnd_message.set_token('P_SQLCODE',SQLCODE);
7001: fnd_message.set_token('P_SQLERRM',SQLERRM);
7002: fnd_message.set_token('P_API_NAME',l_api_name);
7003: FND_MSG_PUB.add;
7004: End;
7005:

Line 7002: fnd_message.set_token('P_API_NAME',l_api_name);

6998: When OTHERS Then
6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7000: fnd_message.set_token('P_SQLCODE',SQLCODE);
7001: fnd_message.set_token('P_SQLERRM',SQLERRM);
7002: fnd_message.set_token('P_API_NAME',l_api_name);
7003: FND_MSG_PUB.add;
7004: End;
7005:
7006: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

Line 7041: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7037: ) THEN
7038:
7039: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7040: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7041: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7042: fnd_msg_pub.add;
7043: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7044: RAISE fnd_api.g_exc_error;
7045: ELSE

Line 7069: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7065: );
7066:
7067: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7068: -- Execution Error from call to Assignment Manager Workflow Hook
7069: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7070: fnd_msg_pub.add;
7071: RAISE fnd_api.g_exc_error;
7072: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7073: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 7074: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7070: fnd_msg_pub.add;
7071: RAISE fnd_api.g_exc_error;
7072: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7073: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7074: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_unexpected_error;
7077: END IF;
7078:

Line 7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

7112: p_data => x_msg_data
7113: );
7114:
7115: WHEN OTHERS THEN
7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7117: fnd_message.set_token('P_SQLCODE',SQLCODE);
7118: fnd_message.set_token('P_SQLERRM',SQLERRM);
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;

Line 7117: fnd_message.set_token('P_SQLCODE',SQLCODE);

7113: );
7114:
7115: WHEN OTHERS THEN
7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7117: fnd_message.set_token('P_SQLCODE',SQLCODE);
7118: fnd_message.set_token('P_SQLERRM',SQLERRM);
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;
7121:

Line 7118: fnd_message.set_token('P_SQLERRM',SQLERRM);

7114:
7115: WHEN OTHERS THEN
7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7117: fnd_message.set_token('P_SQLCODE',SQLCODE);
7118: fnd_message.set_token('P_SQLERRM',SQLERRM);
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;
7121:
7122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 7119: fnd_message.set_token('P_API_NAME',l_api_name);

7115: WHEN OTHERS THEN
7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7117: fnd_message.set_token('P_SQLCODE',SQLCODE);
7118: fnd_message.set_token('P_SQLERRM',SQLERRM);
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;
7121:
7122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 7403: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

7399: l_api_name := l_api_name_1;
7400:
7401: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7402: -- Unexpected Execution Error from call to Territory Manager
7403: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7404: fnd_msg_pub.add;
7405: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7406: RAISE fnd_api.g_exc_error;
7407: ELSE

Line 7498: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

7494: l_api_name := l_api_name_1;
7495:
7496: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7497: -- Unexpected Execution Error from call to Get_contracts_resources
7498: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7499: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7500: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7501: fnd_msg_pub.add;
7502: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 7499: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

7495:
7496: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7497: -- Unexpected Execution Error from call to Get_contracts_resources
7498: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7499: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7500: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7501: fnd_msg_pub.add;
7502: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7503: RAISE fnd_api.g_exc_error;

Line 7500: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');

7496: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7497: -- Unexpected Execution Error from call to Get_contracts_resources
7498: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7499: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7500: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7501: fnd_msg_pub.add;
7502: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7503: RAISE fnd_api.g_exc_error;
7504: ELSE

Line 7512: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

7508: end if; -- if p_calendar_flag = Y
7509:
7510: IF ( p_calendar_flag = 'Y' AND
7511: x_assign_resources_tbl.count = 0 ) THEN
7512: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
7513: fnd_msg_pub.add;
7514: -- RAISE fnd_api.g_exc_error;
7515: END IF;
7516:

Line 7541: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

7537:
7538: END IF; -- end of auto select flag
7539:
7540: ELSE -- No resources returned from the Territory API
7541: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7542: fnd_msg_pub.add;
7543: -- RAISE fnd_api.g_exc_error;
7544: END IF;
7545:

Line 7547: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

7543: -- RAISE fnd_api.g_exc_error;
7544: END IF;
7545:
7546: ELSE -- Territory Flag is NO
7547: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7548: fnd_msg_pub.add;
7549: -- RAISE fnd_api.g_exc_error;
7550: END IF;
7551:

Line 7575: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

7571:
7572:
7573: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7574: -- Unexpected Execution Error from call to assign_sr_resource
7575: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7576: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7577: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7578: fnd_msg_pub.add;
7579:

Line 7576: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

7572:
7573: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7574: -- Unexpected Execution Error from call to assign_sr_resource
7575: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7576: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7577: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7578: fnd_msg_pub.add;
7579:
7580: ELSE

Line 7577: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');

7573: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7574: -- Unexpected Execution Error from call to assign_sr_resource
7575: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7576: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7577: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7578: fnd_msg_pub.add;
7579:
7580: ELSE
7581: x_assign_resources_tbl.delete;

Line 7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

7584:
7585:
7586: Exception
7587: When OTHERS Then
7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7589: fnd_message.set_token('P_SQLCODE',SQLCODE);
7590: fnd_message.set_token('P_SQLERRM',SQLERRM);
7591: fnd_message.set_token('P_API_NAME',l_api_name);
7592: FND_MSG_PUB.add;

Line 7589: fnd_message.set_token('P_SQLCODE',SQLCODE);

7585:
7586: Exception
7587: When OTHERS Then
7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7589: fnd_message.set_token('P_SQLCODE',SQLCODE);
7590: fnd_message.set_token('P_SQLERRM',SQLERRM);
7591: fnd_message.set_token('P_API_NAME',l_api_name);
7592: FND_MSG_PUB.add;
7593: End;

Line 7590: fnd_message.set_token('P_SQLERRM',SQLERRM);

7586: Exception
7587: When OTHERS Then
7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7589: fnd_message.set_token('P_SQLCODE',SQLCODE);
7590: fnd_message.set_token('P_SQLERRM',SQLERRM);
7591: fnd_message.set_token('P_API_NAME',l_api_name);
7592: FND_MSG_PUB.add;
7593: End;
7594:

Line 7591: fnd_message.set_token('P_API_NAME',l_api_name);

7587: When OTHERS Then
7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7589: fnd_message.set_token('P_SQLCODE',SQLCODE);
7590: fnd_message.set_token('P_SQLERRM',SQLERRM);
7591: fnd_message.set_token('P_API_NAME',l_api_name);
7592: FND_MSG_PUB.add;
7593: End;
7594:
7595: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

Line 7629: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7625: ) THEN
7626:
7627: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7628: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7629: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7630: fnd_msg_pub.add;
7631: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7632: RAISE fnd_api.g_exc_error;
7633: ELSE

Line 7657: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7653: );
7654:
7655: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7656: -- Execution Error from call to Assignment Manager Workflow Hook
7657: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7658: fnd_msg_pub.add;
7659: RAISE fnd_api.g_exc_error;
7660: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7661: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 7662: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

7658: fnd_msg_pub.add;
7659: RAISE fnd_api.g_exc_error;
7660: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7661: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7662: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7663: fnd_msg_pub.add;
7664: RAISE fnd_api.g_exc_unexpected_error;
7665: END IF;
7666:

Line 7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

7699: p_data => x_msg_data
7700: );
7701:
7702: WHEN OTHERS THEN
7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7704: fnd_message.set_token('P_SQLCODE',SQLCODE);
7705: fnd_message.set_token('P_SQLERRM',SQLERRM);
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;

Line 7704: fnd_message.set_token('P_SQLCODE',SQLCODE);

7700: );
7701:
7702: WHEN OTHERS THEN
7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7704: fnd_message.set_token('P_SQLCODE',SQLCODE);
7705: fnd_message.set_token('P_SQLERRM',SQLERRM);
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;
7708:

Line 7705: fnd_message.set_token('P_SQLERRM',SQLERRM);

7701:
7702: WHEN OTHERS THEN
7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7704: fnd_message.set_token('P_SQLCODE',SQLCODE);
7705: fnd_message.set_token('P_SQLERRM',SQLERRM);
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;
7708:
7709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 7706: fnd_message.set_token('P_API_NAME',l_api_name);

7702: WHEN OTHERS THEN
7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7704: fnd_message.set_token('P_SQLCODE',SQLCODE);
7705: fnd_message.set_token('P_SQLERRM',SQLERRM);
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;
7708:
7709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 7978: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

7974: l_api_name := l_api_name_1;
7975:
7976: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7977: -- Unexpected Execution Error from call to Territory Manager
7978: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7979: fnd_msg_pub.add;
7980: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7981: RAISE fnd_api.g_exc_error;
7982: ELSE

Line 8051: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');

8047: l_api_name := l_api_name_1;
8048:
8049: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8050: -- Unexpected Execution Error from call to Calendar
8051: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
8052: fnd_msg_pub.add;
8053: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8054: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
8055: -- Removed Comment to Show error message Bug # 2919389

Line 8147: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

8143:
8144:
8145: IF ( p_calendar_flag = 'Y' AND
8146: x_assign_resources_tbl.count = 0 ) THEN
8147: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8148: fnd_msg_pub.add;
8149: -- RAISE fnd_api.g_exc_error;
8150: END IF;
8151:

Line 8153: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

8149: -- RAISE fnd_api.g_exc_error;
8150: END IF;
8151:
8152: ELSE -- No resources returned from the Territory API
8153: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8154: fnd_msg_pub.add;
8155: -- RAISE fnd_api.g_exc_error;
8156: END IF;
8157:

Line 8159: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

8155: -- RAISE fnd_api.g_exc_error;
8156: END IF;
8157:
8158: ELSE -- Territory Flag is NO
8159: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8160: fnd_msg_pub.add;
8161: -- RAISE fnd_api.g_exc_error;
8162: END IF;
8163:

Line 8187: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

8183:
8184:
8185: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8186: -- Unexpected Execution Error from call to assign_sr_resource
8187: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8188: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8189: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8190: fnd_msg_pub.add;
8191:

Line 8188: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

8184:
8185: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8186: -- Unexpected Execution Error from call to assign_sr_resource
8187: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8188: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8189: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8190: fnd_msg_pub.add;
8191:
8192: ELSE

Line 8189: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');

8185: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8186: -- Unexpected Execution Error from call to assign_sr_resource
8187: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8188: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8189: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8190: fnd_msg_pub.add;
8191:
8192: ELSE
8193: x_assign_resources_tbl.delete;

Line 8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

8196:
8197:
8198: Exception
8199: When OTHERS Then
8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8201: fnd_message.set_token('P_SQLCODE',SQLCODE);
8202: fnd_message.set_token('P_SQLERRM',SQLERRM);
8203: fnd_message.set_token('P_API_NAME',l_api_name);
8204: FND_MSG_PUB.add;

Line 8201: fnd_message.set_token('P_SQLCODE',SQLCODE);

8197:
8198: Exception
8199: When OTHERS Then
8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8201: fnd_message.set_token('P_SQLCODE',SQLCODE);
8202: fnd_message.set_token('P_SQLERRM',SQLERRM);
8203: fnd_message.set_token('P_API_NAME',l_api_name);
8204: FND_MSG_PUB.add;
8205: End;

Line 8202: fnd_message.set_token('P_SQLERRM',SQLERRM);

8198: Exception
8199: When OTHERS Then
8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8201: fnd_message.set_token('P_SQLCODE',SQLCODE);
8202: fnd_message.set_token('P_SQLERRM',SQLERRM);
8203: fnd_message.set_token('P_API_NAME',l_api_name);
8204: FND_MSG_PUB.add;
8205: End;
8206:

Line 8203: fnd_message.set_token('P_API_NAME',l_api_name);

8199: When OTHERS Then
8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8201: fnd_message.set_token('P_SQLCODE',SQLCODE);
8202: fnd_message.set_token('P_SQLERRM',SQLERRM);
8203: fnd_message.set_token('P_API_NAME',l_api_name);
8204: FND_MSG_PUB.add;
8205: End;
8206:
8207: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

Line 8241: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8237: ) THEN
8238:
8239: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8240: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8241: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8242: fnd_msg_pub.add;
8243: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8244: RAISE fnd_api.g_exc_error;
8245: ELSE

Line 8270: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8266:
8267:
8268: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8269: -- Execution Error from call to Assignment Manager Workflow Hook
8270: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8271: fnd_msg_pub.add;
8272: RAISE fnd_api.g_exc_error;
8273: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8274: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 8275: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8271: fnd_msg_pub.add;
8272: RAISE fnd_api.g_exc_error;
8273: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8274: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8275: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8276: fnd_msg_pub.add;
8277: RAISE fnd_api.g_exc_unexpected_error;
8278: END IF;
8279:

Line 8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

8311: p_data => x_msg_data
8312: );
8313:
8314: WHEN OTHERS THEN
8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8316: fnd_message.set_token('P_SQLCODE',SQLCODE);
8317: fnd_message.set_token('P_SQLERRM',SQLERRM);
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;

Line 8316: fnd_message.set_token('P_SQLCODE',SQLCODE);

8312: );
8313:
8314: WHEN OTHERS THEN
8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8316: fnd_message.set_token('P_SQLCODE',SQLCODE);
8317: fnd_message.set_token('P_SQLERRM',SQLERRM);
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;
8320:

Line 8317: fnd_message.set_token('P_SQLERRM',SQLERRM);

8313:
8314: WHEN OTHERS THEN
8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8316: fnd_message.set_token('P_SQLCODE',SQLCODE);
8317: fnd_message.set_token('P_SQLERRM',SQLERRM);
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;
8320:
8321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8318: fnd_message.set_token('P_API_NAME',l_api_name);

8314: WHEN OTHERS THEN
8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8316: fnd_message.set_token('P_SQLCODE',SQLCODE);
8317: fnd_message.set_token('P_SQLERRM',SQLERRM);
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;
8320:
8321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 8647: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

8643: l_api_name := l_api_name_1;
8644:
8645: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8646: -- Unexpected Execution Error from call to Territory Manager
8647: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8648: fnd_msg_pub.add;
8649: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8650: RAISE fnd_api.g_exc_error;
8651: ELSE

Line 8760: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

8756: l_api_name := l_api_name_1;
8757:
8758: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8759: -- Unexpected Execution Error from call to Get_contracts_resources
8760: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8761: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8762: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8763: fnd_msg_pub.add;
8764: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 8761: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

8757:
8758: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8759: -- Unexpected Execution Error from call to Get_contracts_resources
8760: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8761: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8762: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8763: fnd_msg_pub.add;
8764: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8765: RAISE fnd_api.g_exc_error;

Line 8762: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');

8758: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8759: -- Unexpected Execution Error from call to Get_contracts_resources
8760: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8761: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8762: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8763: fnd_msg_pub.add;
8764: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8765: RAISE fnd_api.g_exc_error;
8766: ELSE

Line 8774: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

8770: end if; -- if p_calendar_flag = Y
8771:
8772: IF ( p_calendar_flag = 'Y' AND
8773: x_assign_resources_tbl.count = 0 ) THEN
8774: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8775: fnd_msg_pub.add;
8776: -- RAISE fnd_api.g_exc_error;
8777: END IF;
8778:

Line 8801: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

8797: END LOOP; -- end of courrent record check
8798:
8799: END IF; -- end of auto select flag
8800: ELSE -- No resources returned from the Territory API
8801: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8802: fnd_msg_pub.add;
8803: -- RAISE fnd_api.g_exc_error;
8804: END IF;
8805:

Line 8807: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

8803: -- RAISE fnd_api.g_exc_error;
8804: END IF;
8805:
8806: ELSE -- Territory Flag is NO
8807: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8808: fnd_msg_pub.add;
8809: -- RAISE fnd_api.g_exc_error;
8810: END IF;
8811:

Line 8834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

8830:
8831:
8832: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8833: -- Unexpected Execution Error from call to assign_sr_resource
8834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8835: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8837: fnd_msg_pub.add;
8838:

Line 8835: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

8831:
8832: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8833: -- Unexpected Execution Error from call to assign_sr_resource
8834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8835: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8837: fnd_msg_pub.add;
8838:
8839: ELSE

Line 8836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');

8832: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8833: -- Unexpected Execution Error from call to assign_sr_resource
8834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8835: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8837: fnd_msg_pub.add;
8838:
8839: ELSE
8840: x_assign_resources_tbl.delete;

Line 8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

8843:
8844:
8845: Exception
8846: When OTHERS Then
8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8848: fnd_message.set_token('P_SQLCODE',SQLCODE);
8849: fnd_message.set_token('P_SQLERRM',SQLERRM);
8850: fnd_message.set_token('P_API_NAME',l_api_name);
8851: FND_MSG_PUB.add;

Line 8848: fnd_message.set_token('P_SQLCODE',SQLCODE);

8844:
8845: Exception
8846: When OTHERS Then
8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8848: fnd_message.set_token('P_SQLCODE',SQLCODE);
8849: fnd_message.set_token('P_SQLERRM',SQLERRM);
8850: fnd_message.set_token('P_API_NAME',l_api_name);
8851: FND_MSG_PUB.add;
8852: End;

Line 8849: fnd_message.set_token('P_SQLERRM',SQLERRM);

8845: Exception
8846: When OTHERS Then
8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8848: fnd_message.set_token('P_SQLCODE',SQLCODE);
8849: fnd_message.set_token('P_SQLERRM',SQLERRM);
8850: fnd_message.set_token('P_API_NAME',l_api_name);
8851: FND_MSG_PUB.add;
8852: End;
8853:

Line 8850: fnd_message.set_token('P_API_NAME',l_api_name);

8846: When OTHERS Then
8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8848: fnd_message.set_token('P_SQLCODE',SQLCODE);
8849: fnd_message.set_token('P_SQLERRM',SQLERRM);
8850: fnd_message.set_token('P_API_NAME',l_api_name);
8851: FND_MSG_PUB.add;
8852: End;
8853:
8854: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

Line 8889: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8885: ) THEN
8886:
8887: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8888: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8889: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8890: fnd_msg_pub.add;
8891: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8892: RAISE fnd_api.g_exc_error;
8893: ELSE

Line 8917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8913: );
8914:
8915: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8916: -- Execution Error from call to Assignment Manager Workflow Hook
8917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8918: fnd_msg_pub.add;
8919: RAISE fnd_api.g_exc_error;
8920: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8921: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 8922: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

8918: fnd_msg_pub.add;
8919: RAISE fnd_api.g_exc_error;
8920: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8921: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8922: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8923: fnd_msg_pub.add;
8924: RAISE fnd_api.g_exc_unexpected_error;
8925: END IF;
8926:

Line 8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

8959: p_data => x_msg_data
8960: );
8961:
8962: WHEN OTHERS THEN
8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8964: fnd_message.set_token('P_SQLCODE',SQLCODE);
8965: fnd_message.set_token('P_SQLERRM',SQLERRM);
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;

Line 8964: fnd_message.set_token('P_SQLCODE',SQLCODE);

8960: );
8961:
8962: WHEN OTHERS THEN
8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8964: fnd_message.set_token('P_SQLCODE',SQLCODE);
8965: fnd_message.set_token('P_SQLERRM',SQLERRM);
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;
8968:

Line 8965: fnd_message.set_token('P_SQLERRM',SQLERRM);

8961:
8962: WHEN OTHERS THEN
8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8964: fnd_message.set_token('P_SQLCODE',SQLCODE);
8965: fnd_message.set_token('P_SQLERRM',SQLERRM);
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;
8968:
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8966: fnd_message.set_token('P_API_NAME',l_api_name);

8962: WHEN OTHERS THEN
8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8964: fnd_message.set_token('P_SQLCODE',SQLCODE);
8965: fnd_message.set_token('P_SQLERRM',SQLERRM);
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;
8968:
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8970: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 9197: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

9193: l_api_name := l_api_name_1;
9194:
9195: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9196: -- Unexpected Execution Error from call to Territory Manager
9197: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9198: fnd_msg_pub.add;
9199: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9200: RAISE fnd_api.g_exc_error;
9201: ELSE

Line 9207: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

9203: END IF;
9204: END IF;
9205:
9206: ELSE -- Territory Flag is NO
9207: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9208: fnd_msg_pub.add;
9209: -- RAISE fnd_api.g_exc_error;
9210: END IF;
9211:

Line 9311: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

9307: l_api_name := l_api_name_1;
9308:
9309: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9310: -- Unexpected Execution Error from call to Get_contracts_resources
9311: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9312: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9313: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9314: fnd_msg_pub.add;
9315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9312: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

9308:
9309: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9310: -- Unexpected Execution Error from call to Get_contracts_resources
9311: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9312: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9313: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9314: fnd_msg_pub.add;
9315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9316: RAISE fnd_api.g_exc_error;

Line 9313: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');

9309: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9310: -- Unexpected Execution Error from call to Get_contracts_resources
9311: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9312: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9313: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9314: fnd_msg_pub.add;
9315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9316: RAISE fnd_api.g_exc_error;
9317: ELSE

Line 9326: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

9322:
9323:
9324: IF ( p_calendar_flag = 'Y' AND
9325: x_assign_resources_tbl.count = 0 ) THEN
9326: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
9327: fnd_msg_pub.add;
9328: -- RAISE fnd_api.g_exc_error;
9329: END IF;
9330:

Line 9332: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

9328: -- RAISE fnd_api.g_exc_error;
9329: END IF;
9330:
9331: ELSE -- No resources returned from the Territory API
9332: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9333: fnd_msg_pub.add;
9334: -- RAISE fnd_api.g_exc_error;
9335: END IF;
9336:

Line 9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

9362: p_data => x_msg_data
9363: );
9364:
9365: WHEN OTHERS THEN
9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9367: fnd_message.set_token('P_SQLCODE',SQLCODE);
9368: fnd_message.set_token('P_SQLERRM',SQLERRM);
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;

Line 9367: fnd_message.set_token('P_SQLCODE',SQLCODE);

9363: );
9364:
9365: WHEN OTHERS THEN
9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9367: fnd_message.set_token('P_SQLCODE',SQLCODE);
9368: fnd_message.set_token('P_SQLERRM',SQLERRM);
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;
9371:

Line 9368: fnd_message.set_token('P_SQLERRM',SQLERRM);

9364:
9365: WHEN OTHERS THEN
9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9367: fnd_message.set_token('P_SQLCODE',SQLCODE);
9368: fnd_message.set_token('P_SQLERRM',SQLERRM);
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;
9371:
9372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 9369: fnd_message.set_token('P_API_NAME',l_api_name);

9365: WHEN OTHERS THEN
9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9367: fnd_message.set_token('P_SQLCODE',SQLCODE);
9368: fnd_message.set_token('P_SQLERRM',SQLERRM);
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;
9371:
9372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 9658: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');

9654: /*
9655: OPEN cur_esc_id;
9656: FETCH cur_esc_id INTO l_cur_esc_id;
9657: IF ( cur_esc_id%NOTFOUND ) THEN
9658: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9659: fnd_msg_pub.add;
9660: RAISE fnd_api.g_exc_error;
9661: ELSE
9662: l_esc_source_code := l_cur_esc_id.source_object_type_code;

Line 9673: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');

9669: CLOSE cur_esc_id;
9670:
9671:
9672: IF ( l_esc_source_code <> 'ESC' ) THEN
9673: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9674: fnd_msg_pub.add;
9675: RAISE fnd_api.g_exc_error;
9676: ELSE
9677: OPEN cur_reference_code;

Line 9680: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');

9676: ELSE
9677: OPEN cur_reference_code;
9678: FETCH cur_reference_code INTO l_cur_reference_code;
9679: IF ( cur_reference_code%NOTFOUND) THEN
9680: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9681: fnd_msg_pub.add;
9682: RAISE fnd_api.g_exc_error;
9683: ELSE
9684: l_reference_code := l_cur_reference_code.reference_code;

Line 9689: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_REF');

9685: l_object_type_code := l_cur_reference_code.object_type_code;
9686: l_object_id := l_cur_reference_code.object_id;
9687:
9688: IF ( l_reference_code <> 'ESC' ) THEN
9689: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_REF');
9690: fnd_msg_pub.add;
9691: RAISE fnd_api.g_exc_error;
9692: END IF;
9693: END IF;

Line 9778: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');

9774: OPEN cur_source_task;
9775: FETCH cur_source_task INTO l_territory_id;
9776:
9777: IF ( cur_source_task%NOTFOUND ) THEN
9778: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
9779: fnd_msg_pub.add;
9780: RAISE fnd_api.g_exc_error;
9781: END IF;
9782:

Line 9799: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');

9795: OPEN cur_source_sr FOR l_dynamic_sql USING l_object_id;
9796: FETCH cur_source_sr INTO l_territory_id;
9797:
9798: IF ( cur_source_sr%NOTFOUND ) THEN
9799: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
9800: fnd_msg_pub.add;
9801: RAISE fnd_api.g_exc_error;
9802: END IF;
9803:

Line 9823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DEFECT_ID');

9819: OPEN cur_source_defect FOR l_dynamic_sql USING l_object_id;
9820: FETCH cur_source_defect INTO l_territory_id;
9821:
9822: IF ( cur_source_defect%NOTFOUND ) THEN
9823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DEFECT_ID');
9824: fnd_msg_pub.add;
9825: RAISE fnd_api.g_exc_error;
9826: END IF;
9827:

Line 9861: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

9857:
9858:
9859: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9860: -- Unexpected Execution Error from call to Territory Manager
9861: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9862: fnd_msg_pub.add;
9863: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9864: RAISE fnd_api.g_exc_error;
9865: ELSE

Line 9895: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

9891: l_api_name := l_api_name_1;
9892:
9893: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9894: -- Unexpected Execution Error from call to Territory Manager
9895: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9896: fnd_msg_pub.add;
9897: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9898: RAISE fnd_api.g_exc_error;
9899: ELSE

Line 9905: --fnd_message.set_name('JTF', 'JTF_AM_NO_ESC_TERR');

9901: END IF;
9902: END IF;
9903:
9904: --ELSE
9905: --fnd_message.set_name('JTF', 'JTF_AM_NO_ESC_TERR');
9906: --fnd_msg_pub.add;
9907: --RAISE fnd_api.g_exc_error;
9908: END IF;
9909:

Line 9936: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

9932: l_api_name := l_api_name_1;
9933:
9934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9935: -- Unexpected Execution Error from call to Territory Manager
9936: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9937: fnd_msg_pub.add;
9938: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9939: RAISE fnd_api.g_exc_error;
9940: ELSE

Line 10050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

10046: l_api_name := l_api_name_1;
10047:
10048: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10049: -- Unexpected Execution Error from call to Get_contracts_resources
10050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10051: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10053: fnd_msg_pub.add;
10054: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 10051: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

10047:
10048: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10049: -- Unexpected Execution Error from call to Get_contracts_resources
10050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10051: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10053: fnd_msg_pub.add;
10054: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10055: RAISE fnd_api.g_exc_error;

Line 10052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');

10048: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10049: -- Unexpected Execution Error from call to Get_contracts_resources
10050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10051: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10053: fnd_msg_pub.add;
10054: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10055: RAISE fnd_api.g_exc_error;
10056: ELSE

Line 10064: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');

10060: -- end if; -- if p_calendar_flag = Y
10061:
10062: IF ( p_calendar_flag = 'Y' AND
10063: x_assign_resources_tbl.count = 0 ) THEN
10064: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
10065: fnd_msg_pub.add;
10066: -- RAISE fnd_api.g_exc_error;
10067: END IF;
10068:

Line 10092: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

10088:
10089: END IF; -- end of auto select flag
10090:
10091: ELSE -- No resources returned from the Territory API
10092: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10093: fnd_msg_pub.add;
10094: -- RAISE fnd_api.g_exc_error;
10095: END IF;
10096:

Line 10098: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

10094: -- RAISE fnd_api.g_exc_error;
10095: END IF;
10096:
10097: ELSE -- Territory Flag is NO
10098: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10099: fnd_msg_pub.add;
10100: -- RAISE fnd_api.g_exc_error;
10101: END IF;
10102:

Line 10130: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

10126: l_api_name := l_api_name_1;
10127:
10128: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10129: -- Unexpected Execution Error from call to Territory Manager
10130: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10131: fnd_msg_pub.add;
10132: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10133: RAISE fnd_api.g_exc_error;
10134: ELSE

Line 10193: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

10189:
10190: END LOOP;
10191:
10192: ELSE -- l_assign_resources_tbl.COUNT <= 0
10193: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10194: fnd_msg_pub.add;
10195: -- RAISE fnd_api.g_exc_error;
10196: END IF;
10197:

Line 10200: fnd_message.set_name('JTF', 'JTF_AM_EMPTY_ESC_TBL');

10196: END IF;
10197:
10198:
10199: /*
10200: fnd_message.set_name('JTF', 'JTF_AM_EMPTY_ESC_TBL');
10201: fnd_msg_pub.add;
10202: RAISE fnd_api.g_exc_error;
10203: */
10204:

Line 10324: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

10320:
10321:
10322: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10323: -- Unexpected Execution Error from call to assign_sr_resource
10324: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10325: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10326: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10327: fnd_msg_pub.add;
10328: ELSE

Line 10325: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

10321:
10322: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10323: -- Unexpected Execution Error from call to assign_sr_resource
10324: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10325: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10326: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10327: fnd_msg_pub.add;
10328: ELSE
10329: x_assign_resources_tbl.delete;

Line 10326: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');

10322: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10323: -- Unexpected Execution Error from call to assign_sr_resource
10324: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10325: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10326: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10327: fnd_msg_pub.add;
10328: ELSE
10329: x_assign_resources_tbl.delete;
10330: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

Line 10354: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

10350:
10351:
10352: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10353: -- Unexpected Execution Error from call to assign_sr_resource
10354: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10355: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10356: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10357: fnd_msg_pub.add;
10358: ELSE

Line 10355: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

10351:
10352: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10353: -- Unexpected Execution Error from call to assign_sr_resource
10354: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10355: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10356: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10357: fnd_msg_pub.add;
10358: ELSE
10359: x_assign_resources_tbl.delete;

Line 10356: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');

10352: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10353: -- Unexpected Execution Error from call to assign_sr_resource
10354: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10355: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10356: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10357: fnd_msg_pub.add;
10358: ELSE
10359: x_assign_resources_tbl.delete;
10360: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

Line 10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

10363: END IF;
10364:
10365: Exception
10366: When OTHERS Then
10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10368: fnd_message.set_token('P_SQLCODE',SQLCODE);
10369: fnd_message.set_token('P_SQLERRM',SQLERRM);
10370: fnd_message.set_token('P_API_NAME',l_api_name);
10371: FND_MSG_PUB.add;

Line 10368: fnd_message.set_token('P_SQLCODE',SQLCODE);

10364:
10365: Exception
10366: When OTHERS Then
10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10368: fnd_message.set_token('P_SQLCODE',SQLCODE);
10369: fnd_message.set_token('P_SQLERRM',SQLERRM);
10370: fnd_message.set_token('P_API_NAME',l_api_name);
10371: FND_MSG_PUB.add;
10372: End;

Line 10369: fnd_message.set_token('P_SQLERRM',SQLERRM);

10365: Exception
10366: When OTHERS Then
10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10368: fnd_message.set_token('P_SQLCODE',SQLCODE);
10369: fnd_message.set_token('P_SQLERRM',SQLERRM);
10370: fnd_message.set_token('P_API_NAME',l_api_name);
10371: FND_MSG_PUB.add;
10372: End;
10373:

Line 10370: fnd_message.set_token('P_API_NAME',l_api_name);

10366: When OTHERS Then
10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10368: fnd_message.set_token('P_SQLCODE',SQLCODE);
10369: fnd_message.set_token('P_SQLERRM',SQLERRM);
10370: fnd_message.set_token('P_API_NAME',l_api_name);
10371: FND_MSG_PUB.add;
10372: End;
10373:
10374: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

Line 10411: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

10407: ) THEN
10408:
10409: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10410: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10411: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10412: fnd_msg_pub.add;
10413: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10414: RAISE fnd_api.g_exc_error;
10415: ELSE

Line 10441: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

10437:
10438:
10439: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
10440: -- Execution Error from call to Assignment Manager Workflow Hook
10441: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10442: fnd_msg_pub.add;
10443: RAISE fnd_api.g_exc_error;
10444: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10445: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 10446: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

10442: fnd_msg_pub.add;
10443: RAISE fnd_api.g_exc_error;
10444: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10445: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10446: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10447: fnd_msg_pub.add;
10448: RAISE fnd_api.g_exc_unexpected_error;
10449: END IF;
10450:

Line 10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

10482: p_data => x_msg_data
10483: );
10484:
10485: WHEN OTHERS THEN
10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10487: fnd_message.set_token('P_SQLCODE',SQLCODE);
10488: fnd_message.set_token('P_SQLERRM',SQLERRM);
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;

Line 10487: fnd_message.set_token('P_SQLCODE',SQLCODE);

10483: );
10484:
10485: WHEN OTHERS THEN
10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10487: fnd_message.set_token('P_SQLCODE',SQLCODE);
10488: fnd_message.set_token('P_SQLERRM',SQLERRM);
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;
10491:

Line 10488: fnd_message.set_token('P_SQLERRM',SQLERRM);

10484:
10485: WHEN OTHERS THEN
10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10487: fnd_message.set_token('P_SQLCODE',SQLCODE);
10488: fnd_message.set_token('P_SQLERRM',SQLERRM);
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;
10491:
10492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 10489: fnd_message.set_token('P_API_NAME',l_api_name);

10485: WHEN OTHERS THEN
10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10487: fnd_message.set_token('P_SQLCODE',SQLCODE);
10488: fnd_message.set_token('P_SQLERRM',SQLERRM);
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;
10491:
10492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10493: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 10798: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');

10794: IF (p_resource_type IS NOT NULL) THEN
10795: OPEN cur_resource_type;
10796: FETCH cur_resource_type INTO l_cur_resource_type;
10797: IF ( cur_resource_type%NOTFOUND) THEN
10798: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
10799: fnd_msg_pub.add;
10800: RAISE fnd_api.g_exc_error;
10801: END IF;
10802: CLOSE cur_resource_type;

Line 10811: fnd_message.set_name('JTF', 'JTF_AM_INVALID_EFFORT_UOM');

10807: IF (p_effort_uom IS NOT NULL) THEN
10808: OPEN cur_effort_uom;
10809: FETCH cur_effort_uom INTO l_cur_effort_uom;
10810: IF ( cur_effort_uom%NOTFOUND) THEN
10811: fnd_message.set_name('JTF', 'JTF_AM_INVALID_EFFORT_UOM');
10812: fnd_msg_pub.add;
10813: RAISE fnd_api.g_exc_error;
10814: END IF;
10815: CLOSE cur_effort_uom;

Line 11151: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DOC_TYPE');

11147: 'DEF'
11148: )
11149: ) THEN
11150:
11151: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DOC_TYPE');
11152: fnd_msg_pub.add;
11153: RAISE fnd_api.g_exc_error;
11154:
11155: END IF;

Line 11201: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11197: --Added for Bug # 5573916 Ends here
11198: );
11199:
11200: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11201: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11202: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11203: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11204: fnd_msg_pub.add;
11205: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 11202: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');

11198: );
11199:
11200: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11201: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11202: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11203: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11204: fnd_msg_pub.add;
11205: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11206: RAISE fnd_api.g_exc_error;

Line 11203: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11199:
11200: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11201: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11202: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11203: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11204: fnd_msg_pub.add;
11205: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11206: RAISE fnd_api.g_exc_error;
11207: ELSE

Line 11362: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

11358: END IF; -- Auto Select Flag
11359:
11360: ELSE
11361: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
11362: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11363: fnd_msg_pub.add;
11364: -- RAISE fnd_api.g_exc_error;
11365: END IF;
11366:

Line 11398: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11394:
11395:
11396: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11397: -- Unexpected Execution Error from call to assign_sr_resource
11398: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11399: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11400: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11401: fnd_msg_pub.add;
11402: /* Not raising the errors as req by tele service team

Line 11399: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

11395:
11396: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11397: -- Unexpected Execution Error from call to assign_sr_resource
11398: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11399: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11400: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11401: fnd_msg_pub.add;
11402: /* Not raising the errors as req by tele service team
11403: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 11400: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11396: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11397: -- Unexpected Execution Error from call to assign_sr_resource
11398: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11399: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11400: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11401: fnd_msg_pub.add;
11402: /* Not raising the errors as req by tele service team
11403: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11404: RAISE fnd_api.g_exc_error;

Line 11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

11412:
11413:
11414: exception
11415: when others then
11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11417: fnd_message.set_token('P_SQLCODE',SQLCODE);
11418: fnd_message.set_token('P_SQLERRM',SQLERRM);
11419: fnd_message.set_token('P_API_NAME',l_api_name);
11420: FND_MSG_PUB.add;

Line 11417: fnd_message.set_token('P_SQLCODE',SQLCODE);

11413:
11414: exception
11415: when others then
11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11417: fnd_message.set_token('P_SQLCODE',SQLCODE);
11418: fnd_message.set_token('P_SQLERRM',SQLERRM);
11419: fnd_message.set_token('P_API_NAME',l_api_name);
11420: FND_MSG_PUB.add;
11421: end;

Line 11418: fnd_message.set_token('P_SQLERRM',SQLERRM);

11414: exception
11415: when others then
11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11417: fnd_message.set_token('P_SQLCODE',SQLCODE);
11418: fnd_message.set_token('P_SQLERRM',SQLERRM);
11419: fnd_message.set_token('P_API_NAME',l_api_name);
11420: FND_MSG_PUB.add;
11421: end;
11422:

Line 11419: fnd_message.set_token('P_API_NAME',l_api_name);

11415: when others then
11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11417: fnd_message.set_token('P_SQLCODE',SQLCODE);
11418: fnd_message.set_token('P_SQLERRM',SQLERRM);
11419: fnd_message.set_token('P_API_NAME',l_api_name);
11420: FND_MSG_PUB.add;
11421: end;
11422:
11423: -- ================code added for bug 6453896==========================

Line 11474: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11470: --Added for Bug # 5573916 Ends here
11471: );
11472:
11473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11474: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11475: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11476: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11477: fnd_msg_pub.add;
11478: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 11475: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');

11471: );
11472:
11473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11474: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11475: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11476: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11477: fnd_msg_pub.add;
11478: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11479: RAISE fnd_api.g_exc_error;

Line 11476: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11472:
11473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11474: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11475: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11476: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11477: fnd_msg_pub.add;
11478: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11479: RAISE fnd_api.g_exc_error;
11480: ELSE

Line 11656: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

11652: END LOOP;
11653: END IF; -- Auto Select Flag
11654:
11655: ELSE -- No resources returned from the Assignment Manager API for TASKS
11656: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11657: fnd_msg_pub.add;
11658: -- RAISE fnd_api.g_exc_error;
11659: END IF;
11660:

Line 11684: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11680:
11681:
11682: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11683: -- Unexpected Execution Error from call to assign_sr_resource
11684: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11685: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11686: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11687: fnd_msg_pub.add;
11688:

Line 11685: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

11681:
11682: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11683: -- Unexpected Execution Error from call to assign_sr_resource
11684: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11685: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11686: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11687: fnd_msg_pub.add;
11688:
11689: ELSE

Line 11686: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11682: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11683: -- Unexpected Execution Error from call to assign_sr_resource
11684: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11685: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11686: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11687: fnd_msg_pub.add;
11688:
11689: ELSE
11690: x_assign_resources_tbl.delete;

Line 11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

11692: END IF;
11693:
11694: Exception
11695: When OTHERS Then
11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11697: fnd_message.set_token('P_SQLCODE',SQLCODE);
11698: fnd_message.set_token('P_SQLERRM',SQLERRM);
11699: fnd_message.set_token('P_API_NAME',l_api_name);
11700: FND_MSG_PUB.add;

Line 11697: fnd_message.set_token('P_SQLCODE',SQLCODE);

11693:
11694: Exception
11695: When OTHERS Then
11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11697: fnd_message.set_token('P_SQLCODE',SQLCODE);
11698: fnd_message.set_token('P_SQLERRM',SQLERRM);
11699: fnd_message.set_token('P_API_NAME',l_api_name);
11700: FND_MSG_PUB.add;
11701: End;

Line 11698: fnd_message.set_token('P_SQLERRM',SQLERRM);

11694: Exception
11695: When OTHERS Then
11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11697: fnd_message.set_token('P_SQLCODE',SQLCODE);
11698: fnd_message.set_token('P_SQLERRM',SQLERRM);
11699: fnd_message.set_token('P_API_NAME',l_api_name);
11700: FND_MSG_PUB.add;
11701: End;
11702:

Line 11699: fnd_message.set_token('P_API_NAME',l_api_name);

11695: When OTHERS Then
11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11697: fnd_message.set_token('P_SQLCODE',SQLCODE);
11698: fnd_message.set_token('P_SQLERRM',SQLERRM);
11699: fnd_message.set_token('P_API_NAME',l_api_name);
11700: FND_MSG_PUB.add;
11701: End;
11702:
11703: -- ================code added for bug 6453896==========================

Line 11746: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11742: x_msg_data => x_msg_data
11743: );
11744:
11745: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11746: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11747: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11748: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11749: fnd_msg_pub.add;
11750: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 11747: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');

11743: );
11744:
11745: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11746: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11747: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11748: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11749: fnd_msg_pub.add;
11750: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11751: RAISE fnd_api.g_exc_error;

Line 11748: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11744:
11745: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11746: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11747: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11748: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11749: fnd_msg_pub.add;
11750: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11751: RAISE fnd_api.g_exc_error;
11752: ELSE

Line 11836: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

11832: l_current_record := l_assign_resources_tbl.NEXT(l_current_record);
11833: END LOOP;
11834:
11835: ELSE -- No resources returned from the Assignment Manager API for DEFECTS
11836: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11837: fnd_msg_pub.add;
11838: -- RAISE fnd_api.g_exc_error;
11839: END IF;
11840:

Line 11864: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

11860:
11861:
11862: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11863: -- Unexpected Execution Error from call to assign_sr_resource
11864: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11865: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11866: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11867: fnd_msg_pub.add;
11868:

Line 11865: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');

11861:
11862: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11863: -- Unexpected Execution Error from call to assign_sr_resource
11864: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11865: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11866: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11867: fnd_msg_pub.add;
11868:
11869: ELSE

Line 11866: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

11862: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11863: -- Unexpected Execution Error from call to assign_sr_resource
11864: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11865: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11866: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11867: fnd_msg_pub.add;
11868:
11869: ELSE
11870: x_assign_resources_tbl.delete;

Line 11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

11873:
11874:
11875: Exception
11876: When OTHERS Then
11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11878: fnd_message.set_token('P_SQLCODE',SQLCODE);
11879: fnd_message.set_token('P_SQLERRM',SQLERRM);
11880: fnd_message.set_token('P_API_NAME',l_api_name);
11881: FND_MSG_PUB.add;

Line 11878: fnd_message.set_token('P_SQLCODE',SQLCODE);

11874:
11875: Exception
11876: When OTHERS Then
11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11878: fnd_message.set_token('P_SQLCODE',SQLCODE);
11879: fnd_message.set_token('P_SQLERRM',SQLERRM);
11880: fnd_message.set_token('P_API_NAME',l_api_name);
11881: FND_MSG_PUB.add;
11882: End;

Line 11879: fnd_message.set_token('P_SQLERRM',SQLERRM);

11875: Exception
11876: When OTHERS Then
11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11878: fnd_message.set_token('P_SQLCODE',SQLCODE);
11879: fnd_message.set_token('P_SQLERRM',SQLERRM);
11880: fnd_message.set_token('P_API_NAME',l_api_name);
11881: FND_MSG_PUB.add;
11882: End;
11883:

Line 11880: fnd_message.set_token('P_API_NAME',l_api_name);

11876: When OTHERS Then
11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11878: fnd_message.set_token('P_SQLCODE',SQLCODE);
11879: fnd_message.set_token('P_SQLERRM',SQLERRM);
11880: fnd_message.set_token('P_API_NAME',l_api_name);
11881: FND_MSG_PUB.add;
11882: End;
11883:
11884:

Line 11917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

11913:
11914:
11915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11916: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11918: fnd_msg_pub.add;
11919: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11920: RAISE fnd_api.g_exc_error;
11921: ELSE

Line 11947: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

11943:
11944:
11945: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
11946: -- Execution Error from call to Assignment Manager Workflow Hook
11947: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11948: fnd_msg_pub.add;
11949: RAISE fnd_api.g_exc_error;
11950: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
11951: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

Line 11952: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');

11948: fnd_msg_pub.add;
11949: RAISE fnd_api.g_exc_error;
11950: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
11951: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11952: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11953: fnd_msg_pub.add;
11954: RAISE fnd_api.g_exc_unexpected_error;
11955: END IF;
11956:

Line 11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

11990: p_data => x_msg_data
11991: );
11992:
11993: WHEN OTHERS THEN
11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11995: fnd_message.set_token('P_SQLCODE',SQLCODE);
11996: fnd_message.set_token('P_SQLERRM',SQLERRM);
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;

Line 11995: fnd_message.set_token('P_SQLCODE',SQLCODE);

11991: );
11992:
11993: WHEN OTHERS THEN
11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11995: fnd_message.set_token('P_SQLCODE',SQLCODE);
11996: fnd_message.set_token('P_SQLERRM',SQLERRM);
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;
11999:

Line 11996: fnd_message.set_token('P_SQLERRM',SQLERRM);

11992:
11993: WHEN OTHERS THEN
11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11995: fnd_message.set_token('P_SQLCODE',SQLCODE);
11996: fnd_message.set_token('P_SQLERRM',SQLERRM);
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;
11999:
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 11997: fnd_message.set_token('P_API_NAME',l_api_name);

11993: WHEN OTHERS THEN
11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11995: fnd_message.set_token('P_SQLCODE',SQLCODE);
11996: fnd_message.set_token('P_SQLERRM',SQLERRM);
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;
11999:
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 12218: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

12214: );
12215:
12216: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12217: -- Unexpected Execution Error from call to Get_contracts_resources
12218: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12219: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12220: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12221: fnd_msg_pub.add;
12222: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 12219: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');

12215:
12216: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12217: -- Unexpected Execution Error from call to Get_contracts_resources
12218: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12219: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12220: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12221: fnd_msg_pub.add;
12222: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12223: RAISE fnd_api.g_exc_error;

Line 12220: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

12216: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12217: -- Unexpected Execution Error from call to Get_contracts_resources
12218: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12219: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12220: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12221: fnd_msg_pub.add;
12222: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12223: RAISE fnd_api.g_exc_error;
12224: ELSE

Line 12252: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

12248: );
12249:
12250: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12251: -- Unexpected Execution Error from call to Get_contracts_resources
12252: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12253: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12254: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12255: fnd_msg_pub.add;
12256: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 12253: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');

12249:
12250: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12251: -- Unexpected Execution Error from call to Get_contracts_resources
12252: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12253: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12254: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12255: fnd_msg_pub.add;
12256: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12257: RAISE fnd_api.g_exc_error;

Line 12254: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

12250: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12251: -- Unexpected Execution Error from call to Get_contracts_resources
12252: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12253: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12254: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12255: fnd_msg_pub.add;
12256: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12257: RAISE fnd_api.g_exc_error;
12258: ELSE

Line 12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

12283: p_data => x_msg_data
12284: );
12285:
12286: WHEN OTHERS THEN
12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12288: fnd_message.set_token('P_SQLCODE',SQLCODE);
12289: fnd_message.set_token('P_SQLERRM',SQLERRM);
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;

Line 12288: fnd_message.set_token('P_SQLCODE',SQLCODE);

12284: );
12285:
12286: WHEN OTHERS THEN
12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12288: fnd_message.set_token('P_SQLCODE',SQLCODE);
12289: fnd_message.set_token('P_SQLERRM',SQLERRM);
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;
12292:

Line 12289: fnd_message.set_token('P_SQLERRM',SQLERRM);

12285:
12286: WHEN OTHERS THEN
12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12288: fnd_message.set_token('P_SQLCODE',SQLCODE);
12289: fnd_message.set_token('P_SQLERRM',SQLERRM);
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;
12292:
12293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 12290: fnd_message.set_token('P_API_NAME',l_api_name);

12286: WHEN OTHERS THEN
12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12288: fnd_message.set_token('P_SQLCODE',SQLCODE);
12289: fnd_message.set_token('P_SQLERRM',SQLERRM);
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;
12292:
12293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

Line 12379: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');

12375: l_api_name := l_api_name_1;
12376:
12377: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12378: -- Unexpected Execution Error from call to Get_contracts_resources
12379: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12380: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12381: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12382: fnd_msg_pub.add;
12383: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 12380: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');

12376:
12377: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12378: -- Unexpected Execution Error from call to Get_contracts_resources
12379: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12380: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12381: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12382: fnd_msg_pub.add;
12383: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12384: RAISE fnd_api.g_exc_error;

Line 12381: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');

12377: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12378: -- Unexpected Execution Error from call to Get_contracts_resources
12379: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12380: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12381: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12382: fnd_msg_pub.add;
12383: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12384: RAISE fnd_api.g_exc_error;
12385: ELSE

Line 12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');

12407: p_data => x_msg_data
12408: );
12409:
12410: WHEN OTHERS THEN
12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12412: fnd_message.set_token('P_SQLCODE',SQLCODE);
12413: fnd_message.set_token('P_SQLERRM',SQLERRM);
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;

Line 12412: fnd_message.set_token('P_SQLCODE',SQLCODE);

12408: );
12409:
12410: WHEN OTHERS THEN
12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12412: fnd_message.set_token('P_SQLCODE',SQLCODE);
12413: fnd_message.set_token('P_SQLERRM',SQLERRM);
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;
12416:

Line 12413: fnd_message.set_token('P_SQLERRM',SQLERRM);

12409:
12410: WHEN OTHERS THEN
12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12412: fnd_message.set_token('P_SQLCODE',SQLCODE);
12413: fnd_message.set_token('P_SQLERRM',SQLERRM);
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;
12416:
12417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 12414: fnd_message.set_token('P_API_NAME',l_api_name);

12410: WHEN OTHERS THEN
12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12412: fnd_message.set_token('P_SQLCODE',SQLCODE);
12413: fnd_message.set_token('P_SQLERRM',SQLERRM);
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;
12416:
12417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN