APPS.JTF_ASSIGN_PUB dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

1336: l_api_name := l_api_name_1;
1337:
1338: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1339: -- Unexpected Execution Error from call to Calendar
1340: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1341: fnd_msg_pub.add;
1342:
1343: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1344: -- 12/22/05 ** MPADHIAR ** Manas padhiary **

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

1511: l_api_name := l_api_name_1;
1512:
1513: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1514: -- Unexpected Execution Error from call to Calendar
1515: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1516: fnd_msg_pub.add;
1517: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1518: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1519: -- Removed Comment to Show error message Bug # 2919389

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

1637: p_data => x_msg_data
1638: );
1639:
1640: WHEN OTHERS THEN
1641: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1642: fnd_message.set_token('P_SQLCODE',SQLCODE);
1643: fnd_message.set_token('P_SQLERRM',SQLERRM);
1644: fnd_message.set_token('P_API_NAME',l_api_name);
1645: FND_MSG_PUB.add;

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

1638: );
1639:
1640: WHEN OTHERS THEN
1641: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1642: fnd_message.set_token('P_SQLCODE',SQLCODE);
1643: fnd_message.set_token('P_SQLERRM',SQLERRM);
1644: fnd_message.set_token('P_API_NAME',l_api_name);
1645: FND_MSG_PUB.add;
1646:

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

1639:
1640: WHEN OTHERS THEN
1641: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1642: fnd_message.set_token('P_SQLCODE',SQLCODE);
1643: fnd_message.set_token('P_SQLERRM',SQLERRM);
1644: fnd_message.set_token('P_API_NAME',l_api_name);
1645: FND_MSG_PUB.add;
1646:
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1640: WHEN OTHERS THEN
1641: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1642: fnd_message.set_token('P_SQLCODE',SQLCODE);
1643: fnd_message.set_token('P_SQLERRM',SQLERRM);
1644: fnd_message.set_token('P_API_NAME',l_api_name);
1645: FND_MSG_PUB.add;
1646:
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

1759: l_business_process_date := sysdate;
1760: END IF;
1761:
1762: IF (l_cur_contracts_installed.application_id IS NULL) THEN
1763: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1764: fnd_msg_pub.add;
1765: RAISE fnd_api.g_exc_error;
1766: ELSE
1767:

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

1772: l_status,
1773: l_industry
1774: ) THEN
1775: IF ( UPPER(l_status) <> 'I' ) THEN
1776: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1777: fnd_msg_pub.add;
1778: RAISE fnd_api.g_exc_error;
1779: END IF;
1780: ELSE

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

1777: fnd_msg_pub.add;
1778: RAISE fnd_api.g_exc_error;
1779: END IF;
1780: ELSE
1781: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1782: fnd_msg_pub.add;
1783: RAISE fnd_api.g_exc_error;
1784: END IF;
1785: END IF;

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

