[Home] [Help]
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
1009: RAISE fnd_api.g_exc_error;
1075:
1076: EXCEPTION
1077: WHEN FND_API.G_EXC_ERROR THEN
1078: x_return_status := FND_API.G_RET_STS_ERROR ;
1079: FND_MSG_PUB.Count_And_Get
1080: (
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1083: );
1084:
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1087: FND_MSG_PUB.Count_And_Get
1088: (
1089: p_count => x_msg_count,
1090: p_data => x_msg_data
1091: );
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
1102: FND_MSG_PUB.Add_Exc_Msg
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
1102: FND_MSG_PUB.Add_Exc_Msg
1103: (
1104: G_PKG_NAME,
1105: 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
1102: FND_MSG_PUB.Add_Exc_Msg
1103: (
1104: G_PKG_NAME,
1105: l_api_name
1106: );
1105: l_api_name
1106: );
1107: END IF;
1108:
1109: FND_MSG_PUB.Count_And_Get
1110: (
1111: p_count => x_msg_count,
1112: p_data => x_msg_data
1113: );
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 **
1345: -- Removed Comment to Show error message Bug # 2919389
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
1520: RAISE fnd_api.g_exc_error;
1622:
1623: EXCEPTION
1624: WHEN FND_API.G_EXC_ERROR THEN
1625: x_return_status := FND_API.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get
1627: (
1628: p_count => x_msg_count,
1629: p_data => x_msg_data
1630: );
1630: );
1631:
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1634: FND_MSG_PUB.Count_And_Get
1635: (
1636: p_count => x_msg_count,
1637: p_data => x_msg_data
1638: );
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
1649: FND_MSG_PUB.Add_Exc_Msg
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
1649: FND_MSG_PUB.Add_Exc_Msg
1650: (
1651: G_PKG_NAME,
1652: 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
1649: FND_MSG_PUB.Add_Exc_Msg
1650: (
1651: G_PKG_NAME,
1652: l_api_name
1653: );
1652: l_api_name
1653: );
1654: END IF;
1655:
1656: FND_MSG_PUB.Count_And_Get
1657: (
1658: p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
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:
1768: IF FND_INSTALLATION.GET
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
1781: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
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;
1786:
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
1843: RAISE fnd_api.g_exc_unexpected_error;
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
2052: RAISE fnd_api.g_exc_unexpected_error;
2058:
2059: EXCEPTION
2060: WHEN FND_API.G_EXC_ERROR THEN
2061: x_return_status := FND_API.G_RET_STS_ERROR ;
2062: FND_MSG_PUB.Count_And_Get
2063: (
2064: p_count => x_msg_count,
2065: p_data => x_msg_data
2066: );
2066: );
2067:
2068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070: FND_MSG_PUB.Count_And_Get
2071: (
2072: p_count => x_msg_count,
2073: p_data => x_msg_data
2074: );
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
2085: FND_MSG_PUB.Add_Exc_Msg
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
2085: FND_MSG_PUB.Add_Exc_Msg
2086: (
2087: G_PKG_NAME,
2088: 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
2085: FND_MSG_PUB.Add_Exc_Msg
2086: (
2087: G_PKG_NAME,
2088: l_api_name
2089: );
2088: l_api_name
2089: );
2090: END IF;
2091:
2092: FND_MSG_PUB.Count_And_Get
2093: (
2094: p_count => x_msg_count,
2095: p_data => x_msg_data
2096: );
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
2494: RAISE fnd_api.g_exc_unexpected_error;
2500:
2501: EXCEPTION
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: x_return_status := FND_API.G_RET_STS_ERROR ;
2504: FND_MSG_PUB.Count_And_Get
2505: (
2506: p_count => x_msg_count,
2507: p_data => x_msg_data
2508: );
2508: );
2509:
2510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2512: FND_MSG_PUB.Count_And_Get
2513: (
2514: p_count => x_msg_count,
2515: p_data => x_msg_data
2516: );
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
2527: FND_MSG_PUB.Add_Exc_Msg
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
2527: FND_MSG_PUB.Add_Exc_Msg
2528: (
2529: G_PKG_NAME,
2530: 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
2527: FND_MSG_PUB.Add_Exc_Msg
2528: (
2529: G_PKG_NAME,
2530: l_api_name
2531: );
2530: l_api_name
2531: );
2532: END IF;
2533:
2534: FND_MSG_PUB.Count_And_Get
2535: (
2536: p_count => x_msg_count,
2537: p_data => x_msg_data
2538: );
2801:
2802: /* Initialize message list if p_init_msg_list is set to TRUE */
2803:
2804: IF fnd_api.to_boolean (p_init_msg_list) THEN
2805: fnd_msg_pub.initialize;
2806: END IF;
2807:
2808: x_return_status := fnd_api.g_ret_sts_success;
2809:
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;
2827: l_task_source_id := l_cur_task_id.source_object_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';
2865: l_planned_start_date := SYSDATE;
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
2933: RAISE fnd_api.g_exc_unexpected_error;
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
2975: RAISE fnd_api.g_exc_unexpected_error;
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
3034: to get the data into the Record Type to pass it to the Territory API */
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
3090: RAISE fnd_api.g_exc_unexpected_error;
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
3195: RAISE fnd_api.g_exc_unexpected_error;
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:
3207: -- remove excluded resources
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:
3220: ELSE -- Territory Flag is NO
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:
3226: ELSE -- l_task_source_code <> 'SR'
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
3306: RAISE fnd_api.g_exc_unexpected_error;
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
3412: RAISE fnd_api.g_exc_unexpected_error;
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:
3424: ELSE -- No resources returned from the Territory API
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:
3430: ELSE -- Territory Flag is NO
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'
3442:
3532:
3533: /* Standard call to get message count and
3534: the message information */
3535:
3536: FND_MSG_PUB.Count_And_Get
3537: (
3538: p_count => x_msg_count,
3539: p_data => x_msg_data
3540: );
3543:
3544: EXCEPTION
3545: WHEN FND_API.G_EXC_ERROR THEN
3546: x_return_status := FND_API.G_RET_STS_ERROR ;
3547: FND_MSG_PUB.Count_And_Get
3548: (
3549: p_count => x_msg_count,
3550: p_data => x_msg_data
3551: );
3551: );
3552:
3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3555: FND_MSG_PUB.Count_And_Get
3556: (
3557: p_count => x_msg_count,
3558: p_data => x_msg_data
3559: );
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
3570: (
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
3570: (
3571: G_PKG_NAME,
3572: l_api_name
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
3570: (
3571: G_PKG_NAME,
3572: l_api_name
3573: );
3572: l_api_name
3573: );
3574: END IF;
3575:
3576: FND_MSG_PUB.Count_And_Get
3577: (
3578: p_count => x_msg_count,
3579: p_data => x_msg_data
3580: );
3856:
3857: /* Initialize message list if p_init_msg_list is set to TRUE */
3858:
3859: IF fnd_api.to_boolean (p_init_msg_list) THEN
3860: fnd_msg_pub.initialize;
3861: END IF;
3862:
3863:
3864: x_return_status := fnd_api.g_ret_sts_success;
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
3951: l_contract_flag := 'Y';
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
4012: RAISE fnd_api.g_exc_unexpected_error;
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
4049: RAISE fnd_api.g_exc_unexpected_error;
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
4091: RAISE fnd_api.g_exc_unexpected_error;
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
4116: RAISE fnd_api.g_exc_unexpected_error;
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
4311: RAISE fnd_api.g_exc_unexpected_error;
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
4341: (
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
4440: RAISE fnd_api.g_exc_unexpected_error;
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
4471:
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
4560: RAISE fnd_api.g_exc_unexpected_error;
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:
4573:
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
4602: RAISE fnd_api.g_exc_unexpected_error;
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:
4613:
4941:
4942: /* Standard call to get message count and
4943: the message information */
4944:
4945: FND_MSG_PUB.Count_And_Get
4946: (
4947: p_count => x_msg_count,
4948: p_data => x_msg_data
4949: );
4952:
4953: EXCEPTION
4954: WHEN FND_API.G_EXC_ERROR THEN
4955: x_return_status := FND_API.G_RET_STS_ERROR ;
4956: FND_MSG_PUB.Count_And_Get
4957: (
4958: p_count => x_msg_count,
4959: p_data => x_msg_data
4960: );
4960: );
4961:
4962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4964: FND_MSG_PUB.Count_And_Get
4965: (
4966: p_count => x_msg_count,
4967: p_data => x_msg_data
4968: );
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
4979: FND_MSG_PUB.Add_Exc_Msg
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
4979: FND_MSG_PUB.Add_Exc_Msg
4980: (
4981: G_PKG_NAME,
4982: 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
4979: FND_MSG_PUB.Add_Exc_Msg
4980: (
4981: G_PKG_NAME,
4982: l_api_name
4983: );
4982: l_api_name
4983: );
4984: END IF;
4985:
4986: FND_MSG_PUB.Count_And_Get
4987: (
4988: p_count => x_msg_count,
4989: p_data => x_msg_data
4990: );
5303:
5304: /* Initialize message list if p_init_msg_list is set to TRUE */
5305:
5306: IF fnd_api.to_boolean (p_init_msg_list) THEN
5307: fnd_msg_pub.initialize;
5308: END IF;
5309:
5310: x_return_status := fnd_api.g_ret_sts_success;
5311:
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;
5323: END IF;
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:
5543: CLOSE cur_cs_incidents;
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
5602: RAISE fnd_api.g_exc_unexpected_error;
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
5639: RAISE fnd_api.g_exc_unexpected_error;
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
5681: RAISE fnd_api.g_exc_unexpected_error;
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
5706: RAISE fnd_api.g_exc_unexpected_error;
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
5809: RAISE fnd_api.g_exc_unexpected_error;
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:
5833: IF l_winningterrmember_tbl.COUNT > 0 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
5905: RAISE fnd_api.g_exc_unexpected_error;
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:
5916: -- remove excluded resources from territory qualifeid resource list
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
5943: RAISE fnd_api.g_exc_unexpected_error;
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:
5954: -- Logic for getting resources belonging to group id passed in
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:
6337: -- Raise Workflow Event
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;
6370: END IF;
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:
6383:
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
6417: RAISE fnd_api.g_exc_unexpected_error;
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
6447: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
6452: END IF; -- End of JTF_ASSIGN_CUHK
6456:
6457: /* Standard call to get message count and
6458: the message information */
6459:
6460: FND_MSG_PUB.Count_And_Get
6461: (
6462: p_count => x_msg_count,
6463: p_data => x_msg_data
6464: );
6468:
6469: EXCEPTION
6470: WHEN FND_API.G_EXC_ERROR THEN
6471: x_return_status := FND_API.G_RET_STS_ERROR ;
6472: FND_MSG_PUB.Count_And_Get
6473: (
6474: p_count => x_msg_count,
6475: p_data => x_msg_data
6476: );
6476: );
6477:
6478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6480: FND_MSG_PUB.Count_And_Get
6481: (
6482: p_count => x_msg_count,
6483: p_data => x_msg_data
6484: );
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
6495: FND_MSG_PUB.Add_Exc_Msg
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
6495: FND_MSG_PUB.Add_Exc_Msg
6496: (
6497: G_PKG_NAME,
6498: 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
6495: FND_MSG_PUB.Add_Exc_Msg
6496: (
6497: G_PKG_NAME,
6498: l_api_name
6499: );
6498: l_api_name
6499: );
6500: END IF;
6501:
6502: FND_MSG_PUB.Count_And_Get
6503: (
6504: p_count => x_msg_count,
6505: p_data => x_msg_data
6506: );
6697:
6698: /* Initialize message list if p_init_msg_list is set to TRUE */
6699:
6700: IF fnd_api.to_boolean (p_init_msg_list) THEN
6701: fnd_msg_pub.initialize;
6702: END IF;
6703:
6704: x_return_status := fnd_api.g_ret_sts_success;
6705:
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;
6751: */
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
6872: RAISE fnd_api.g_exc_unexpected_error;
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
6981: RAISE fnd_api.g_exc_unexpected_error;
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:
6993: -- check auto assignment
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:
7022: ELSE -- Territory Flag is NO
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:
7028: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
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;
7057: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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 ************************/
7071:
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
7110: RAISE fnd_api.g_exc_unexpected_error;
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
7138: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
7143: END IF; -- End of JTF_ASSIGN_CUHK
7150:
7151: /* Standard call to get message count and
7152: the message information */
7153:
7154: FND_MSG_PUB.Count_And_Get
7155: (
7156: p_count => x_msg_count,
7157: p_data => x_msg_data
7158: );
7161:
7162: EXCEPTION
7163: WHEN FND_API.G_EXC_ERROR THEN
7164: x_return_status := FND_API.G_RET_STS_ERROR ;
7165: FND_MSG_PUB.Count_And_Get
7166: (
7167: p_count => x_msg_count,
7168: p_data => x_msg_data
7169: );
7169: );
7170:
7171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7173: FND_MSG_PUB.Count_And_Get
7174: (
7175: p_count => x_msg_count,
7176: p_data => x_msg_data
7177: );
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
7188: FND_MSG_PUB.Add_Exc_Msg
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
7188: FND_MSG_PUB.Add_Exc_Msg
7189: (
7190: G_PKG_NAME,
7191: 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
7188: FND_MSG_PUB.Add_Exc_Msg
7189: (
7190: G_PKG_NAME,
7191: l_api_name
7192: );
7191: l_api_name
7192: );
7193: END IF;
7194:
7195: FND_MSG_PUB.Count_And_Get
7196: (
7197: p_count => x_msg_count,
7198: p_data => x_msg_data
7199: );
7382:
7383: /* Initialize message list if p_init_msg_list is set to TRUE */
7384:
7385: IF fnd_api.to_boolean (p_init_msg_list) THEN
7386: fnd_msg_pub.initialize;
7387: END IF;
7388:
7389: x_return_status := fnd_api.g_ret_sts_success;
7390:
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
7472: RAISE fnd_api.g_exc_unexpected_error;
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
7569: RAISE fnd_api.g_exc_unexpected_error;
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:
7581:
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:
7610: ELSE -- Territory Flag is NO
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:
7616: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
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;
7646: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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 ************************/
7660:
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
7698: RAISE fnd_api.g_exc_unexpected_error;
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
7726: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
7731: END IF; -- End of JTF_ASSIGN_CUHK
7737:
7738: /* Standard call to get message count and
7739: the message information */
7740:
7741: FND_MSG_PUB.Count_And_Get
7742: (
7743: p_count => x_msg_count,
7744: p_data => x_msg_data
7745: );
7748:
7749: EXCEPTION
7750: WHEN FND_API.G_EXC_ERROR THEN
7751: x_return_status := FND_API.G_RET_STS_ERROR ;
7752: FND_MSG_PUB.Count_And_Get
7753: (
7754: p_count => x_msg_count,
7755: p_data => x_msg_data
7756: );
7756: );
7757:
7758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7760: FND_MSG_PUB.Count_And_Get
7761: (
7762: p_count => x_msg_count,
7763: p_data => x_msg_data
7764: );
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
7775: FND_MSG_PUB.Add_Exc_Msg
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
7775: FND_MSG_PUB.Add_Exc_Msg
7776: (
7777: G_PKG_NAME,
7778: 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
7775: FND_MSG_PUB.Add_Exc_Msg
7776: (
7777: G_PKG_NAME,
7778: l_api_name
7779: );
7778: l_api_name
7779: );
7780: END IF;
7781:
7782: FND_MSG_PUB.Count_And_Get
7783: (
7784: p_count => x_msg_count,
7785: p_data => x_msg_data
7786: );
7908:
7909: /* Initialize message list if p_init_msg_list is set to TRUE */
7910:
7911: IF fnd_api.to_boolean (p_init_msg_list) THEN
7912: fnd_msg_pub.initialize;
7913: END IF;
7914:
7915: x_return_status := fnd_api.g_ret_sts_success;
7916:
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
8047: RAISE fnd_api.g_exc_unexpected_error;
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
8120: RAISE fnd_api.g_exc_error;
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:
8216: ELSE -- No resources returned from the Territory API
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:
8222: ELSE -- Territory Flag is NO
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:
8228: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
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;
8258: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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 ************************/
8272:
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
8310: RAISE fnd_api.g_exc_unexpected_error;
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
8339: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
8344: END IF; -- End of JTF_ASSIGN_CUHK
8349:
8350: /* Standard call to get message count and
8351: the message information */
8352:
8353: FND_MSG_PUB.Count_And_Get
8354: (
8355: p_count => x_msg_count,
8356: p_data => x_msg_data
8357: );
8360:
8361: EXCEPTION
8362: WHEN FND_API.G_EXC_ERROR THEN
8363: x_return_status := FND_API.G_RET_STS_ERROR ;
8364: FND_MSG_PUB.Count_And_Get
8365: (
8366: p_count => x_msg_count,
8367: p_data => x_msg_data
8368: );
8368: );
8369:
8370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8372: FND_MSG_PUB.Count_And_Get
8373: (
8374: p_count => x_msg_count,
8375: p_data => x_msg_data
8376: );
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
8387: FND_MSG_PUB.Add_Exc_Msg
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
8387: FND_MSG_PUB.Add_Exc_Msg
8388: (
8389: G_PKG_NAME,
8390: 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
8387: FND_MSG_PUB.Add_Exc_Msg
8388: (
8389: G_PKG_NAME,
8390: l_api_name
8391: );
8390: l_api_name
8391: );
8392: END IF;
8393:
8394: FND_MSG_PUB.Count_And_Get
8395: (
8396: p_count => x_msg_count,
8397: p_data => x_msg_data
8398: );
8585:
8586: /* Initialize message list if p_init_msg_list is set to TRUE */
8587:
8588: IF fnd_api.to_boolean (p_init_msg_list) THEN
8589: fnd_msg_pub.initialize;
8590: END IF;
8591:
8592: x_return_status := fnd_api.g_ret_sts_success;
8593:
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
8716: RAISE fnd_api.g_exc_unexpected_error;
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
8831: RAISE fnd_api.g_exc_unexpected_error;
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:
8843: -- to implement auto selection
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:
8870: ELSE -- Territory Flag is NO
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:
8876: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
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;
8905: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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 ************************/
8919:
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
8958: RAISE fnd_api.g_exc_unexpected_error;
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
8986: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
8991: END IF; -- End of JTF_ASSIGN_CUHK
8997:
8998: /* Standard call to get message count and
8999: the message information */
9000:
9001: FND_MSG_PUB.Count_And_Get
9002: (
9003: p_count => x_msg_count,
9004: p_data => x_msg_data
9005: );
9008:
9009: EXCEPTION
9010: WHEN FND_API.G_EXC_ERROR THEN
9011: x_return_status := FND_API.G_RET_STS_ERROR ;
9012: FND_MSG_PUB.Count_And_Get
9013: (
9014: p_count => x_msg_count,
9015: p_data => x_msg_data
9016: );
9016: );
9017:
9018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9020: FND_MSG_PUB.Count_And_Get
9021: (
9022: p_count => x_msg_count,
9023: p_data => x_msg_data
9024: );
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
9035: FND_MSG_PUB.Add_Exc_Msg
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
9035: FND_MSG_PUB.Add_Exc_Msg
9036: (
9037: G_PKG_NAME,
9038: 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
9035: FND_MSG_PUB.Add_Exc_Msg
9036: (
9037: G_PKG_NAME,
9038: l_api_name
9039: );
9038: l_api_name
9039: );
9040: END IF;
9041:
9042: FND_MSG_PUB.Count_And_Get
9043: (
9044: p_count => x_msg_count,
9045: p_data => x_msg_data
9046: );
9203:
9204: /* Initialize message list if p_init_msg_list is set to TRUE */
9205:
9206: IF fnd_api.to_boolean (p_init_msg_list) THEN
9207: fnd_msg_pub.initialize;
9208: END IF;
9209:
9210: x_return_status := fnd_api.g_ret_sts_success;
9211:
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
9266: RAISE fnd_api.g_exc_unexpected_error;
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:
9276: -- added 2 april 2003 by sudarsana to conver RS_SUPPLIER TO RS_SUPPLIER_CONTACT
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
9382: RAISE fnd_api.g_exc_unexpected_error;
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:
9395: ELSE -- No resources returned from the Territory API
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:
9401:
9401:
9402: /* Standard call to get message count and
9403: the message information */
9404:
9405: FND_MSG_PUB.Count_And_Get
9406: (
9407: p_count => x_msg_count,
9408: p_data => x_msg_data
9409: );
9411:
9412: EXCEPTION
9413: WHEN FND_API.G_EXC_ERROR THEN
9414: x_return_status := FND_API.G_RET_STS_ERROR ;
9415: FND_MSG_PUB.Count_And_Get
9416: (
9417: p_count => x_msg_count,
9418: p_data => x_msg_data
9419: );
9419: );
9420:
9421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9423: FND_MSG_PUB.Count_And_Get
9424: (
9425: p_count => x_msg_count,
9426: p_data => x_msg_data
9427: );
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
9438: FND_MSG_PUB.Add_Exc_Msg
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
9438: FND_MSG_PUB.Add_Exc_Msg
9439: (
9440: G_PKG_NAME,
9441: 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
9438: FND_MSG_PUB.Add_Exc_Msg
9439: (
9440: G_PKG_NAME,
9441: l_api_name
9442: );
9441: l_api_name
9442: );
9443: END IF;
9444:
9445: FND_MSG_PUB.Count_And_Get
9446: (
9447: p_count => x_msg_count,
9448: p_data => x_msg_data
9449: );
9705:
9706: /* Initialize message list if p_init_msg_list is set to TRUE */
9707:
9708: IF fnd_api.to_boolean (p_init_msg_list) THEN
9709: fnd_msg_pub.initialize;
9710: END IF;
9711:
9712: x_return_status := fnd_api.g_ret_sts_success;
9713:
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;
9727: l_esc_source_id := l_cur_esc_id.source_object_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;
9742: FETCH cur_reference_code INTO l_cur_reference_code;
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;
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;
9758: CLOSE cur_reference_code;
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:
9847: CLOSE cur_source_task;
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:
9868: CLOSE cur_source_sr;
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:
9892: CLOSE cur_source_defect;
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
9930: RAISE fnd_api.g_exc_unexpected_error;
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
9964: RAISE fnd_api.g_exc_unexpected_error;
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:
9974: END IF; -- IF (l_territory_id IS NOT NULL) THEN
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
10005: RAISE fnd_api.g_exc_unexpected_error;
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
10121: RAISE fnd_api.g_exc_unexpected_error;
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:
10133: -- to implement auto selection
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:
10161: ELSE -- Territory Flag is NO
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:
10167: l_esc_record := p_esc_tbl.NEXT(l_esc_record);
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
10199: RAISE fnd_api.g_exc_unexpected_error;
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:
10262:
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:
10269: END IF; -- End of l_esc_tbl.count > 0
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;
10395:
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;
10425: END IF;
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 ************************/
10439:
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
10480: RAISE fnd_api.g_exc_unexpected_error;
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
10510: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
10515: END IF; -- End of JTF_ASSIGN_CUHK
10520:
10521: /* Standard call to get message count and
10522: the message information */
10523:
10524: FND_MSG_PUB.Count_And_Get
10525: (
10526: p_count => x_msg_count,
10527: p_data => x_msg_data
10528: );
10531:
10532: EXCEPTION
10533: WHEN FND_API.G_EXC_ERROR THEN
10534: x_return_status := FND_API.G_RET_STS_ERROR ;
10535: FND_MSG_PUB.Count_And_Get
10536: (
10537: p_count => x_msg_count,
10538: p_data => x_msg_data
10539: );
10539: );
10540:
10541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10543: FND_MSG_PUB.Count_And_Get
10544: (
10545: p_count => x_msg_count,
10546: p_data => x_msg_data
10547: );
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
10558: FND_MSG_PUB.Add_Exc_Msg
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
10558: FND_MSG_PUB.Add_Exc_Msg
10559: (
10560: G_PKG_NAME,
10561: 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
10558: FND_MSG_PUB.Add_Exc_Msg
10559: (
10560: G_PKG_NAME,
10561: l_api_name
10562: );
10561: l_api_name
10562: );
10563: END IF;
10564:
10565: FND_MSG_PUB.Count_And_Get
10566: (
10567: p_count => x_msg_count,
10568: p_data => x_msg_data
10569: );
10852:
10853: /* Initialize message list if p_init_msg_list is set to TRUE */
10854:
10855: IF fnd_api.to_boolean (p_init_msg_list) THEN
10856: fnd_msg_pub.initialize;
10857: END IF;
10858:
10859:
10860:
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;
10873: END IF;
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;
10886: END IF;
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;
11234:
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
11286: RAISE fnd_api.g_exc_unexpected_error;
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:
11445:
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;
11483: ELSE
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==========================
11502: -- =============== This code is added for sorting table based on territory ranking===========
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
11559: RAISE fnd_api.g_exc_unexpected_error;
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:
11739: -- raise workfow event
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;
11769: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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==========================
11782: -- =============== This code is added for sorting table based on territory ranking===========
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
11831: RAISE fnd_api.g_exc_unexpected_error;
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:
11919: -- raise workfow event
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;
11949: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
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:
11963: END IF; -- End of UPPER(l_calling_doc_type)= 'SR'- 'TASK'- 'DEF'
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
12000: RAISE fnd_api.g_exc_unexpected_error;
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
12030: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
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:
12035: END IF; -- End of JTF_ASSIGN_CUHK
12039:
12040: /* Standard call to get message count and
12041: the message information */
12042:
12043: FND_MSG_PUB.Count_And_Get
12044: (
12045: p_count => x_msg_count,
12046: p_data => x_msg_data
12047: );
12053:
12054: EXCEPTION
12055: WHEN FND_API.G_EXC_ERROR THEN
12056: x_return_status := FND_API.G_RET_STS_ERROR ;
12057: FND_MSG_PUB.Count_And_Get
12058: (
12059: p_count => x_msg_count,
12060: p_data => x_msg_data
12061: );
12061: );
12062:
12063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12065: FND_MSG_PUB.Count_And_Get
12066: (
12067: p_count => x_msg_count,
12068: p_data => x_msg_data
12069: );
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
12080: FND_MSG_PUB.Add_Exc_Msg
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
12080: FND_MSG_PUB.Add_Exc_Msg
12081: (
12082: G_PKG_NAME,
12083: 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
12080: FND_MSG_PUB.Add_Exc_Msg
12081: (
12082: G_PKG_NAME,
12083: l_api_name
12084: );
12083: l_api_name
12084: );
12085: END IF;
12086:
12087: FND_MSG_PUB.Count_And_Get
12088: (
12089: p_count => x_msg_count,
12090: p_data => x_msg_data
12091: );
12168:
12169: /* Initialize message list if p_init_msg_list is set to TRUE */
12170:
12171: IF fnd_api.to_boolean (p_init_msg_list) THEN
12172: fnd_msg_pub.initialize;
12173: END IF;
12174:
12175: x_return_status := fnd_api.g_ret_sts_success;
12176:
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
12303: RAISE fnd_api.g_exc_unexpected_error;
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
12337: RAISE fnd_api.g_exc_unexpected_error;
12346:
12347: EXCEPTION
12348: WHEN FND_API.G_EXC_ERROR THEN
12349: x_return_status := FND_API.G_RET_STS_ERROR ;
12350: FND_MSG_PUB.Count_And_Get
12351: (
12352: p_count => x_msg_count,
12353: p_data => x_msg_data
12354: );
12354: );
12355:
12356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12358: FND_MSG_PUB.Count_And_Get
12359: (
12360: p_count => x_msg_count,
12361: p_data => x_msg_data
12362: );
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
12373: FND_MSG_PUB.Add_Exc_Msg
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
12373: FND_MSG_PUB.Add_Exc_Msg
12374: (
12375: G_PKG_NAME,
12376: 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
12373: FND_MSG_PUB.Add_Exc_Msg
12374: (
12375: G_PKG_NAME,
12376: l_api_name
12377: );
12376: l_api_name
12377: );
12378: END IF;
12379:
12380: FND_MSG_PUB.Count_And_Get
12381: (
12382: p_count => x_msg_count,
12383: p_data => x_msg_data
12384: );
12424:
12425: /* Initialize message list if p_init_msg_list is set to TRUE */
12426: IF fnd_api.to_boolean (p_init_msg_list)
12427: THEN
12428: fnd_msg_pub.initialize;
12429: END IF;
12430:
12431: x_return_status := fnd_api.g_ret_sts_success;
12432:
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
12464: RAISE fnd_api.g_exc_unexpected_error;
12470:
12471: EXCEPTION
12472: WHEN FND_API.G_EXC_ERROR THEN
12473: x_return_status := FND_API.G_RET_STS_ERROR ;
12474: FND_MSG_PUB.Count_And_Get
12475: (
12476: p_count => x_msg_count,
12477: p_data => x_msg_data
12478: );
12478: );
12479:
12480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12482: FND_MSG_PUB.Count_And_Get
12483: (
12484: p_count => x_msg_count,
12485: p_data => x_msg_data
12486: );
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
12497: FND_MSG_PUB.Add_Exc_Msg
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
12497: FND_MSG_PUB.Add_Exc_Msg
12498: (
12499: G_PKG_NAME,
12500: 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
12497: FND_MSG_PUB.Add_Exc_Msg
12498: (
12499: G_PKG_NAME,
12500: l_api_name
12501: );
12500: l_api_name
12501: );
12502: END IF;
12503:
12504: FND_MSG_PUB.Count_And_Get
12505: (
12506: p_count => x_msg_count,
12507: p_data => x_msg_data
12508: );