1834:
1835:
1836: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1837: -- Unexpected Execution Error from call to Contracts API
1838: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_CONTRACTS_API'||''''||');'||
1839: 'fnd_msg_pub.add;
1840: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1841: RAISE fnd_api.g_exc_error;
1842: ELSE

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

2041: l_api_name := l_api_name_1;
2042:
2043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2044: -- Unexpected Execution Error from call to Get_contracts_resources
2045: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2046: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2047: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2048: fnd_msg_pub.add;
2049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

2042:
2043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2044: -- Unexpected Execution Error from call to Get_contracts_resources
2045: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2046: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2047: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2048: fnd_msg_pub.add;
2049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2050: RAISE fnd_api.g_exc_error;

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

2043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2044: -- Unexpected Execution Error from call to Get_contracts_resources
2045: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2046: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2047: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2048: fnd_msg_pub.add;
2049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2050: RAISE fnd_api.g_exc_error;
2051: ELSE

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

2073: p_data => x_msg_data
2074: );
2075:
2076: WHEN OTHERS THEN
2077: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2078: fnd_message.set_token('P_SQLCODE',SQLCODE);
2079: fnd_message.set_token('P_SQLERRM',SQLERRM);
2080: fnd_message.set_token('P_API_NAME',l_api_name);
2081: FND_MSG_PUB.add;

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

2074: );
2075:
2076: WHEN OTHERS THEN
2077: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2078: fnd_message.set_token('P_SQLCODE',SQLCODE);
2079: fnd_message.set_token('P_SQLERRM',SQLERRM);
2080: fnd_message.set_token('P_API_NAME',l_api_name);
2081: FND_MSG_PUB.add;
2082:

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

2075:
2076: WHEN OTHERS THEN
2077: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2078: fnd_message.set_token('P_SQLCODE',SQLCODE);
2079: fnd_message.set_token('P_SQLERRM',SQLERRM);
2080: fnd_message.set_token('P_API_NAME',l_api_name);
2081: FND_MSG_PUB.add;
2082:
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2076: WHEN OTHERS THEN
2077: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2078: fnd_message.set_token('P_SQLCODE',SQLCODE);
2079: fnd_message.set_token('P_SQLERRM',SQLERRM);
2080: fnd_message.set_token('P_API_NAME',l_api_name);
2081: FND_MSG_PUB.add;
2082:
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2084: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

2483: l_api_name := l_api_name_1;
2484:
2485: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2486: -- Unexpected Execution Error from call to Get_contracts_resources
2487: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2488: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2489: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2490: fnd_msg_pub.add;
2491: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

2484:
2485: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2486: -- Unexpected Execution Error from call to Get_contracts_resources
2487: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2488: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2489: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2490: fnd_msg_pub.add;
2491: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2492: RAISE fnd_api.g_exc_error;

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

2485: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2486: -- Unexpected Execution Error from call to Get_contracts_resources
2487: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2488: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2489: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2490: fnd_msg_pub.add;
2491: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2492: RAISE fnd_api.g_exc_error;
2493: ELSE

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

2515: p_data => x_msg_data
2516: );
2517:
2518: WHEN OTHERS THEN
2519: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2520: fnd_message.set_token('P_SQLCODE',SQLCODE);
2521: fnd_message.set_token('P_SQLERRM',SQLERRM);
2522: fnd_message.set_token('P_API_NAME',l_api_name);
2523: FND_MSG_PUB.add;

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

2516: );
2517:
2518: WHEN OTHERS THEN
2519: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2520: fnd_message.set_token('P_SQLCODE',SQLCODE);
2521: fnd_message.set_token('P_SQLERRM',SQLERRM);
2522: fnd_message.set_token('P_API_NAME',l_api_name);
2523: FND_MSG_PUB.add;
2524:

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

2517:
2518: WHEN OTHERS THEN
2519: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2520: fnd_message.set_token('P_SQLCODE',SQLCODE);
2521: fnd_message.set_token('P_SQLERRM',SQLERRM);
2522: fnd_message.set_token('P_API_NAME',l_api_name);
2523: FND_MSG_PUB.add;
2524:
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2518: WHEN OTHERS THEN
2519: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2520: fnd_message.set_token('P_SQLCODE',SQLCODE);
2521: fnd_message.set_token('P_SQLERRM',SQLERRM);
2522: fnd_message.set_token('P_API_NAME',l_api_name);
2523: FND_MSG_PUB.add;
2524:
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2526: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

2818: THEN
2819: OPEN cur_task_id;
2820: FETCH cur_task_id INTO l_cur_task_id;
2821: IF ( cur_task_id%NOTFOUND ) THEN
2822: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
2823: fnd_msg_pub.add;
2824: RAISE fnd_api.g_exc_error;
2825: ELSE
2826: l_task_source_code := l_cur_task_id.source_object_type_code;

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

2856: l_cp_id,
2857: l_planned_end_date;
2858:
2859: IF ( cur_cs_incidents%NOTFOUND ) THEN
2860: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
2861: fnd_msg_pub.add;
2862: RAISE fnd_api.g_exc_error;
2863: ELSE
2864: l_contract_flag := 'Y';

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

2922: );
2923:
2924: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2925: -- Unexpected Execution Error from call to Get_contracts_resources
2926: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2927: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2928: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2929: fnd_msg_pub.add;
2930: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

2923:
2924: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2925: -- Unexpected Execution Error from call to Get_contracts_resources
2926: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2927: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2928: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2929: fnd_msg_pub.add;
2930: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2931: RAISE fnd_api.g_exc_error;

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

2924: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2925: -- Unexpected Execution Error from call to Get_contracts_resources
2926: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2927: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2928: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2929: fnd_msg_pub.add;
2930: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2931: RAISE fnd_api.g_exc_error;
2932: ELSE

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

2964: );
2965:
2966: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2967: -- Unexpected Execution Error from call to Get_contracts_resources
2968: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2969: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2970: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2971: fnd_msg_pub.add;
2972: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

2965:
2966: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2967: -- Unexpected Execution Error from call to Get_contracts_resources
2968: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2969: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2970: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2971: fnd_msg_pub.add;
2972: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2973: RAISE fnd_api.g_exc_error;

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

2966: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2967: -- Unexpected Execution Error from call to Get_contracts_resources
2968: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2969: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2970: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2971: fnd_msg_pub.add;
2972: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2973: RAISE fnd_api.g_exc_error;
2974: ELSE

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

3025:
3026: -- If there are NO preferred engineers then call territory API
3027:
3028: IF (l_task_source_code = 'SR') THEN
3029: fnd_message.set_name('JTF', 'JTF_AM_TASK_CREATED_BY_SR');
3030: fnd_msg_pub.add;
3031: RAISE fnd_api.g_exc_error;
3032:
3033: /* Query the View which is a combination of Task and Service Request

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

3081: l_api_name := l_api_name_1;
3082:
3083: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3084: -- Unexpected Execution Error from call to Territory Manager
3085: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3086: fnd_msg_pub.add;
3087: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3088: RAISE fnd_api.g_exc_error;
3089: ELSE

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

3184: l_api_name := l_api_name_1;
3185:
3186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3187: -- Unexpected Execution Error from call to Get_contracts_resources
3188: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3189: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3190: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3191: fnd_msg_pub.add;
3192: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

3185:
3186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3187: -- Unexpected Execution Error from call to Get_contracts_resources
3188: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3189: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3190: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3191: fnd_msg_pub.add;
3192: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3193: RAISE fnd_api.g_exc_error;

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

3186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3187: -- Unexpected Execution Error from call to Get_contracts_resources
3188: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3189: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3190: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3191: fnd_msg_pub.add;
3192: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3193: RAISE fnd_api.g_exc_error;
3194: ELSE

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

3198: -- end if; -- if p_calendar_flag = Y
3199:
3200: IF ( p_calendar_flag = 'Y' AND
3201: x_assign_resources_tbl.count = 0 ) THEN
3202: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3203: fnd_msg_pub.add;
3204: -- RAISE fnd_api.g_exc_error;
3205: END IF;
3206:

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

3211: x_exc_res => l_excluded_resource_tbl);
3212: END IF;
3213:
3214: ELSE -- No resources returned from the Territory API
3215: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3216: fnd_msg_pub.add;
3217: -- RAISE fnd_api.g_exc_error;
3218: END IF;
3219:

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

3217: -- RAISE fnd_api.g_exc_error;
3218: END IF;
3219:
3220: ELSE -- Territory Flag is NO
3221: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3222: fnd_msg_pub.add;
3223: -- RAISE fnd_api.g_exc_error;
3224: END IF;
3225:

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

3297: l_api_name := l_api_name_1;
3298:
3299: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3300: -- Unexpected Execution Error from call to Territory Manager for TASKS
3301: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3302: fnd_msg_pub.add;
3303: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3304: RAISE fnd_api.g_exc_error;
3305: ELSE

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

3401: l_api_name := l_api_name_1;
3402:
3403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3404: -- Unexpected Execution Error from call to Get_contracts_resources
3405: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3406: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3407: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3408: fnd_msg_pub.add;
3409: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

3402:
3403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3404: -- Unexpected Execution Error from call to Get_contracts_resources
3405: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3406: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3407: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3408: fnd_msg_pub.add;
3409: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3410: RAISE fnd_api.g_exc_error;

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

3403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3404: -- Unexpected Execution Error from call to Get_contracts_resources
3405: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3406: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3407: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3408: fnd_msg_pub.add;
3409: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3410: RAISE fnd_api.g_exc_error;
3411: ELSE

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

3415: -- end if; -- if p_calendar_flag = Y
3416:
3417: IF ( p_calendar_flag = 'Y' AND
3418: x_assign_resources_tbl.count = 0 ) THEN
3419: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3420: fnd_msg_pub.add;
3421: -- RAISE fnd_api.g_exc_error;
3422: END IF;
3423:

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

3421: -- RAISE fnd_api.g_exc_error;
3422: END IF;
3423:
3424: ELSE -- No resources returned from the Territory API
3425: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3426: fnd_msg_pub.add;
3427: -- RAISE fnd_api.g_exc_error;
3428: END IF;
3429:

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

3433: -- removed code which fetches Resources even if Calendar Flag is checked.
3434: -- This was done as we don't want to fetch all resources blindly any time.
3435: -- Fix for Bug 3308883.
3436:
3437: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3438: fnd_msg_pub.add;
3439: END IF; -- End of Territory_Flag = 'Y'
3440:
3441: END IF; -- End of l_task_source_code = 'SR'

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

3558: p_data => x_msg_data
3559: );
3560:
3561: WHEN OTHERS THEN
3562: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3563: fnd_message.set_token('P_SQLCODE',SQLCODE);
3564: fnd_message.set_token('P_SQLERRM',SQLERRM);
3565: fnd_message.set_token('P_API_NAME',l_api_name);
3566: FND_MSG_PUB.add;

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

3559: );
3560:
3561: WHEN OTHERS THEN
3562: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3563: fnd_message.set_token('P_SQLCODE',SQLCODE);
3564: fnd_message.set_token('P_SQLERRM',SQLERRM);
3565: fnd_message.set_token('P_API_NAME',l_api_name);
3566: FND_MSG_PUB.add;
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3560:
3561: WHEN OTHERS THEN
3562: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3563: fnd_message.set_token('P_SQLCODE',SQLCODE);
3564: fnd_message.set_token('P_SQLERRM',SQLERRM);
3565: fnd_message.set_token('P_API_NAME',l_api_name);
3566: FND_MSG_PUB.add;
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

3561: WHEN OTHERS THEN
3562: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3563: fnd_message.set_token('P_SQLCODE',SQLCODE);
3564: fnd_message.set_token('P_SQLERRM',SQLERRM);
3565: fnd_message.set_token('P_API_NAME',l_api_name);
3566: FND_MSG_PUB.add;
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
3569: FND_MSG_PUB.Add_Exc_Msg

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

3942: l_expected_end_date; -- Added by SBARAT on 10/12/2004 for Bug 4052202
3943: --l_planned_end_date; -- Commented by SBARAT on 10/12/2004 for Bug 4052202
3944:
3945: IF ( cur_cs_incidents%NOTFOUND ) THEN
3946: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
3947: fnd_msg_pub.add;
3948: RAISE fnd_api.g_exc_error;
3949: /*
3950: ELSE

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

4001: );
4002:
4003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4004: -- Unexpected Execution Error from call to Get_contracts_resources
4005: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4006: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
4007: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4008: fnd_msg_pub.add;
4009: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

4002:
4003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4004: -- Unexpected Execution Error from call to Get_contracts_resources
4005: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4006: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
4007: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4008: fnd_msg_pub.add;
4009: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4010: RAISE fnd_api.g_exc_error;

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

4003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4004: -- Unexpected Execution Error from call to Get_contracts_resources
4005: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4006: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
4007: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4008: fnd_msg_pub.add;
4009: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4010: RAISE fnd_api.g_exc_error;
4011: ELSE

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

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

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

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

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

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

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

4080: x_msg_data =>x_msg_data);
4081:
4082: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4083: -- Unexpected Execution Error from call to Get_contracts_resources
4084: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4085: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4086: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4087: fnd_msg_pub.add;
4088: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

4081:
4082: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4083: -- Unexpected Execution Error from call to Get_contracts_resources
4084: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4085: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4086: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4087: fnd_msg_pub.add;
4088: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4089: RAISE fnd_api.g_exc_error;

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

4082: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4083: -- Unexpected Execution Error from call to Get_contracts_resources
4084: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4085: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4086: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4087: fnd_msg_pub.add;
4088: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4089: RAISE fnd_api.g_exc_error;
4090: ELSE

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

4105: x_msg_data =>x_msg_data);
4106:
4107: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4108: -- Unexpected Execution Error from call to Get_contracts_resources
4109: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4110: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4111: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4112: fnd_msg_pub.add;
4113: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

4106:
4107: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4108: -- Unexpected Execution Error from call to Get_contracts_resources
4109: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4110: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4111: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4112: fnd_msg_pub.add;
4113: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4114: RAISE fnd_api.g_exc_error;

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

4107: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4108: -- Unexpected Execution Error from call to Get_contracts_resources
4109: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4110: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4111: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4112: fnd_msg_pub.add;
4113: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4114: RAISE fnd_api.g_exc_error;
4115: ELSE

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

4302: l_api_name := l_api_name_1;
4303:
4304: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4305: -- Unexpected Execution Error from call to Territory Manager
4306: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4307: fnd_msg_pub.add;
4308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4309: RAISE fnd_api.g_exc_error;
4310: ELSE

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

4332: -- removed code which fetches Resources even if Calendar Flag is checked.
4333: -- This was done as we don't want to fetch all resources blindly any time.
4334: -- Fix for Bug 3308883.
4335:
4336: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4337: fnd_msg_pub.add;
4338: END IF; -- End of p_territory_flag = 'Y'
4339:
4340: ELSIF

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

4431: -- dbms_output.put_line('Count of TM :: '||l_assign_resources_tbl.count);
4432:
4433: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4434: -- Unexpected Execution Error from call to Territory Manager
4435: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4436: fnd_msg_pub.add;
4437: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4438: RAISE fnd_api.g_exc_error;
4439: ELSE

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

4462: -- removed code which fetches Resources even if Calendar Flag is checked.
4463: -- This was done as we don't want to fetch all resources blindly any time.
4464: -- Fix for Bug 3308883.
4465:
4466: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4467: fnd_msg_pub.add;
4468: END IF; -- End of p_territory_flag = 'Y'
4469:
4470: END IF; -- End of p_sr_rec IS NOT NULL or p_sr_task_rec IS NOT NULL

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

4549: l_api_name := l_api_name_1;
4550:
4551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4552: -- Unexpected Execution Error from call to Get_contracts_resources
4553: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4554: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4555: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4556: fnd_msg_pub.add;
4557: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

4550:
4551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4552: -- Unexpected Execution Error from call to Get_contracts_resources
4553: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4554: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4555: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4556: fnd_msg_pub.add;
4557: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4558: RAISE fnd_api.g_exc_error;

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

4551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4552: -- Unexpected Execution Error from call to Get_contracts_resources
4553: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4554: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4555: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4556: fnd_msg_pub.add;
4557: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4558: RAISE fnd_api.g_exc_error;
4559: ELSE

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

4564:
4565:
4566: IF ( p_calendar_flag = 'Y' AND
4567: x_assign_resources_tbl.count = 0 ) THEN
4568: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
4569: fnd_msg_pub.add;
4570: -- RAISE fnd_api.g_exc_error;
4571: END IF;
4572:

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

4591: x_msg_data =>x_msg_data);
4592:
4593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4594: -- Unexpected Execution Error from call to Get_contracts_resources
4595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4596: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4598: fnd_msg_pub.add;
4599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

4592:
4593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4594: -- Unexpected Execution Error from call to Get_contracts_resources
4595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4596: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4598: fnd_msg_pub.add;
4599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4600: RAISE fnd_api.g_exc_error;

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

4593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4594: -- Unexpected Execution Error from call to Get_contracts_resources
4595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4596: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4598: fnd_msg_pub.add;
4599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4600: RAISE fnd_api.g_exc_error;
4601: ELSE

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

4604: END IF;
4605: END IF; -- end of security check
4606: ELSE -- No resources returned from the Territory API
4607:
4608: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4609: fnd_msg_pub.add;
4610: -- RAISE fnd_api.g_exc_error;
4611: END IF;
4612:

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

4967: p_data => x_msg_data
4968: );
4969:
4970: WHEN OTHERS THEN
4971: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4972: fnd_message.set_token('P_SQLCODE',SQLCODE);
4973: fnd_message.set_token('P_SQLERRM',SQLERRM);
4974: fnd_message.set_token('P_API_NAME',l_api_name);
4975: FND_MSG_PUB.add;

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

4968: );
4969:
4970: WHEN OTHERS THEN
4971: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4972: fnd_message.set_token('P_SQLCODE',SQLCODE);
4973: fnd_message.set_token('P_SQLERRM',SQLERRM);
4974: fnd_message.set_token('P_API_NAME',l_api_name);
4975: FND_MSG_PUB.add;
4976:

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

4969:
4970: WHEN OTHERS THEN
4971: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4972: fnd_message.set_token('P_SQLCODE',SQLCODE);
4973: fnd_message.set_token('P_SQLERRM',SQLERRM);
4974: fnd_message.set_token('P_API_NAME',l_api_name);
4975: FND_MSG_PUB.add;
4976:
4977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4970: WHEN OTHERS THEN
4971: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4972: fnd_message.set_token('P_SQLCODE',SQLCODE);
4973: fnd_message.set_token('P_SQLERRM',SQLERRM);
4974: fnd_message.set_token('P_API_NAME',l_api_name);
4975: FND_MSG_PUB.add;
4976:
4977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4978: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

5314: IF (p_resource_type IS NOT NULL) THEN
5315: OPEN cur_resource_type;
5316: FETCH cur_resource_type INTO l_cur_resource_type;
5317: IF ( cur_resource_type%NOTFOUND) THEN
5318: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
5319: fnd_msg_pub.add;
5320: RAISE fnd_api.g_exc_error;
5321: END IF;
5322: CLOSE cur_resource_type;

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

5534: l_expected_end_date; --Added by SBARAT on 10/12/2004 for bug 4052202
5535: --l_planned_end_date; --Commented out by SBARAT on 10/12/2004 for bug 4052202
5536:
5537: IF ( cur_cs_incidents%NOTFOUND ) THEN
5538: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DR_ID');
5539: fnd_msg_pub.add;
5540: RAISE fnd_api.g_exc_error;
5541: END IF;
5542:

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

5591: );
5592:
5593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5594: -- Unexpected Execution Error from call to Get_contracts_resources
5595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5596: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5598: fnd_msg_pub.add;
5599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

5592:
5593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5594: -- Unexpected Execution Error from call to Get_contracts_resources
5595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5596: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5598: fnd_msg_pub.add;
5599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5600: RAISE fnd_api.g_exc_error;

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

5593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5594: -- Unexpected Execution Error from call to Get_contracts_resources
5595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5596: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5598: fnd_msg_pub.add;
5599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5600: RAISE fnd_api.g_exc_error;
5601: ELSE

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

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

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

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

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

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

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

5670: x_msg_data =>x_msg_data);
5671:
5672: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5673: -- Unexpected Execution Error from call to Get_contracts_resources
5674: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5675: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5676: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5677: fnd_msg_pub.add;
5678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

5671:
5672: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5673: -- Unexpected Execution Error from call to Get_contracts_resources
5674: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5675: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5676: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5677: fnd_msg_pub.add;
5678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5679: RAISE fnd_api.g_exc_error;

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

5672: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5673: -- Unexpected Execution Error from call to Get_contracts_resources
5674: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5675: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5676: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5677: fnd_msg_pub.add;
5678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5679: RAISE fnd_api.g_exc_error;
5680: ELSE

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

5695: x_msg_data =>x_msg_data);
5696:
5697: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5698: -- Unexpected Execution Error from call to Get_contracts_resources
5699: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5700: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5701: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5702: fnd_msg_pub.add;
5703: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

5696:
5697: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5698: -- Unexpected Execution Error from call to Get_contracts_resources
5699: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5700: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5701: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5702: fnd_msg_pub.add;
5703: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5704: RAISE fnd_api.g_exc_error;

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

5697: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5698: -- Unexpected Execution Error from call to Get_contracts_resources
5699: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5700: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5701: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5702: fnd_msg_pub.add;
5703: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5704: RAISE fnd_api.g_exc_error;
5705: ELSE

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

5800: l_api_name := l_api_name_1;
5801:
5802: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5803: -- Unexpected Execution Error from call to Territory Manager
5804: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
5805: fnd_msg_pub.add;
5806: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5807: RAISE fnd_api.g_exc_error;
5808: ELSE

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

5824: END IF;
5825:
5826: ELSE -- Territory Flag is NO
5827:
5828: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5829: fnd_msg_pub.add;
5830:
5831: END IF; -- End of p_territory_flag = 'Y'
5832:

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

5894: l_api_name := l_api_name_1;
5895:
5896: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5897: -- Unexpected Execution Error from call to Get_contracts_resources
5898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5899: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5901: fnd_msg_pub.add;
5902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

5895:
5896: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5897: -- Unexpected Execution Error from call to Get_contracts_resources
5898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5899: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5901: fnd_msg_pub.add;
5902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5903: RAISE fnd_api.g_exc_error;

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

5896: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5897: -- Unexpected Execution Error from call to Get_contracts_resources
5898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5899: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5901: fnd_msg_pub.add;
5902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5903: RAISE fnd_api.g_exc_error;
5904: ELSE

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

5907: END IF; -- end of x_return_status check
5908:
5909: IF ( p_calendar_flag = 'Y' AND
5910: l_assign_resources_tbl.count = 0 ) THEN
5911: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
5912: fnd_msg_pub.add;
5913: END IF;
5914:
5915:

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

5932: x_msg_data =>x_msg_data);
5933:
5934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5935: -- Unexpected Execution Error from call to Get_contracts_resources
5936: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5937: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5938: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5939: fnd_msg_pub.add;
5940: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

5933:
5934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5935: -- Unexpected Execution Error from call to Get_contracts_resources
5936: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5937: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5938: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5939: fnd_msg_pub.add;
5940: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5941: RAISE fnd_api.g_exc_error;

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

5934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5935: -- Unexpected Execution Error from call to Get_contracts_resources
5936: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5937: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5938: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5939: fnd_msg_pub.add;
5940: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5941: RAISE fnd_api.g_exc_error;
5942: ELSE

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

5945: END IF;
5946: END IF; -- end of security check
5947: ELSE -- No resources returned from the Territory API
5948:
5949: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5950: fnd_msg_pub.add;
5951: END IF;
5952:
5953:

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

6328: END IF; -- Auto Select Flag
6329:
6330: ELSE
6331: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
6332: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6333: fnd_msg_pub.add;
6334: END IF;
6335:
6336:

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

6359:
6360:
6361: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6362: -- Unexpected Execution Error from call to assign_dr_resource
6363: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6364: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6365: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6366: fnd_msg_pub.add;
6367:

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

6360:
6361: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6362: -- Unexpected Execution Error from call to assign_dr_resource
6363: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6364: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6365: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6366: fnd_msg_pub.add;
6367:
6368: ELSE

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

6361: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
6362: -- Unexpected Execution Error from call to assign_dr_resource
6363: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6364: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6365: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6366: fnd_msg_pub.add;
6367:
6368: ELSE
6369: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

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

6371:
6372:
6373: Exception
6374: When Others Then
6375: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6376: fnd_message.set_token('P_SQLCODE',SQLCODE);
6377: fnd_message.set_token('P_SQLERRM',SQLERRM);
6378: fnd_message.set_token('P_API_NAME',l_api_name);
6379: FND_MSG_PUB.add;

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

6372:
6373: Exception
6374: When Others Then
6375: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6376: fnd_message.set_token('P_SQLCODE',SQLCODE);
6377: fnd_message.set_token('P_SQLERRM',SQLERRM);
6378: fnd_message.set_token('P_API_NAME',l_api_name);
6379: FND_MSG_PUB.add;
6380: End;

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

6373: Exception
6374: When Others Then
6375: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6376: fnd_message.set_token('P_SQLCODE',SQLCODE);
6377: fnd_message.set_token('P_SQLERRM',SQLERRM);
6378: fnd_message.set_token('P_API_NAME',l_api_name);
6379: FND_MSG_PUB.add;
6380: End;
6381:

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

6374: When Others Then
6375: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6376: fnd_message.set_token('P_SQLCODE',SQLCODE);
6377: fnd_message.set_token('P_SQLERRM',SQLERRM);
6378: fnd_message.set_token('P_API_NAME',l_api_name);
6379: FND_MSG_PUB.add;
6380: End;
6381:
6382:

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

6408:
6409:
6410: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6411: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6412: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6413: fnd_msg_pub.add;
6414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6415: RAISE fnd_api.g_exc_error;
6416: ELSE

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

6438:
6439:
6440: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
6441: -- Execution Error from call to Assignment Manager Workflow Hook
6442: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6443: fnd_msg_pub.add;
6444: RAISE fnd_api.g_exc_error;
6445: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6446: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

6443: fnd_msg_pub.add;
6444: RAISE fnd_api.g_exc_error;
6445: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6446: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6447: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6448: fnd_msg_pub.add;
6449: RAISE fnd_api.g_exc_unexpected_error;
6450: END IF;
6451:

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

6483: p_data => x_msg_data
6484: );
6485:
6486: WHEN OTHERS THEN
6487: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6488: fnd_message.set_token('P_SQLCODE',SQLCODE);
6489: fnd_message.set_token('P_SQLERRM',SQLERRM);
6490: fnd_message.set_token('P_API_NAME',l_api_name);
6491: FND_MSG_PUB.add;

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

6484: );
6485:
6486: WHEN OTHERS THEN
6487: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6488: fnd_message.set_token('P_SQLCODE',SQLCODE);
6489: fnd_message.set_token('P_SQLERRM',SQLERRM);
6490: fnd_message.set_token('P_API_NAME',l_api_name);
6491: FND_MSG_PUB.add;
6492:

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

6485:
6486: WHEN OTHERS THEN
6487: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6488: fnd_message.set_token('P_SQLCODE',SQLCODE);
6489: fnd_message.set_token('P_SQLERRM',SQLERRM);
6490: fnd_message.set_token('P_API_NAME',l_api_name);
6491: FND_MSG_PUB.add;
6492:
6493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

6486: WHEN OTHERS THEN
6487: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6488: fnd_message.set_token('P_SQLCODE',SQLCODE);
6489: fnd_message.set_token('P_SQLERRM',SQLERRM);
6490: fnd_message.set_token('P_API_NAME',l_api_name);
6491: FND_MSG_PUB.add;
6492:
6493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

6742:
6743: OPEN cur_oppr FOR l_dynamic_sql USING p_opportunity_id;
6744: FETCH cur_oppr INTO l_assign_resources_rec;
6745: IF (cur_oppr%NOTFOUND) THEN
6746: fnd_message.set_name('JTF', 'JTF_AM_INVALID_OPPR_ID');
6747: fnd_msg_pub.add;
6748: RAISE fnd_api.g_exc_error;
6749: END IF;
6750: CLOSE cur_oppr;

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

6863:
6864:
6865: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6866: -- Unexpected Execution Error from call to Territory Manager
6867: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
6868: fnd_msg_pub.add;
6869: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6870: RAISE fnd_api.g_exc_error;
6871: ELSE

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

6970: l_api_name := l_api_name_1;
6971:
6972: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6973: -- Unexpected Execution Error from call to Get_contracts_resources
6974: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6975: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6976: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6977: fnd_msg_pub.add;
6978: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

6971:
6972: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6973: -- Unexpected Execution Error from call to Get_contracts_resources
6974: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6975: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6976: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6977: fnd_msg_pub.add;
6978: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6979: RAISE fnd_api.g_exc_error;

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

6972: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6973: -- Unexpected Execution Error from call to Get_contracts_resources
6974: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6975: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6976: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6977: fnd_msg_pub.add;
6978: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6979: RAISE fnd_api.g_exc_error;
6980: ELSE

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

6984: end if; -- if p_calendar_flag = Y
6985:
6986: IF ( p_calendar_flag = 'Y' AND
6987: x_assign_resources_tbl.count = 0 ) THEN
6988: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
6989: fnd_msg_pub.add;
6990: -- RAISE fnd_api.g_exc_error;
6991: END IF;
6992:

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

7013:
7014: END IF; -- end of auto select flag
7015:
7016: ELSE -- No resources returned from the Territory API
7017: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7018: fnd_msg_pub.add;
7019: -- RAISE fnd_api.g_exc_error;
7020: END IF;
7021:

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

7019: -- RAISE fnd_api.g_exc_error;
7020: END IF;
7021:
7022: ELSE -- Territory Flag is NO
7023: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7024: fnd_msg_pub.add;
7025: -- RAISE fnd_api.g_exc_error;
7026: END IF;
7027:

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

7046:
7047:
7048: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7049: -- Unexpected Execution Error from call to assign_sr_resource
7050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7051: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
7053: fnd_msg_pub.add;
7054:

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

7047:
7048: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7049: -- Unexpected Execution Error from call to assign_sr_resource
7050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7051: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
7053: fnd_msg_pub.add;
7054:
7055: ELSE

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

7048: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7049: -- Unexpected Execution Error from call to assign_sr_resource
7050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7051: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
7053: fnd_msg_pub.add;
7054:
7055: ELSE
7056: x_assign_resources_tbl.delete;

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

7059:
7060:
7061: Exception
7062: When OTHERS Then
7063: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7064: fnd_message.set_token('P_SQLCODE',SQLCODE);
7065: fnd_message.set_token('P_SQLERRM',SQLERRM);
7066: fnd_message.set_token('P_API_NAME',l_api_name);
7067: FND_MSG_PUB.add;

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

7060:
7061: Exception
7062: When OTHERS Then
7063: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7064: fnd_message.set_token('P_SQLCODE',SQLCODE);
7065: fnd_message.set_token('P_SQLERRM',SQLERRM);
7066: fnd_message.set_token('P_API_NAME',l_api_name);
7067: FND_MSG_PUB.add;
7068: End;

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

7061: Exception
7062: When OTHERS Then
7063: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7064: fnd_message.set_token('P_SQLCODE',SQLCODE);
7065: fnd_message.set_token('P_SQLERRM',SQLERRM);
7066: fnd_message.set_token('P_API_NAME',l_api_name);
7067: FND_MSG_PUB.add;
7068: End;
7069:

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

7062: When OTHERS Then
7063: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7064: fnd_message.set_token('P_SQLCODE',SQLCODE);
7065: fnd_message.set_token('P_SQLERRM',SQLERRM);
7066: fnd_message.set_token('P_API_NAME',l_api_name);
7067: FND_MSG_PUB.add;
7068: End;
7069:
7070: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

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

7101: ) THEN
7102:
7103: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7104: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7105: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7106: fnd_msg_pub.add;
7107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7108: RAISE fnd_api.g_exc_error;
7109: ELSE

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

7129: );
7130:
7131: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7132: -- Execution Error from call to Assignment Manager Workflow Hook
7133: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7134: fnd_msg_pub.add;
7135: RAISE fnd_api.g_exc_error;
7136: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7137: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

7134: fnd_msg_pub.add;
7135: RAISE fnd_api.g_exc_error;
7136: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7137: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7138: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7139: fnd_msg_pub.add;
7140: RAISE fnd_api.g_exc_unexpected_error;
7141: END IF;
7142:

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

7176: p_data => x_msg_data
7177: );
7178:
7179: WHEN OTHERS THEN
7180: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7181: fnd_message.set_token('P_SQLCODE',SQLCODE);
7182: fnd_message.set_token('P_SQLERRM',SQLERRM);
7183: fnd_message.set_token('P_API_NAME',l_api_name);
7184: FND_MSG_PUB.add;

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

7177: );
7178:
7179: WHEN OTHERS THEN
7180: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7181: fnd_message.set_token('P_SQLCODE',SQLCODE);
7182: fnd_message.set_token('P_SQLERRM',SQLERRM);
7183: fnd_message.set_token('P_API_NAME',l_api_name);
7184: FND_MSG_PUB.add;
7185:

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

7178:
7179: WHEN OTHERS THEN
7180: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7181: fnd_message.set_token('P_SQLCODE',SQLCODE);
7182: fnd_message.set_token('P_SQLERRM',SQLERRM);
7183: fnd_message.set_token('P_API_NAME',l_api_name);
7184: FND_MSG_PUB.add;
7185:
7186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

7179: WHEN OTHERS THEN
7180: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7181: fnd_message.set_token('P_SQLCODE',SQLCODE);
7182: fnd_message.set_token('P_SQLERRM',SQLERRM);
7183: fnd_message.set_token('P_API_NAME',l_api_name);
7184: FND_MSG_PUB.add;
7185:
7186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7187: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

7463: l_api_name := l_api_name_1;
7464:
7465: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7466: -- Unexpected Execution Error from call to Territory Manager
7467: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7468: fnd_msg_pub.add;
7469: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7470: RAISE fnd_api.g_exc_error;
7471: ELSE

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

7558: l_api_name := l_api_name_1;
7559:
7560: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7561: -- Unexpected Execution Error from call to Get_contracts_resources
7562: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7563: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7564: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7565: fnd_msg_pub.add;
7566: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

7559:
7560: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7561: -- Unexpected Execution Error from call to Get_contracts_resources
7562: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7563: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7564: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7565: fnd_msg_pub.add;
7566: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7567: RAISE fnd_api.g_exc_error;

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

7560: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7561: -- Unexpected Execution Error from call to Get_contracts_resources
7562: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7563: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7564: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7565: fnd_msg_pub.add;
7566: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7567: RAISE fnd_api.g_exc_error;
7568: ELSE

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

7572: end if; -- if p_calendar_flag = Y
7573:
7574: IF ( p_calendar_flag = 'Y' AND
7575: x_assign_resources_tbl.count = 0 ) THEN
7576: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
7577: fnd_msg_pub.add;
7578: -- RAISE fnd_api.g_exc_error;
7579: END IF;
7580:

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

7601:
7602: END IF; -- end of auto select flag
7603:
7604: ELSE -- No resources returned from the Territory API
7605: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7606: fnd_msg_pub.add;
7607: -- RAISE fnd_api.g_exc_error;
7608: END IF;
7609:

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

7607: -- RAISE fnd_api.g_exc_error;
7608: END IF;
7609:
7610: ELSE -- Territory Flag is NO
7611: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7612: fnd_msg_pub.add;
7613: -- RAISE fnd_api.g_exc_error;
7614: END IF;
7615:

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

7635:
7636:
7637: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7638: -- Unexpected Execution Error from call to assign_sr_resource
7639: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7640: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7641: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7642: fnd_msg_pub.add;
7643:

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

7636:
7637: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7638: -- Unexpected Execution Error from call to assign_sr_resource
7639: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7640: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7641: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7642: fnd_msg_pub.add;
7643:
7644: ELSE

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

7637: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
7638: -- Unexpected Execution Error from call to assign_sr_resource
7639: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7640: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7641: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7642: fnd_msg_pub.add;
7643:
7644: ELSE
7645: x_assign_resources_tbl.delete;

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

7648:
7649:
7650: Exception
7651: When OTHERS Then
7652: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7653: fnd_message.set_token('P_SQLCODE',SQLCODE);
7654: fnd_message.set_token('P_SQLERRM',SQLERRM);
7655: fnd_message.set_token('P_API_NAME',l_api_name);
7656: FND_MSG_PUB.add;

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

7649:
7650: Exception
7651: When OTHERS Then
7652: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7653: fnd_message.set_token('P_SQLCODE',SQLCODE);
7654: fnd_message.set_token('P_SQLERRM',SQLERRM);
7655: fnd_message.set_token('P_API_NAME',l_api_name);
7656: FND_MSG_PUB.add;
7657: End;

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

7650: Exception
7651: When OTHERS Then
7652: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7653: fnd_message.set_token('P_SQLCODE',SQLCODE);
7654: fnd_message.set_token('P_SQLERRM',SQLERRM);
7655: fnd_message.set_token('P_API_NAME',l_api_name);
7656: FND_MSG_PUB.add;
7657: End;
7658:

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

7651: When OTHERS Then
7652: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7653: fnd_message.set_token('P_SQLCODE',SQLCODE);
7654: fnd_message.set_token('P_SQLERRM',SQLERRM);
7655: fnd_message.set_token('P_API_NAME',l_api_name);
7656: FND_MSG_PUB.add;
7657: End;
7658:
7659: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

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

7689: ) THEN
7690:
7691: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7692: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7693: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7694: fnd_msg_pub.add;
7695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7696: RAISE fnd_api.g_exc_error;
7697: ELSE

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

7717: );
7718:
7719: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7720: -- Execution Error from call to Assignment Manager Workflow Hook
7721: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7722: fnd_msg_pub.add;
7723: RAISE fnd_api.g_exc_error;
7724: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7725: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

7722: fnd_msg_pub.add;
7723: RAISE fnd_api.g_exc_error;
7724: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7725: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7726: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7727: fnd_msg_pub.add;
7728: RAISE fnd_api.g_exc_unexpected_error;
7729: END IF;
7730:

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

7763: p_data => x_msg_data
7764: );
7765:
7766: WHEN OTHERS THEN
7767: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7768: fnd_message.set_token('P_SQLCODE',SQLCODE);
7769: fnd_message.set_token('P_SQLERRM',SQLERRM);
7770: fnd_message.set_token('P_API_NAME',l_api_name);
7771: FND_MSG_PUB.add;

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

7764: );
7765:
7766: WHEN OTHERS THEN
7767: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7768: fnd_message.set_token('P_SQLCODE',SQLCODE);
7769: fnd_message.set_token('P_SQLERRM',SQLERRM);
7770: fnd_message.set_token('P_API_NAME',l_api_name);
7771: FND_MSG_PUB.add;
7772:

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

7765:
7766: WHEN OTHERS THEN
7767: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7768: fnd_message.set_token('P_SQLCODE',SQLCODE);
7769: fnd_message.set_token('P_SQLERRM',SQLERRM);
7770: fnd_message.set_token('P_API_NAME',l_api_name);
7771: FND_MSG_PUB.add;
7772:
7773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

7766: WHEN OTHERS THEN
7767: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7768: fnd_message.set_token('P_SQLCODE',SQLCODE);
7769: fnd_message.set_token('P_SQLERRM',SQLERRM);
7770: fnd_message.set_token('P_API_NAME',l_api_name);
7771: FND_MSG_PUB.add;
7772:
7773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7774: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

8038: l_api_name := l_api_name_1;
8039:
8040: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8041: -- Unexpected Execution Error from call to Territory Manager
8042: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8043: fnd_msg_pub.add;
8044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8045: RAISE fnd_api.g_exc_error;
8046: ELSE

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

8111: l_api_name := l_api_name_1;
8112:
8113: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8114: -- Unexpected Execution Error from call to Calendar
8115: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
8116: fnd_msg_pub.add;
8117: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8118: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
8119: -- Removed Comment to Show error message Bug # 2919389

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

8207:
8208:
8209: IF ( p_calendar_flag = 'Y' AND
8210: x_assign_resources_tbl.count = 0 ) THEN
8211: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8212: fnd_msg_pub.add;
8213: -- RAISE fnd_api.g_exc_error;
8214: END IF;
8215:

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

8213: -- RAISE fnd_api.g_exc_error;
8214: END IF;
8215:
8216: ELSE -- No resources returned from the Territory API
8217: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8218: fnd_msg_pub.add;
8219: -- RAISE fnd_api.g_exc_error;
8220: END IF;
8221:

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

8219: -- RAISE fnd_api.g_exc_error;
8220: END IF;
8221:
8222: ELSE -- Territory Flag is NO
8223: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8224: fnd_msg_pub.add;
8225: -- RAISE fnd_api.g_exc_error;
8226: END IF;
8227:

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

8247:
8248:
8249: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8250: -- Unexpected Execution Error from call to assign_sr_resource
8251: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8252: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8253: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8254: fnd_msg_pub.add;
8255:

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

8248:
8249: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8250: -- Unexpected Execution Error from call to assign_sr_resource
8251: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8252: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8253: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8254: fnd_msg_pub.add;
8255:
8256: ELSE

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

8249: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8250: -- Unexpected Execution Error from call to assign_sr_resource
8251: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8252: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8253: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8254: fnd_msg_pub.add;
8255:
8256: ELSE
8257: x_assign_resources_tbl.delete;

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

8260:
8261:
8262: Exception
8263: When OTHERS Then
8264: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8265: fnd_message.set_token('P_SQLCODE',SQLCODE);
8266: fnd_message.set_token('P_SQLERRM',SQLERRM);
8267: fnd_message.set_token('P_API_NAME',l_api_name);
8268: FND_MSG_PUB.add;

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

8261:
8262: Exception
8263: When OTHERS Then
8264: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8265: fnd_message.set_token('P_SQLCODE',SQLCODE);
8266: fnd_message.set_token('P_SQLERRM',SQLERRM);
8267: fnd_message.set_token('P_API_NAME',l_api_name);
8268: FND_MSG_PUB.add;
8269: End;

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

8262: Exception
8263: When OTHERS Then
8264: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8265: fnd_message.set_token('P_SQLCODE',SQLCODE);
8266: fnd_message.set_token('P_SQLERRM',SQLERRM);
8267: fnd_message.set_token('P_API_NAME',l_api_name);
8268: FND_MSG_PUB.add;
8269: End;
8270:

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

8263: When OTHERS Then
8264: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8265: fnd_message.set_token('P_SQLCODE',SQLCODE);
8266: fnd_message.set_token('P_SQLERRM',SQLERRM);
8267: fnd_message.set_token('P_API_NAME',l_api_name);
8268: FND_MSG_PUB.add;
8269: End;
8270:
8271: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

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

8301: ) THEN
8302:
8303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8304: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8305: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8306: fnd_msg_pub.add;
8307: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8308: RAISE fnd_api.g_exc_error;
8309: ELSE

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

8330:
8331:
8332: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8333: -- Execution Error from call to Assignment Manager Workflow Hook
8334: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8335: fnd_msg_pub.add;
8336: RAISE fnd_api.g_exc_error;
8337: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8338: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

8335: fnd_msg_pub.add;
8336: RAISE fnd_api.g_exc_error;
8337: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8338: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8339: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8340: fnd_msg_pub.add;
8341: RAISE fnd_api.g_exc_unexpected_error;
8342: END IF;
8343:

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

8375: p_data => x_msg_data
8376: );
8377:
8378: WHEN OTHERS THEN
8379: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8380: fnd_message.set_token('P_SQLCODE',SQLCODE);
8381: fnd_message.set_token('P_SQLERRM',SQLERRM);
8382: fnd_message.set_token('P_API_NAME',l_api_name);
8383: FND_MSG_PUB.add;

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

8376: );
8377:
8378: WHEN OTHERS THEN
8379: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8380: fnd_message.set_token('P_SQLCODE',SQLCODE);
8381: fnd_message.set_token('P_SQLERRM',SQLERRM);
8382: fnd_message.set_token('P_API_NAME',l_api_name);
8383: FND_MSG_PUB.add;
8384:

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

8377:
8378: WHEN OTHERS THEN
8379: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8380: fnd_message.set_token('P_SQLCODE',SQLCODE);
8381: fnd_message.set_token('P_SQLERRM',SQLERRM);
8382: fnd_message.set_token('P_API_NAME',l_api_name);
8383: FND_MSG_PUB.add;
8384:
8385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

8378: WHEN OTHERS THEN
8379: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8380: fnd_message.set_token('P_SQLCODE',SQLCODE);
8381: fnd_message.set_token('P_SQLERRM',SQLERRM);
8382: fnd_message.set_token('P_API_NAME',l_api_name);
8383: FND_MSG_PUB.add;
8384:
8385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

8707: l_api_name := l_api_name_1;
8708:
8709: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8710: -- Unexpected Execution Error from call to Territory Manager
8711: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8712: fnd_msg_pub.add;
8713: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8714: RAISE fnd_api.g_exc_error;
8715: ELSE

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

8820: l_api_name := l_api_name_1;
8821:
8822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8823: -- Unexpected Execution Error from call to Get_contracts_resources
8824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8825: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8827: fnd_msg_pub.add;
8828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

8821:
8822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8823: -- Unexpected Execution Error from call to Get_contracts_resources
8824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8825: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8827: fnd_msg_pub.add;
8828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8829: RAISE fnd_api.g_exc_error;

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

8822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8823: -- Unexpected Execution Error from call to Get_contracts_resources
8824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8825: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8827: fnd_msg_pub.add;
8828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8829: RAISE fnd_api.g_exc_error;
8830: ELSE

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

8834: end if; -- if p_calendar_flag = Y
8835:
8836: IF ( p_calendar_flag = 'Y' AND
8837: x_assign_resources_tbl.count = 0 ) THEN
8838: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8839: fnd_msg_pub.add;
8840: -- RAISE fnd_api.g_exc_error;
8841: END IF;
8842:

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

8861: END LOOP; -- end of courrent record check
8862:
8863: END IF; -- end of auto select flag
8864: ELSE -- No resources returned from the Territory API
8865: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8866: fnd_msg_pub.add;
8867: -- RAISE fnd_api.g_exc_error;
8868: END IF;
8869:

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

8867: -- RAISE fnd_api.g_exc_error;
8868: END IF;
8869:
8870: ELSE -- Territory Flag is NO
8871: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8872: fnd_msg_pub.add;
8873: -- RAISE fnd_api.g_exc_error;
8874: END IF;
8875:

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

8894:
8895:
8896: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8897: -- Unexpected Execution Error from call to assign_sr_resource
8898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8899: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8901: fnd_msg_pub.add;
8902:

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

8895:
8896: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8897: -- Unexpected Execution Error from call to assign_sr_resource
8898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8899: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8901: fnd_msg_pub.add;
8902:
8903: ELSE

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

8896: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
8897: -- Unexpected Execution Error from call to assign_sr_resource
8898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8899: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8901: fnd_msg_pub.add;
8902:
8903: ELSE
8904: x_assign_resources_tbl.delete;

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

8907:
8908:
8909: Exception
8910: When OTHERS Then
8911: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8912: fnd_message.set_token('P_SQLCODE',SQLCODE);
8913: fnd_message.set_token('P_SQLERRM',SQLERRM);
8914: fnd_message.set_token('P_API_NAME',l_api_name);
8915: FND_MSG_PUB.add;

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

8908:
8909: Exception
8910: When OTHERS Then
8911: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8912: fnd_message.set_token('P_SQLCODE',SQLCODE);
8913: fnd_message.set_token('P_SQLERRM',SQLERRM);
8914: fnd_message.set_token('P_API_NAME',l_api_name);
8915: FND_MSG_PUB.add;
8916: End;

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

8909: Exception
8910: When OTHERS Then
8911: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8912: fnd_message.set_token('P_SQLCODE',SQLCODE);
8913: fnd_message.set_token('P_SQLERRM',SQLERRM);
8914: fnd_message.set_token('P_API_NAME',l_api_name);
8915: FND_MSG_PUB.add;
8916: End;
8917:

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

8910: When OTHERS Then
8911: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8912: fnd_message.set_token('P_SQLCODE',SQLCODE);
8913: fnd_message.set_token('P_SQLERRM',SQLERRM);
8914: fnd_message.set_token('P_API_NAME',l_api_name);
8915: FND_MSG_PUB.add;
8916: End;
8917:
8918: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

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

8949: ) THEN
8950:
8951: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8952: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8953: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8954: fnd_msg_pub.add;
8955: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8956: RAISE fnd_api.g_exc_error;
8957: ELSE

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

8977: );
8978:
8979: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8980: -- Execution Error from call to Assignment Manager Workflow Hook
8981: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8982: fnd_msg_pub.add;
8983: RAISE fnd_api.g_exc_error;
8984: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8985: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

8982: fnd_msg_pub.add;
8983: RAISE fnd_api.g_exc_error;
8984: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8985: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8986: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8987: fnd_msg_pub.add;
8988: RAISE fnd_api.g_exc_unexpected_error;
8989: END IF;
8990:

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

9023: p_data => x_msg_data
9024: );
9025:
9026: WHEN OTHERS THEN
9027: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9028: fnd_message.set_token('P_SQLCODE',SQLCODE);
9029: fnd_message.set_token('P_SQLERRM',SQLERRM);
9030: fnd_message.set_token('P_API_NAME',l_api_name);
9031: FND_MSG_PUB.add;

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

9024: );
9025:
9026: WHEN OTHERS THEN
9027: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9028: fnd_message.set_token('P_SQLCODE',SQLCODE);
9029: fnd_message.set_token('P_SQLERRM',SQLERRM);
9030: fnd_message.set_token('P_API_NAME',l_api_name);
9031: FND_MSG_PUB.add;
9032:

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

9025:
9026: WHEN OTHERS THEN
9027: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9028: fnd_message.set_token('P_SQLCODE',SQLCODE);
9029: fnd_message.set_token('P_SQLERRM',SQLERRM);
9030: fnd_message.set_token('P_API_NAME',l_api_name);
9031: FND_MSG_PUB.add;
9032:
9033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

9026: WHEN OTHERS THEN
9027: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9028: fnd_message.set_token('P_SQLCODE',SQLCODE);
9029: fnd_message.set_token('P_SQLERRM',SQLERRM);
9030: fnd_message.set_token('P_API_NAME',l_api_name);
9031: FND_MSG_PUB.add;
9032:
9033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9034: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

9257: l_api_name := l_api_name_1;
9258:
9259: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9260: -- Unexpected Execution Error from call to Territory Manager
9261: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9262: fnd_msg_pub.add;
9263: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9264: RAISE fnd_api.g_exc_error;
9265: ELSE

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

9267: END IF;
9268: END IF;
9269:
9270: ELSE -- Territory Flag is NO
9271: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9272: fnd_msg_pub.add;
9273: -- RAISE fnd_api.g_exc_error;
9274: END IF;
9275:

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

9371: l_api_name := l_api_name_1;
9372:
9373: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9374: -- Unexpected Execution Error from call to Get_contracts_resources
9375: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9376: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9377: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9378: fnd_msg_pub.add;
9379: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

9372:
9373: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9374: -- Unexpected Execution Error from call to Get_contracts_resources
9375: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9376: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9377: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9378: fnd_msg_pub.add;
9379: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9380: RAISE fnd_api.g_exc_error;

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

9373: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9374: -- Unexpected Execution Error from call to Get_contracts_resources
9375: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9376: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9377: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9378: fnd_msg_pub.add;
9379: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9380: RAISE fnd_api.g_exc_error;
9381: ELSE

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

9386:
9387:
9388: IF ( p_calendar_flag = 'Y' AND
9389: x_assign_resources_tbl.count = 0 ) THEN
9390: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
9391: fnd_msg_pub.add;
9392: -- RAISE fnd_api.g_exc_error;
9393: END IF;
9394:

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

9392: -- RAISE fnd_api.g_exc_error;
9393: END IF;
9394:
9395: ELSE -- No resources returned from the Territory API
9396: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9397: fnd_msg_pub.add;
9398: -- RAISE fnd_api.g_exc_error;
9399: END IF;
9400:

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

9426: p_data => x_msg_data
9427: );
9428:
9429: WHEN OTHERS THEN
9430: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9431: fnd_message.set_token('P_SQLCODE',SQLCODE);
9432: fnd_message.set_token('P_SQLERRM',SQLERRM);
9433: fnd_message.set_token('P_API_NAME',l_api_name);
9434: FND_MSG_PUB.add;

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

9427: );
9428:
9429: WHEN OTHERS THEN
9430: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9431: fnd_message.set_token('P_SQLCODE',SQLCODE);
9432: fnd_message.set_token('P_SQLERRM',SQLERRM);
9433: fnd_message.set_token('P_API_NAME',l_api_name);
9434: FND_MSG_PUB.add;
9435:

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

9428:
9429: WHEN OTHERS THEN
9430: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9431: fnd_message.set_token('P_SQLCODE',SQLCODE);
9432: fnd_message.set_token('P_SQLERRM',SQLERRM);
9433: fnd_message.set_token('P_API_NAME',l_api_name);
9434: FND_MSG_PUB.add;
9435:
9436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

9429: WHEN OTHERS THEN
9430: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9431: fnd_message.set_token('P_SQLCODE',SQLCODE);
9432: fnd_message.set_token('P_SQLERRM',SQLERRM);
9433: fnd_message.set_token('P_API_NAME',l_api_name);
9434: FND_MSG_PUB.add;
9435:
9436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

9718: /*
9719: OPEN cur_esc_id;
9720: FETCH cur_esc_id INTO l_cur_esc_id;
9721: IF ( cur_esc_id%NOTFOUND ) THEN
9722: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9723: fnd_msg_pub.add;
9724: RAISE fnd_api.g_exc_error;
9725: ELSE
9726: l_esc_source_code := l_cur_esc_id.source_object_type_code;

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

9733: CLOSE cur_esc_id;
9734:
9735:
9736: IF ( l_esc_source_code <> 'ESC' ) THEN
9737: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9738: fnd_msg_pub.add;
9739: RAISE fnd_api.g_exc_error;
9740: ELSE
9741: OPEN cur_reference_code;

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

9740: ELSE
9741: OPEN cur_reference_code;
9742: FETCH cur_reference_code INTO l_cur_reference_code;
9743: IF ( cur_reference_code%NOTFOUND) THEN
9744: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9745: fnd_msg_pub.add;
9746: RAISE fnd_api.g_exc_error;
9747: ELSE
9748: l_reference_code := l_cur_reference_code.reference_code;

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

9749: l_object_type_code := l_cur_reference_code.object_type_code;
9750: l_object_id := l_cur_reference_code.object_id;
9751:
9752: IF ( l_reference_code <> 'ESC' ) THEN
9753: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_REF');
9754: fnd_msg_pub.add;
9755: RAISE fnd_api.g_exc_error;
9756: END IF;
9757: END IF;

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

9838: OPEN cur_source_task;
9839: FETCH cur_source_task INTO l_territory_id;
9840:
9841: IF ( cur_source_task%NOTFOUND ) THEN
9842: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
9843: fnd_msg_pub.add;
9844: RAISE fnd_api.g_exc_error;
9845: END IF;
9846:

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

9859: OPEN cur_source_sr FOR l_dynamic_sql USING l_object_id;
9860: FETCH cur_source_sr INTO l_territory_id;
9861:
9862: IF ( cur_source_sr%NOTFOUND ) THEN
9863: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
9864: fnd_msg_pub.add;
9865: RAISE fnd_api.g_exc_error;
9866: END IF;
9867:

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

9883: OPEN cur_source_defect FOR l_dynamic_sql USING l_object_id;
9884: FETCH cur_source_defect INTO l_territory_id;
9885:
9886: IF ( cur_source_defect%NOTFOUND ) THEN
9887: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DEFECT_ID');
9888: fnd_msg_pub.add;
9889: RAISE fnd_api.g_exc_error;
9890: END IF;
9891:

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

9921:
9922:
9923: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9924: -- Unexpected Execution Error from call to Territory Manager
9925: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9926: fnd_msg_pub.add;
9927: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9928: RAISE fnd_api.g_exc_error;
9929: ELSE

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

9955: l_api_name := l_api_name_1;
9956:
9957: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9958: -- Unexpected Execution Error from call to Territory Manager
9959: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9960: fnd_msg_pub.add;
9961: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9962: RAISE fnd_api.g_exc_error;
9963: ELSE

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

9965: END IF;
9966: END IF;
9967:
9968: --ELSE
9969: --fnd_message.set_name('JTF', 'JTF_AM_NO_ESC_TERR');
9970: --fnd_msg_pub.add;
9971: --RAISE fnd_api.g_exc_error;
9972: END IF;
9973:

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

9996: l_api_name := l_api_name_1;
9997:
9998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9999: -- Unexpected Execution Error from call to Territory Manager
10000: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10001: fnd_msg_pub.add;
10002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10003: RAISE fnd_api.g_exc_error;
10004: ELSE

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

10110: l_api_name := l_api_name_1;
10111:
10112: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10113: -- Unexpected Execution Error from call to Get_contracts_resources
10114: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10115: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10116: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10117: fnd_msg_pub.add;
10118: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

10111:
10112: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10113: -- Unexpected Execution Error from call to Get_contracts_resources
10114: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10115: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10116: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10117: fnd_msg_pub.add;
10118: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10119: RAISE fnd_api.g_exc_error;

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

10112: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10113: -- Unexpected Execution Error from call to Get_contracts_resources
10114: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10115: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10116: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10117: fnd_msg_pub.add;
10118: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10119: RAISE fnd_api.g_exc_error;
10120: ELSE

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

10124: -- end if; -- if p_calendar_flag = Y
10125:
10126: IF ( p_calendar_flag = 'Y' AND
10127: x_assign_resources_tbl.count = 0 ) THEN
10128: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
10129: fnd_msg_pub.add;
10130: -- RAISE fnd_api.g_exc_error;
10131: END IF;
10132:

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

10152:
10153: END IF; -- end of auto select flag
10154:
10155: ELSE -- No resources returned from the Territory API
10156: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10157: fnd_msg_pub.add;
10158: -- RAISE fnd_api.g_exc_error;
10159: END IF;
10160:

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

10158: -- RAISE fnd_api.g_exc_error;
10159: END IF;
10160:
10161: ELSE -- Territory Flag is NO
10162: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10163: fnd_msg_pub.add;
10164: -- RAISE fnd_api.g_exc_error;
10165: END IF;
10166:

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

10190: l_api_name := l_api_name_1;
10191:
10192: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10193: -- Unexpected Execution Error from call to Territory Manager
10194: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10195: fnd_msg_pub.add;
10196: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10197: RAISE fnd_api.g_exc_error;
10198: ELSE

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

10253:
10254: END LOOP;
10255:
10256: ELSE -- l_assign_resources_tbl.COUNT <= 0
10257: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10258: fnd_msg_pub.add;
10259: -- RAISE fnd_api.g_exc_error;
10260: END IF;
10261:

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

10260: END IF;
10261:
10262:
10263: /*
10264: fnd_message.set_name('JTF', 'JTF_AM_EMPTY_ESC_TBL');
10265: fnd_msg_pub.add;
10266: RAISE fnd_api.g_exc_error;
10267: */
10268:

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

10384:
10385:
10386: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10387: -- Unexpected Execution Error from call to assign_sr_resource
10388: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10389: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10390: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10391: fnd_msg_pub.add;
10392: ELSE

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

10385:
10386: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10387: -- Unexpected Execution Error from call to assign_sr_resource
10388: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10389: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10390: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10391: fnd_msg_pub.add;
10392: ELSE
10393: x_assign_resources_tbl.delete;

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

10386: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10387: -- Unexpected Execution Error from call to assign_sr_resource
10388: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10389: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10390: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10391: fnd_msg_pub.add;
10392: ELSE
10393: x_assign_resources_tbl.delete;
10394: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

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

10414:
10415:
10416: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10417: -- Unexpected Execution Error from call to assign_sr_resource
10418: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10419: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10420: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10421: fnd_msg_pub.add;
10422: ELSE

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

10415:
10416: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10417: -- Unexpected Execution Error from call to assign_sr_resource
10418: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10419: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10420: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10421: fnd_msg_pub.add;
10422: ELSE
10423: x_assign_resources_tbl.delete;

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

10416: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10417: -- Unexpected Execution Error from call to assign_sr_resource
10418: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10419: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10420: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10421: fnd_msg_pub.add;
10422: ELSE
10423: x_assign_resources_tbl.delete;
10424: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

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

10427: END IF;
10428:
10429: Exception
10430: When OTHERS Then
10431: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10432: fnd_message.set_token('P_SQLCODE',SQLCODE);
10433: fnd_message.set_token('P_SQLERRM',SQLERRM);
10434: fnd_message.set_token('P_API_NAME',l_api_name);
10435: FND_MSG_PUB.add;

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

10428:
10429: Exception
10430: When OTHERS Then
10431: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10432: fnd_message.set_token('P_SQLCODE',SQLCODE);
10433: fnd_message.set_token('P_SQLERRM',SQLERRM);
10434: fnd_message.set_token('P_API_NAME',l_api_name);
10435: FND_MSG_PUB.add;
10436: End;

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

10429: Exception
10430: When OTHERS Then
10431: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10432: fnd_message.set_token('P_SQLCODE',SQLCODE);
10433: fnd_message.set_token('P_SQLERRM',SQLERRM);
10434: fnd_message.set_token('P_API_NAME',l_api_name);
10435: FND_MSG_PUB.add;
10436: End;
10437:

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

10430: When OTHERS Then
10431: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10432: fnd_message.set_token('P_SQLCODE',SQLCODE);
10433: fnd_message.set_token('P_SQLERRM',SQLERRM);
10434: fnd_message.set_token('P_API_NAME',l_api_name);
10435: FND_MSG_PUB.add;
10436: End;
10437:
10438: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/

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

10471: ) THEN
10472:
10473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10474: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10475: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10476: fnd_msg_pub.add;
10477: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10478: RAISE fnd_api.g_exc_error;
10479: ELSE

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

10501:
10502:
10503: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
10504: -- Execution Error from call to Assignment Manager Workflow Hook
10505: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10506: fnd_msg_pub.add;
10507: RAISE fnd_api.g_exc_error;
10508: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10509: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

10506: fnd_msg_pub.add;
10507: RAISE fnd_api.g_exc_error;
10508: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10509: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10510: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10511: fnd_msg_pub.add;
10512: RAISE fnd_api.g_exc_unexpected_error;
10513: END IF;
10514:

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

10546: p_data => x_msg_data
10547: );
10548:
10549: WHEN OTHERS THEN
10550: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10551: fnd_message.set_token('P_SQLCODE',SQLCODE);
10552: fnd_message.set_token('P_SQLERRM',SQLERRM);
10553: fnd_message.set_token('P_API_NAME',l_api_name);
10554: FND_MSG_PUB.add;

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

10547: );
10548:
10549: WHEN OTHERS THEN
10550: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10551: fnd_message.set_token('P_SQLCODE',SQLCODE);
10552: fnd_message.set_token('P_SQLERRM',SQLERRM);
10553: fnd_message.set_token('P_API_NAME',l_api_name);
10554: FND_MSG_PUB.add;
10555:

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

10548:
10549: WHEN OTHERS THEN
10550: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10551: fnd_message.set_token('P_SQLCODE',SQLCODE);
10552: fnd_message.set_token('P_SQLERRM',SQLERRM);
10553: fnd_message.set_token('P_API_NAME',l_api_name);
10554: FND_MSG_PUB.add;
10555:
10556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

10549: WHEN OTHERS THEN
10550: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10551: fnd_message.set_token('P_SQLCODE',SQLCODE);
10552: fnd_message.set_token('P_SQLERRM',SQLERRM);
10553: fnd_message.set_token('P_API_NAME',l_api_name);
10554: FND_MSG_PUB.add;
10555:
10556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10557: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

10864: IF (p_resource_type IS NOT NULL) THEN
10865: OPEN cur_resource_type;
10866: FETCH cur_resource_type INTO l_cur_resource_type;
10867: IF ( cur_resource_type%NOTFOUND) THEN
10868: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
10869: fnd_msg_pub.add;
10870: RAISE fnd_api.g_exc_error;
10871: END IF;
10872: CLOSE cur_resource_type;

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

10877: IF (p_effort_uom IS NOT NULL) THEN
10878: OPEN cur_effort_uom;
10879: FETCH cur_effort_uom INTO l_cur_effort_uom;
10880: IF ( cur_effort_uom%NOTFOUND) THEN
10881: fnd_message.set_name('JTF', 'JTF_AM_INVALID_EFFORT_UOM');
10882: fnd_msg_pub.add;
10883: RAISE fnd_api.g_exc_error;
10884: END IF;
10885: CLOSE cur_effort_uom;

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

11225: 'DEF'
11226: )
11227: ) THEN
11228:
11229: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DOC_TYPE');
11230: fnd_msg_pub.add;
11231: RAISE fnd_api.g_exc_error;
11232:
11233: END IF;

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

11275: --Added for Bug # 5573916 Ends here
11276: );
11277:
11278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11279: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11280: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11281: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11282: fnd_msg_pub.add;
11283: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

11276: );
11277:
11278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11279: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11280: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11281: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11282: fnd_msg_pub.add;
11283: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11284: RAISE fnd_api.g_exc_error;

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

11277:
11278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11279: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11280: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11281: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11282: fnd_msg_pub.add;
11283: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11284: RAISE fnd_api.g_exc_error;
11285: ELSE

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

11436: END IF; -- Auto Select Flag
11437:
11438: ELSE
11439: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
11440: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11441: fnd_msg_pub.add;
11442: -- RAISE fnd_api.g_exc_error;
11443: END IF;
11444:

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

11472:
11473:
11474: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11475: -- Unexpected Execution Error from call to assign_sr_resource
11476: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11477: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11478: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11479: fnd_msg_pub.add;
11480: /* Not raising the errors as req by tele service team

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

11473:
11474: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11475: -- Unexpected Execution Error from call to assign_sr_resource
11476: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11477: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11478: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11479: fnd_msg_pub.add;
11480: /* Not raising the errors as req by tele service team
11481: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

11474: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11475: -- Unexpected Execution Error from call to assign_sr_resource
11476: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11477: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11478: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11479: fnd_msg_pub.add;
11480: /* Not raising the errors as req by tele service team
11481: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11482: RAISE fnd_api.g_exc_error;

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

11490:
11491:
11492: exception
11493: when others then
11494: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11495: fnd_message.set_token('P_SQLCODE',SQLCODE);
11496: fnd_message.set_token('P_SQLERRM',SQLERRM);
11497: fnd_message.set_token('P_API_NAME',l_api_name);
11498: FND_MSG_PUB.add;

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

11491:
11492: exception
11493: when others then
11494: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11495: fnd_message.set_token('P_SQLCODE',SQLCODE);
11496: fnd_message.set_token('P_SQLERRM',SQLERRM);
11497: fnd_message.set_token('P_API_NAME',l_api_name);
11498: FND_MSG_PUB.add;
11499: end;

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

11492: exception
11493: when others then
11494: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11495: fnd_message.set_token('P_SQLCODE',SQLCODE);
11496: fnd_message.set_token('P_SQLERRM',SQLERRM);
11497: fnd_message.set_token('P_API_NAME',l_api_name);
11498: FND_MSG_PUB.add;
11499: end;
11500:

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

11493: when others then
11494: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11495: fnd_message.set_token('P_SQLCODE',SQLCODE);
11496: fnd_message.set_token('P_SQLERRM',SQLERRM);
11497: fnd_message.set_token('P_API_NAME',l_api_name);
11498: FND_MSG_PUB.add;
11499: end;
11500:
11501: -- ================code added for bug 6453896==========================

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

11548: --Added for Bug # 5573916 Ends here
11549: );
11550:
11551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11552: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11553: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11554: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11555: fnd_msg_pub.add;
11556: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

11549: );
11550:
11551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11552: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11553: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11554: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11555: fnd_msg_pub.add;
11556: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11557: RAISE fnd_api.g_exc_error;

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

11550:
11551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11552: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11553: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11554: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11555: fnd_msg_pub.add;
11556: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11557: RAISE fnd_api.g_exc_error;
11558: ELSE

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

11730: END LOOP;
11731: END IF; -- Auto Select Flag
11732:
11733: ELSE -- No resources returned from the Assignment Manager API for TASKS
11734: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11735: fnd_msg_pub.add;
11736: -- RAISE fnd_api.g_exc_error;
11737: END IF;
11738:

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

11758:
11759:
11760: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11761: -- Unexpected Execution Error from call to assign_sr_resource
11762: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11763: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11764: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11765: fnd_msg_pub.add;
11766:

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

11759:
11760: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11761: -- Unexpected Execution Error from call to assign_sr_resource
11762: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11763: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11764: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11765: fnd_msg_pub.add;
11766:
11767: ELSE

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

11760: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11761: -- Unexpected Execution Error from call to assign_sr_resource
11762: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11763: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11764: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11765: fnd_msg_pub.add;
11766:
11767: ELSE
11768: x_assign_resources_tbl.delete;

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

11770: END IF;
11771:
11772: Exception
11773: When OTHERS Then
11774: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11775: fnd_message.set_token('P_SQLCODE',SQLCODE);
11776: fnd_message.set_token('P_SQLERRM',SQLERRM);
11777: fnd_message.set_token('P_API_NAME',l_api_name);
11778: FND_MSG_PUB.add;

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

11771:
11772: Exception
11773: When OTHERS Then
11774: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11775: fnd_message.set_token('P_SQLCODE',SQLCODE);
11776: fnd_message.set_token('P_SQLERRM',SQLERRM);
11777: fnd_message.set_token('P_API_NAME',l_api_name);
11778: FND_MSG_PUB.add;
11779: End;

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

11772: Exception
11773: When OTHERS Then
11774: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11775: fnd_message.set_token('P_SQLCODE',SQLCODE);
11776: fnd_message.set_token('P_SQLERRM',SQLERRM);
11777: fnd_message.set_token('P_API_NAME',l_api_name);
11778: FND_MSG_PUB.add;
11779: End;
11780:

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

11773: When OTHERS Then
11774: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11775: fnd_message.set_token('P_SQLCODE',SQLCODE);
11776: fnd_message.set_token('P_SQLERRM',SQLERRM);
11777: fnd_message.set_token('P_API_NAME',l_api_name);
11778: FND_MSG_PUB.add;
11779: End;
11780:
11781: -- ================code added for bug 6453896==========================

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

11820: x_msg_data => x_msg_data
11821: );
11822:
11823: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11825: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11827: fnd_msg_pub.add;
11828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

11821: );
11822:
11823: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11825: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11827: fnd_msg_pub.add;
11828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11829: RAISE fnd_api.g_exc_error;

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

11822:
11823: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11825: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11827: fnd_msg_pub.add;
11828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11829: RAISE fnd_api.g_exc_error;
11830: ELSE

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

11910: l_current_record := l_assign_resources_tbl.NEXT(l_current_record);
11911: END LOOP;
11912:
11913: ELSE -- No resources returned from the Assignment Manager API for DEFECTS
11914: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11915: fnd_msg_pub.add;
11916: -- RAISE fnd_api.g_exc_error;
11917: END IF;
11918:

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

11938:
11939:
11940: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11941: -- Unexpected Execution Error from call to assign_sr_resource
11942: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11943: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11944: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11945: fnd_msg_pub.add;
11946:

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

11939:
11940: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11941: -- Unexpected Execution Error from call to assign_sr_resource
11942: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11943: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11944: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11945: fnd_msg_pub.add;
11946:
11947: ELSE

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

11940: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11941: -- Unexpected Execution Error from call to assign_sr_resource
11942: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11943: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11944: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11945: fnd_msg_pub.add;
11946:
11947: ELSE
11948: x_assign_resources_tbl.delete;

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

11951:
11952:
11953: Exception
11954: When OTHERS Then
11955: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11956: fnd_message.set_token('P_SQLCODE',SQLCODE);
11957: fnd_message.set_token('P_SQLERRM',SQLERRM);
11958: fnd_message.set_token('P_API_NAME',l_api_name);
11959: FND_MSG_PUB.add;

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

11952:
11953: Exception
11954: When OTHERS Then
11955: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11956: fnd_message.set_token('P_SQLCODE',SQLCODE);
11957: fnd_message.set_token('P_SQLERRM',SQLERRM);
11958: fnd_message.set_token('P_API_NAME',l_api_name);
11959: FND_MSG_PUB.add;
11960: End;

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

11953: Exception
11954: When OTHERS Then
11955: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11956: fnd_message.set_token('P_SQLCODE',SQLCODE);
11957: fnd_message.set_token('P_SQLERRM',SQLERRM);
11958: fnd_message.set_token('P_API_NAME',l_api_name);
11959: FND_MSG_PUB.add;
11960: End;
11961:

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

11954: When OTHERS Then
11955: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11956: fnd_message.set_token('P_SQLCODE',SQLCODE);
11957: fnd_message.set_token('P_SQLERRM',SQLERRM);
11958: fnd_message.set_token('P_API_NAME',l_api_name);
11959: FND_MSG_PUB.add;
11960: End;
11961:
11962:

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

11991:
11992:
11993: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11994: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11995: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11996: fnd_msg_pub.add;
11997: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11998: RAISE fnd_api.g_exc_error;
11999: ELSE

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

12021:
12022:
12023: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
12024: -- Execution Error from call to Assignment Manager Workflow Hook
12025: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
12026: fnd_msg_pub.add;
12027: RAISE fnd_api.g_exc_error;
12028: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
12029: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook

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

12026: fnd_msg_pub.add;
12027: RAISE fnd_api.g_exc_error;
12028: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
12029: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
12030: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
12031: fnd_msg_pub.add;
12032: RAISE fnd_api.g_exc_unexpected_error;
12033: END IF;
12034:

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

12068: p_data => x_msg_data
12069: );
12070:
12071: WHEN OTHERS THEN
12072: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12073: fnd_message.set_token('P_SQLCODE',SQLCODE);
12074: fnd_message.set_token('P_SQLERRM',SQLERRM);
12075: fnd_message.set_token('P_API_NAME',l_api_name);
12076: FND_MSG_PUB.add;

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

12069: );
12070:
12071: WHEN OTHERS THEN
12072: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12073: fnd_message.set_token('P_SQLCODE',SQLCODE);
12074: fnd_message.set_token('P_SQLERRM',SQLERRM);
12075: fnd_message.set_token('P_API_NAME',l_api_name);
12076: FND_MSG_PUB.add;
12077:

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

12070:
12071: WHEN OTHERS THEN
12072: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12073: fnd_message.set_token('P_SQLCODE',SQLCODE);
12074: fnd_message.set_token('P_SQLERRM',SQLERRM);
12075: fnd_message.set_token('P_API_NAME',l_api_name);
12076: FND_MSG_PUB.add;
12077:
12078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

12071: WHEN OTHERS THEN
12072: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12073: fnd_message.set_token('P_SQLCODE',SQLCODE);
12074: fnd_message.set_token('P_SQLERRM',SQLERRM);
12075: fnd_message.set_token('P_API_NAME',l_api_name);
12076: FND_MSG_PUB.add;
12077:
12078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12079: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

12292: );
12293:
12294: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12295: -- Unexpected Execution Error from call to Get_contracts_resources
12296: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12297: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12298: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12299: fnd_msg_pub.add;
12300: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

12293:
12294: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12295: -- Unexpected Execution Error from call to Get_contracts_resources
12296: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12297: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12298: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12299: fnd_msg_pub.add;
12300: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12301: RAISE fnd_api.g_exc_error;

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

12294: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12295: -- Unexpected Execution Error from call to Get_contracts_resources
12296: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12297: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12298: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12299: fnd_msg_pub.add;
12300: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12301: RAISE fnd_api.g_exc_error;
12302: ELSE

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

12326: );
12327:
12328: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12329: -- Unexpected Execution Error from call to Get_contracts_resources
12330: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12331: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12332: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12333: fnd_msg_pub.add;
12334: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

12327:
12328: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12329: -- Unexpected Execution Error from call to Get_contracts_resources
12330: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12331: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12332: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12333: fnd_msg_pub.add;
12334: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12335: RAISE fnd_api.g_exc_error;

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

12328: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12329: -- Unexpected Execution Error from call to Get_contracts_resources
12330: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12331: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12332: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12333: fnd_msg_pub.add;
12334: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12335: RAISE fnd_api.g_exc_error;
12336: ELSE

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

12361: p_data => x_msg_data
12362: );
12363:
12364: WHEN OTHERS THEN
12365: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12366: fnd_message.set_token('P_SQLCODE',SQLCODE);
12367: fnd_message.set_token('P_SQLERRM',SQLERRM);
12368: fnd_message.set_token('P_API_NAME',l_api_name);
12369: FND_MSG_PUB.add;

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

12362: );
12363:
12364: WHEN OTHERS THEN
12365: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12366: fnd_message.set_token('P_SQLCODE',SQLCODE);
12367: fnd_message.set_token('P_SQLERRM',SQLERRM);
12368: fnd_message.set_token('P_API_NAME',l_api_name);
12369: FND_MSG_PUB.add;
12370:

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

12363:
12364: WHEN OTHERS THEN
12365: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12366: fnd_message.set_token('P_SQLCODE',SQLCODE);
12367: fnd_message.set_token('P_SQLERRM',SQLERRM);
12368: fnd_message.set_token('P_API_NAME',l_api_name);
12369: FND_MSG_PUB.add;
12370:
12371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

12364: WHEN OTHERS THEN
12365: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12366: fnd_message.set_token('P_SQLCODE',SQLCODE);
12367: fnd_message.set_token('P_SQLERRM',SQLERRM);
12368: fnd_message.set_token('P_API_NAME',l_api_name);
12369: FND_MSG_PUB.add;
12370:
12371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12372: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

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

12453: l_api_name := l_api_name_1;
12454:
12455: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12456: -- Unexpected Execution Error from call to Get_contracts_resources
12457: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12458: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12459: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12460: fnd_msg_pub.add;
12461: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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

12454:
12455: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12456: -- Unexpected Execution Error from call to Get_contracts_resources
12457: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12458: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12459: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12460: fnd_msg_pub.add;
12461: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12462: RAISE fnd_api.g_exc_error;

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

12455: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12456: -- Unexpected Execution Error from call to Get_contracts_resources
12457: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12458: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12459: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12460: fnd_msg_pub.add;
12461: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12462: RAISE fnd_api.g_exc_error;
12463: ELSE

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

12485: p_data => x_msg_data
12486: );
12487:
12488: WHEN OTHERS THEN
12489: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12490: fnd_message.set_token('P_SQLCODE',SQLCODE);
12491: fnd_message.set_token('P_SQLERRM',SQLERRM);
12492: fnd_message.set_token('P_API_NAME',l_api_name);
12493: FND_MSG_PUB.add;

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

12486: );
12487:
12488: WHEN OTHERS THEN
12489: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12490: fnd_message.set_token('P_SQLCODE',SQLCODE);
12491: fnd_message.set_token('P_SQLERRM',SQLERRM);
12492: fnd_message.set_token('P_API_NAME',l_api_name);
12493: FND_MSG_PUB.add;
12494:

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

12487:
12488: WHEN OTHERS THEN
12489: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12490: fnd_message.set_token('P_SQLCODE',SQLCODE);
12491: fnd_message.set_token('P_SQLERRM',SQLERRM);
12492: fnd_message.set_token('P_API_NAME',l_api_name);
12493: FND_MSG_PUB.add;
12494:
12495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

12488: WHEN OTHERS THEN
12489: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12490: fnd_message.set_token('P_SQLCODE',SQLCODE);
12491: fnd_message.set_token('P_SQLERRM',SQLERRM);
12492: fnd_message.set_token('P_API_NAME',l_api_name);
12493: FND_MSG_PUB.add;
12494:
12495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12496: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN