[Home] [Help]
1002:
1003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1004: -- Unexpected Execution Error from call to Calendar
1005: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1006: fnd_msg_pub.add;
1007: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1008: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1009: -- Removed Comment to Show error message Bug # 2919389
1010: RAISE fnd_api.g_exc_error;
1076:
1077: EXCEPTION
1078: WHEN FND_API.G_EXC_ERROR THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: FND_MSG_PUB.Count_And_Get
1081: (
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1084: );
1085:
1086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1088: FND_MSG_PUB.Count_And_Get
1089: (
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1095: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1096: fnd_message.set_token('P_SQLCODE',SQLCODE);
1097: fnd_message.set_token('P_SQLERRM',SQLERRM);
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;
1100:
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1103: FND_MSG_PUB.Add_Exc_Msg
1098: fnd_message.set_token('P_API_NAME',l_api_name);
1099: FND_MSG_PUB.add;
1100:
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1103: FND_MSG_PUB.Add_Exc_Msg
1104: (
1105: G_PKG_NAME,
1106: l_api_name
1099: FND_MSG_PUB.add;
1100:
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1103: FND_MSG_PUB.Add_Exc_Msg
1104: (
1105: G_PKG_NAME,
1106: l_api_name
1107: );
1106: l_api_name
1107: );
1108: END IF;
1109:
1110: FND_MSG_PUB.Count_And_Get
1111: (
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1305:
1306: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1307: -- Unexpected Execution Error from call to Calendar
1308: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1309: fnd_msg_pub.add;
1310: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1311: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1312: -- Removed Comment to Show error message Bug # 2919389
1313: RAISE fnd_api.g_exc_error;
1475:
1476: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1477: -- Unexpected Execution Error from call to Calendar
1478: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1479: fnd_msg_pub.add;
1480: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1481: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1482: -- Removed Comment to Show error message Bug # 2919389
1483: RAISE fnd_api.g_exc_error;
1585:
1586: EXCEPTION
1587: WHEN FND_API.G_EXC_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: FND_MSG_PUB.Count_And_Get
1590: (
1591: p_count => x_msg_count,
1592: p_data => x_msg_data
1593: );
1593: );
1594:
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1597: FND_MSG_PUB.Count_And_Get
1598: (
1599: p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1604: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1612: FND_MSG_PUB.Add_Exc_Msg
1607: fnd_message.set_token('P_API_NAME',l_api_name);
1608: FND_MSG_PUB.add;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1612: FND_MSG_PUB.Add_Exc_Msg
1613: (
1614: G_PKG_NAME,
1615: l_api_name
1608: FND_MSG_PUB.add;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
1612: FND_MSG_PUB.Add_Exc_Msg
1613: (
1614: G_PKG_NAME,
1615: l_api_name
1616: );
1615: l_api_name
1616: );
1617: END IF;
1618:
1619: FND_MSG_PUB.Count_And_Get
1620: (
1621: p_count => x_msg_count,
1622: p_data => x_msg_data
1623: );
1723: END IF;
1724:
1725: IF (l_cur_contracts_installed.application_id IS NULL) THEN
1726: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1727: fnd_msg_pub.add;
1728: RAISE fnd_api.g_exc_error;
1729: ELSE
1730:
1731: IF FND_INSTALLATION.GET
1736: l_industry
1737: ) THEN
1738: IF ( UPPER(l_status) <> 'I' ) THEN
1739: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1740: fnd_msg_pub.add;
1741: RAISE fnd_api.g_exc_error;
1742: END IF;
1743: ELSE
1744: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1741: RAISE fnd_api.g_exc_error;
1742: END IF;
1743: ELSE
1744: fnd_message.set_name('JTF', 'JTF_AM_CONTRACTS_NOT_INSTALLED');
1745: fnd_msg_pub.add;
1746: RAISE fnd_api.g_exc_error;
1747: END IF;
1748: END IF;
1749:
1798:
1799: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1800: -- Unexpected Execution Error from call to Contracts API
1801: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_CONTRACTS_API'||''''||');'||
1802: 'fnd_msg_pub.add;
1803: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1804: RAISE fnd_api.g_exc_error;
1805: ELSE
1806: RAISE fnd_api.g_exc_unexpected_error;
2007: -- Unexpected Execution Error from call to Get_contracts_resources
2008: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2009: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2010: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
2011: fnd_msg_pub.add;
2012: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2013: RAISE fnd_api.g_exc_error;
2014: ELSE
2015: RAISE fnd_api.g_exc_unexpected_error;
2021:
2022: EXCEPTION
2023: WHEN FND_API.G_EXC_ERROR THEN
2024: x_return_status := FND_API.G_RET_STS_ERROR ;
2025: FND_MSG_PUB.Count_And_Get
2026: (
2027: p_count => x_msg_count,
2028: p_data => x_msg_data
2029: );
2029: );
2030:
2031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2033: FND_MSG_PUB.Count_And_Get
2034: (
2035: p_count => x_msg_count,
2036: p_data => x_msg_data
2037: );
2040: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2041: fnd_message.set_token('P_SQLCODE',SQLCODE);
2042: fnd_message.set_token('P_SQLERRM',SQLERRM);
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;
2045:
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2048: FND_MSG_PUB.Add_Exc_Msg
2043: fnd_message.set_token('P_API_NAME',l_api_name);
2044: FND_MSG_PUB.add;
2045:
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2048: FND_MSG_PUB.Add_Exc_Msg
2049: (
2050: G_PKG_NAME,
2051: l_api_name
2044: FND_MSG_PUB.add;
2045:
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2048: FND_MSG_PUB.Add_Exc_Msg
2049: (
2050: G_PKG_NAME,
2051: l_api_name
2052: );
2051: l_api_name
2052: );
2053: END IF;
2054:
2055: FND_MSG_PUB.Count_And_Get
2056: (
2057: p_count => x_msg_count,
2058: p_data => x_msg_data
2059: );
2449: -- Unexpected Execution Error from call to Get_contracts_resources
2450: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2451: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2452: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');
2453: fnd_msg_pub.add;
2454: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2455: RAISE fnd_api.g_exc_error;
2456: ELSE
2457: RAISE fnd_api.g_exc_unexpected_error;
2463:
2464: EXCEPTION
2465: WHEN FND_API.G_EXC_ERROR THEN
2466: x_return_status := FND_API.G_RET_STS_ERROR ;
2467: FND_MSG_PUB.Count_And_Get
2468: (
2469: p_count => x_msg_count,
2470: p_data => x_msg_data
2471: );
2471: );
2472:
2473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2475: FND_MSG_PUB.Count_And_Get
2476: (
2477: p_count => x_msg_count,
2478: p_data => x_msg_data
2479: );
2482: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
2483: fnd_message.set_token('P_SQLCODE',SQLCODE);
2484: fnd_message.set_token('P_SQLERRM',SQLERRM);
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;
2487:
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2490: FND_MSG_PUB.Add_Exc_Msg
2485: fnd_message.set_token('P_API_NAME',l_api_name);
2486: FND_MSG_PUB.add;
2487:
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2490: FND_MSG_PUB.Add_Exc_Msg
2491: (
2492: G_PKG_NAME,
2493: l_api_name
2486: FND_MSG_PUB.add;
2487:
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
2490: FND_MSG_PUB.Add_Exc_Msg
2491: (
2492: G_PKG_NAME,
2493: l_api_name
2494: );
2493: l_api_name
2494: );
2495: END IF;
2496:
2497: FND_MSG_PUB.Count_And_Get
2498: (
2499: p_count => x_msg_count,
2500: p_data => x_msg_data
2501: );
2764:
2765: /* Initialize message list if p_init_msg_list is set to TRUE */
2766:
2767: IF fnd_api.to_boolean (p_init_msg_list) THEN
2768: fnd_msg_pub.initialize;
2769: END IF;
2770:
2771: x_return_status := fnd_api.g_ret_sts_success;
2772:
2782: OPEN cur_task_id;
2783: FETCH cur_task_id INTO l_cur_task_id;
2784: IF ( cur_task_id%NOTFOUND ) THEN
2785: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
2786: fnd_msg_pub.add;
2787: RAISE fnd_api.g_exc_error;
2788: ELSE
2789: l_task_source_code := l_cur_task_id.source_object_type_code;
2790: l_task_source_id := l_cur_task_id.source_object_id;
2820: l_planned_end_date;
2821:
2822: IF ( cur_cs_incidents%NOTFOUND ) THEN
2823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
2824: fnd_msg_pub.add;
2825: RAISE fnd_api.g_exc_error;
2826: ELSE
2827: l_contract_flag := 'Y';
2828: l_planned_start_date := SYSDATE;
2888: -- Unexpected Execution Error from call to Get_contracts_resources
2889: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2890: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2891: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2892: fnd_msg_pub.add;
2893: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2894: RAISE fnd_api.g_exc_error;
2895: ELSE
2896: RAISE fnd_api.g_exc_unexpected_error;
2930: -- Unexpected Execution Error from call to Get_contracts_resources
2931: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2932: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2933: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
2934: fnd_msg_pub.add;
2935: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
2936: RAISE fnd_api.g_exc_error;
2937: ELSE
2938: RAISE fnd_api.g_exc_unexpected_error;
2989: -- If there are NO preferred engineers then call territory API
2990:
2991: IF (l_task_source_code = 'SR') THEN
2992: fnd_message.set_name('JTF', 'JTF_AM_TASK_CREATED_BY_SR');
2993: fnd_msg_pub.add;
2994: RAISE fnd_api.g_exc_error;
2995:
2996: /* Query the View which is a combination of Task and Service Request
2997: to get the data into the Record Type to pass it to the Territory API */
3045:
3046: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3047: -- Unexpected Execution Error from call to Territory Manager
3048: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3049: fnd_msg_pub.add;
3050: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3051: RAISE fnd_api.g_exc_error;
3052: ELSE
3053: RAISE fnd_api.g_exc_unexpected_error;
3150: -- Unexpected Execution Error from call to Get_contracts_resources
3151: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3152: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3153: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3154: fnd_msg_pub.add;
3155: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3156: RAISE fnd_api.g_exc_error;
3157: ELSE
3158: RAISE fnd_api.g_exc_unexpected_error;
3162:
3163: IF ( p_calendar_flag = 'Y' AND
3164: x_assign_resources_tbl.count = 0 ) THEN
3165: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3166: fnd_msg_pub.add;
3167: -- RAISE fnd_api.g_exc_error;
3168: END IF;
3169:
3170: -- remove excluded resources
3175: END IF;
3176:
3177: ELSE -- No resources returned from the Territory API
3178: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3179: fnd_msg_pub.add;
3180: -- RAISE fnd_api.g_exc_error;
3181: END IF;
3182:
3183: ELSE -- Territory Flag is NO
3181: END IF;
3182:
3183: ELSE -- Territory Flag is NO
3184: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3185: fnd_msg_pub.add;
3186: -- RAISE fnd_api.g_exc_error;
3187: END IF;
3188:
3189: ELSE -- l_task_source_code <> 'SR'
3261:
3262: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3263: -- Unexpected Execution Error from call to Territory Manager for TASKS
3264: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3265: fnd_msg_pub.add;
3266: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3267: RAISE fnd_api.g_exc_error;
3268: ELSE
3269: RAISE fnd_api.g_exc_unexpected_error;
3367: -- Unexpected Execution Error from call to Get_contracts_resources
3368: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3369: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3370: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
3371: fnd_msg_pub.add;
3372: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3373: RAISE fnd_api.g_exc_error;
3374: ELSE
3375: RAISE fnd_api.g_exc_unexpected_error;
3379:
3380: IF ( p_calendar_flag = 'Y' AND
3381: x_assign_resources_tbl.count = 0 ) THEN
3382: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
3383: fnd_msg_pub.add;
3384: -- RAISE fnd_api.g_exc_error;
3385: END IF;
3386:
3387: ELSE -- No resources returned from the Territory API
3385: END IF;
3386:
3387: ELSE -- No resources returned from the Territory API
3388: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3389: fnd_msg_pub.add;
3390: -- RAISE fnd_api.g_exc_error;
3391: END IF;
3392:
3393: ELSE -- Territory Flag is NO
3397: -- This was done as we don't want to fetch all resources blindly any time.
3398: -- Fix for Bug 3308883.
3399:
3400: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
3401: fnd_msg_pub.add;
3402: END IF; -- End of Territory_Flag = 'Y'
3403:
3404: END IF; -- End of l_task_source_code = 'SR'
3405:
3495:
3496: /* Standard call to get message count and
3497: the message information */
3498:
3499: FND_MSG_PUB.Count_And_Get
3500: (
3501: p_count => x_msg_count,
3502: p_data => x_msg_data
3503: );
3506:
3507: EXCEPTION
3508: WHEN FND_API.G_EXC_ERROR THEN
3509: x_return_status := FND_API.G_RET_STS_ERROR ;
3510: FND_MSG_PUB.Count_And_Get
3511: (
3512: p_count => x_msg_count,
3513: p_data => x_msg_data
3514: );
3514: );
3515:
3516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3518: FND_MSG_PUB.Count_And_Get
3519: (
3520: p_count => x_msg_count,
3521: p_data => x_msg_data
3522: );
3525: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
3526: fnd_message.set_token('P_SQLCODE',SQLCODE);
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
3532: FND_MSG_PUB.Add_Exc_Msg
3533: (
3527: fnd_message.set_token('P_SQLERRM',SQLERRM);
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
3532: FND_MSG_PUB.Add_Exc_Msg
3533: (
3534: G_PKG_NAME,
3535: l_api_name
3528: fnd_message.set_token('P_API_NAME',l_api_name);
3529: FND_MSG_PUB.add;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
3532: FND_MSG_PUB.Add_Exc_Msg
3533: (
3534: G_PKG_NAME,
3535: l_api_name
3536: );
3535: l_api_name
3536: );
3537: END IF;
3538:
3539: FND_MSG_PUB.Count_And_Get
3540: (
3541: p_count => x_msg_count,
3542: p_data => x_msg_data
3543: );
3812:
3813: /* Initialize message list if p_init_msg_list is set to TRUE */
3814:
3815: IF fnd_api.to_boolean (p_init_msg_list) THEN
3816: fnd_msg_pub.initialize;
3817: END IF;
3818:
3819:
3820: x_return_status := fnd_api.g_ret_sts_success;
3899: --l_planned_end_date; -- Commented by SBARAT on 10/12/2004 for Bug 4052202
3900:
3901: IF ( cur_cs_incidents%NOTFOUND ) THEN
3902: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
3903: fnd_msg_pub.add;
3904: RAISE fnd_api.g_exc_error;
3905: /*
3906: ELSE
3907: l_contract_flag := 'Y';
3960: -- Unexpected Execution Error from call to Get_contracts_resources
3961: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3962: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
3963: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
3964: fnd_msg_pub.add;
3965: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3966: RAISE fnd_api.g_exc_error;
3967: ELSE
3968: RAISE fnd_api.g_exc_unexpected_error;
3997: -- Unexpected Execution Error from call to Get_contracts_resources
3998: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3999: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
4000: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4001: fnd_msg_pub.add;
4002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4003: RAISE fnd_api.g_exc_error;
4004: ELSE
4005: RAISE fnd_api.g_exc_unexpected_error;
4039: -- Unexpected Execution Error from call to Get_contracts_resources
4040: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4041: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4042: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4043: fnd_msg_pub.add;
4044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4045: RAISE fnd_api.g_exc_error;
4046: ELSE
4047: RAISE fnd_api.g_exc_unexpected_error;
4064: -- Unexpected Execution Error from call to Get_contracts_resources
4065: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4066: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4067: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4068: fnd_msg_pub.add;
4069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4070: RAISE fnd_api.g_exc_error;
4071: ELSE
4072: RAISE fnd_api.g_exc_unexpected_error;
4244:
4245: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4246: -- Unexpected Execution Error from call to Territory Manager
4247: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4248: fnd_msg_pub.add;
4249: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4250: RAISE fnd_api.g_exc_error;
4251: ELSE
4252: RAISE fnd_api.g_exc_unexpected_error;
4274: -- This was done as we don't want to fetch all resources blindly any time.
4275: -- Fix for Bug 3308883.
4276:
4277: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4278: fnd_msg_pub.add;
4279: END IF; -- End of p_territory_flag = 'Y'
4280:
4281: ELSIF
4282: (
4370:
4371: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4372: -- Unexpected Execution Error from call to Territory Manager
4373: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4374: fnd_msg_pub.add;
4375: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4376: RAISE fnd_api.g_exc_error;
4377: ELSE
4378: RAISE fnd_api.g_exc_unexpected_error;
4401: -- This was done as we don't want to fetch all resources blindly any time.
4402: -- Fix for Bug 3308883.
4403:
4404: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4405: fnd_msg_pub.add;
4406: END IF; -- End of p_territory_flag = 'Y'
4407:
4408: END IF; -- End of p_sr_rec IS NOT NULL or p_sr_task_rec IS NOT NULL
4409:
4488: -- Unexpected Execution Error from call to Get_contracts_resources
4489: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4490: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4491: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4492: fnd_msg_pub.add;
4493: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4494: RAISE fnd_api.g_exc_error;
4495: ELSE
4496: RAISE fnd_api.g_exc_unexpected_error;
4501:
4502: IF ( p_calendar_flag = 'Y' AND
4503: x_assign_resources_tbl.count = 0 ) THEN
4504: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
4505: fnd_msg_pub.add;
4506: -- RAISE fnd_api.g_exc_error;
4507: END IF;
4508:
4509:
4530: -- Unexpected Execution Error from call to Get_contracts_resources
4531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4532: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
4533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
4534: fnd_msg_pub.add;
4535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
4536: RAISE fnd_api.g_exc_error;
4537: ELSE
4538: RAISE fnd_api.g_exc_unexpected_error;
4541: END IF; -- end of security check
4542: ELSE -- No resources returned from the Territory API
4543:
4544: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
4545: fnd_msg_pub.add;
4546: -- RAISE fnd_api.g_exc_error;
4547: END IF;
4548:
4549:
4877:
4878: /* Standard call to get message count and
4879: the message information */
4880:
4881: FND_MSG_PUB.Count_And_Get
4882: (
4883: p_count => x_msg_count,
4884: p_data => x_msg_data
4885: );
4888:
4889: EXCEPTION
4890: WHEN FND_API.G_EXC_ERROR THEN
4891: x_return_status := FND_API.G_RET_STS_ERROR ;
4892: FND_MSG_PUB.Count_And_Get
4893: (
4894: p_count => x_msg_count,
4895: p_data => x_msg_data
4896: );
4896: );
4897:
4898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4900: FND_MSG_PUB.Count_And_Get
4901: (
4902: p_count => x_msg_count,
4903: p_data => x_msg_data
4904: );
4907: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
4908: fnd_message.set_token('P_SQLCODE',SQLCODE);
4909: fnd_message.set_token('P_SQLERRM',SQLERRM);
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;
4912:
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
4915: FND_MSG_PUB.Add_Exc_Msg
4910: fnd_message.set_token('P_API_NAME',l_api_name);
4911: FND_MSG_PUB.add;
4912:
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
4915: FND_MSG_PUB.Add_Exc_Msg
4916: (
4917: G_PKG_NAME,
4918: l_api_name
4911: FND_MSG_PUB.add;
4912:
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
4915: FND_MSG_PUB.Add_Exc_Msg
4916: (
4917: G_PKG_NAME,
4918: l_api_name
4919: );
4918: l_api_name
4919: );
4920: END IF;
4921:
4922: FND_MSG_PUB.Count_And_Get
4923: (
4924: p_count => x_msg_count,
4925: p_data => x_msg_data
4926: );
5239:
5240: /* Initialize message list if p_init_msg_list is set to TRUE */
5241:
5242: IF fnd_api.to_boolean (p_init_msg_list) THEN
5243: fnd_msg_pub.initialize;
5244: END IF;
5245:
5246: x_return_status := fnd_api.g_ret_sts_success;
5247:
5251: OPEN cur_resource_type;
5252: FETCH cur_resource_type INTO l_cur_resource_type;
5253: IF ( cur_resource_type%NOTFOUND) THEN
5254: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
5255: fnd_msg_pub.add;
5256: RAISE fnd_api.g_exc_error;
5257: END IF;
5258: CLOSE cur_resource_type;
5259: END IF;
5471: --l_planned_end_date; --Commented out by SBARAT on 10/12/2004 for bug 4052202
5472:
5473: IF ( cur_cs_incidents%NOTFOUND ) THEN
5474: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DR_ID');
5475: fnd_msg_pub.add;
5476: RAISE fnd_api.g_exc_error;
5477: END IF;
5478:
5479: CLOSE cur_cs_incidents;
5530: -- Unexpected Execution Error from call to Get_contracts_resources
5531: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5532: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5533: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5534: fnd_msg_pub.add;
5535: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5536: RAISE fnd_api.g_exc_error;
5537: ELSE
5538: RAISE fnd_api.g_exc_unexpected_error;
5567: -- Unexpected Execution Error from call to Get_contracts_resources
5568: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5569: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
5570: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5571: fnd_msg_pub.add;
5572: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5573: RAISE fnd_api.g_exc_error;
5574: ELSE
5575: RAISE fnd_api.g_exc_unexpected_error;
5609: -- Unexpected Execution Error from call to Get_contracts_resources
5610: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5611: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5612: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5613: fnd_msg_pub.add;
5614: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5615: RAISE fnd_api.g_exc_error;
5616: ELSE
5617: RAISE fnd_api.g_exc_unexpected_error;
5634: -- Unexpected Execution Error from call to Get_contracts_resources
5635: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5636: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5637: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5638: fnd_msg_pub.add;
5639: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5640: RAISE fnd_api.g_exc_error;
5641: ELSE
5642: RAISE fnd_api.g_exc_unexpected_error;
5737:
5738: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5739: -- Unexpected Execution Error from call to Territory Manager
5740: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
5741: fnd_msg_pub.add;
5742: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5743: RAISE fnd_api.g_exc_error;
5744: ELSE
5745: RAISE fnd_api.g_exc_unexpected_error;
5761:
5762: ELSE -- Territory Flag is NO
5763:
5764: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5765: fnd_msg_pub.add;
5766:
5767: END IF; -- End of p_territory_flag = 'Y'
5768:
5769: IF l_winningterrmember_tbl.COUNT > 0 THEN
5833: -- Unexpected Execution Error from call to Get_contracts_resources
5834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5835: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5837: fnd_msg_pub.add;
5838: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5839: RAISE fnd_api.g_exc_error;
5840: ELSE
5841: RAISE fnd_api.g_exc_unexpected_error;
5844:
5845: IF ( p_calendar_flag = 'Y' AND
5846: l_assign_resources_tbl.count = 0 ) THEN
5847: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
5848: fnd_msg_pub.add;
5849: END IF;
5850:
5851:
5852: -- remove excluded resources from territory qualifeid resource list
5871: -- Unexpected Execution Error from call to Get_contracts_resources
5872: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5873: fnd_message.set_token('P_PROC_NAME','SERVICE_SECURITY_CHECK');
5874: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');
5875: fnd_msg_pub.add;
5876: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5877: RAISE fnd_api.g_exc_error;
5878: ELSE
5879: RAISE fnd_api.g_exc_unexpected_error;
5882: END IF; -- end of security check
5883: ELSE -- No resources returned from the Territory API
5884:
5885: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
5886: fnd_msg_pub.add;
5887: END IF;
5888:
5889:
5890: -- Logic for getting resources belonging to group id passed in
6265:
6266: ELSE
6267: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
6268: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6269: fnd_msg_pub.add;
6270: END IF;
6271:
6272:
6273: -- Raise Workflow Event
6298: -- Unexpected Execution Error from call to assign_dr_resource
6299: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6300: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6301: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
6302: fnd_msg_pub.add;
6303:
6304: ELSE
6305: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
6306: END IF;
6311: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6312: fnd_message.set_token('P_SQLCODE',SQLCODE);
6313: fnd_message.set_token('P_SQLERRM',SQLERRM);
6314: fnd_message.set_token('P_API_NAME',l_api_name);
6315: FND_MSG_PUB.add;
6316: End;
6317:
6318:
6319:
6345:
6346: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6347: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6348: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6349: fnd_msg_pub.add;
6350: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6351: RAISE fnd_api.g_exc_error;
6352: ELSE
6353: RAISE fnd_api.g_exc_unexpected_error;
6375:
6376: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
6377: -- Execution Error from call to Assignment Manager Workflow Hook
6378: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6379: fnd_msg_pub.add;
6380: RAISE fnd_api.g_exc_error;
6381: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6382: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6383: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6380: RAISE fnd_api.g_exc_error;
6381: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
6382: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
6383: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
6384: fnd_msg_pub.add;
6385: RAISE fnd_api.g_exc_unexpected_error;
6386: END IF;
6387:
6388: END IF; -- End of JTF_ASSIGN_CUHK
6392:
6393: /* Standard call to get message count and
6394: the message information */
6395:
6396: FND_MSG_PUB.Count_And_Get
6397: (
6398: p_count => x_msg_count,
6399: p_data => x_msg_data
6400: );
6404:
6405: EXCEPTION
6406: WHEN FND_API.G_EXC_ERROR THEN
6407: x_return_status := FND_API.G_RET_STS_ERROR ;
6408: FND_MSG_PUB.Count_And_Get
6409: (
6410: p_count => x_msg_count,
6411: p_data => x_msg_data
6412: );
6412: );
6413:
6414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6416: FND_MSG_PUB.Count_And_Get
6417: (
6418: p_count => x_msg_count,
6419: p_data => x_msg_data
6420: );
6423: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
6424: fnd_message.set_token('P_SQLCODE',SQLCODE);
6425: fnd_message.set_token('P_SQLERRM',SQLERRM);
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;
6428:
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6430: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
6431: FND_MSG_PUB.Add_Exc_Msg
6426: fnd_message.set_token('P_API_NAME',l_api_name);
6427: FND_MSG_PUB.add;
6428:
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6430: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
6431: FND_MSG_PUB.Add_Exc_Msg
6432: (
6433: G_PKG_NAME,
6434: l_api_name
6427: FND_MSG_PUB.add;
6428:
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6430: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
6431: FND_MSG_PUB.Add_Exc_Msg
6432: (
6433: G_PKG_NAME,
6434: l_api_name
6435: );
6434: l_api_name
6435: );
6436: END IF;
6437:
6438: FND_MSG_PUB.Count_And_Get
6439: (
6440: p_count => x_msg_count,
6441: p_data => x_msg_data
6442: );
6633:
6634: /* Initialize message list if p_init_msg_list is set to TRUE */
6635:
6636: IF fnd_api.to_boolean (p_init_msg_list) THEN
6637: fnd_msg_pub.initialize;
6638: END IF;
6639:
6640: x_return_status := fnd_api.g_ret_sts_success;
6641:
6679: OPEN cur_oppr FOR l_dynamic_sql USING p_opportunity_id;
6680: FETCH cur_oppr INTO l_assign_resources_rec;
6681: IF (cur_oppr%NOTFOUND) THEN
6682: fnd_message.set_name('JTF', 'JTF_AM_INVALID_OPPR_ID');
6683: fnd_msg_pub.add;
6684: RAISE fnd_api.g_exc_error;
6685: END IF;
6686: CLOSE cur_oppr;
6687: */
6800:
6801: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6802: -- Unexpected Execution Error from call to Territory Manager
6803: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
6804: fnd_msg_pub.add;
6805: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6806: RAISE fnd_api.g_exc_error;
6807: ELSE
6808: RAISE fnd_api.g_exc_unexpected_error;
6909: -- Unexpected Execution Error from call to Get_contracts_resources
6910: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6911: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6912: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6913: fnd_msg_pub.add;
6914: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
6915: RAISE fnd_api.g_exc_error;
6916: ELSE
6917: RAISE fnd_api.g_exc_unexpected_error;
6921:
6922: IF ( p_calendar_flag = 'Y' AND
6923: x_assign_resources_tbl.count = 0 ) THEN
6924: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
6925: fnd_msg_pub.add;
6926: -- RAISE fnd_api.g_exc_error;
6927: END IF;
6928:
6929: -- check auto assignment
6950: END IF; -- end of auto select flag
6951:
6952: ELSE -- No resources returned from the Territory API
6953: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6954: fnd_msg_pub.add;
6955: -- RAISE fnd_api.g_exc_error;
6956: END IF;
6957:
6958: ELSE -- Territory Flag is NO
6956: END IF;
6957:
6958: ELSE -- Territory Flag is NO
6959: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
6960: fnd_msg_pub.add;
6961: -- RAISE fnd_api.g_exc_error;
6962: END IF;
6963:
6964: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
6985: -- Unexpected Execution Error from call to assign_sr_resource
6986: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6987: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
6988: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');
6989: fnd_msg_pub.add;
6990:
6991: ELSE
6992: x_assign_resources_tbl.delete;
6993: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
6999: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7000: fnd_message.set_token('P_SQLCODE',SQLCODE);
7001: fnd_message.set_token('P_SQLERRM',SQLERRM);
7002: fnd_message.set_token('P_API_NAME',l_api_name);
7003: FND_MSG_PUB.add;
7004: End;
7005:
7006: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
7007:
7038:
7039: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7040: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7041: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7042: fnd_msg_pub.add;
7043: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7044: RAISE fnd_api.g_exc_error;
7045: ELSE
7046: RAISE fnd_api.g_exc_unexpected_error;
7066:
7067: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7068: -- Execution Error from call to Assignment Manager Workflow Hook
7069: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7070: fnd_msg_pub.add;
7071: RAISE fnd_api.g_exc_error;
7072: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7073: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7074: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7071: RAISE fnd_api.g_exc_error;
7072: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7073: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7074: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_unexpected_error;
7077: END IF;
7078:
7079: END IF; -- End of JTF_ASSIGN_CUHK
7086:
7087: /* Standard call to get message count and
7088: the message information */
7089:
7090: FND_MSG_PUB.Count_And_Get
7091: (
7092: p_count => x_msg_count,
7093: p_data => x_msg_data
7094: );
7097:
7098: EXCEPTION
7099: WHEN FND_API.G_EXC_ERROR THEN
7100: x_return_status := FND_API.G_RET_STS_ERROR ;
7101: FND_MSG_PUB.Count_And_Get
7102: (
7103: p_count => x_msg_count,
7104: p_data => x_msg_data
7105: );
7105: );
7106:
7107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7109: FND_MSG_PUB.Count_And_Get
7110: (
7111: p_count => x_msg_count,
7112: p_data => x_msg_data
7113: );
7116: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7117: fnd_message.set_token('P_SQLCODE',SQLCODE);
7118: fnd_message.set_token('P_SQLERRM',SQLERRM);
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;
7121:
7122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7124: FND_MSG_PUB.Add_Exc_Msg
7119: fnd_message.set_token('P_API_NAME',l_api_name);
7120: FND_MSG_PUB.add;
7121:
7122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7124: FND_MSG_PUB.Add_Exc_Msg
7125: (
7126: G_PKG_NAME,
7127: l_api_name
7120: FND_MSG_PUB.add;
7121:
7122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7124: FND_MSG_PUB.Add_Exc_Msg
7125: (
7126: G_PKG_NAME,
7127: l_api_name
7128: );
7127: l_api_name
7128: );
7129: END IF;
7130:
7131: FND_MSG_PUB.Count_And_Get
7132: (
7133: p_count => x_msg_count,
7134: p_data => x_msg_data
7135: );
7318:
7319: /* Initialize message list if p_init_msg_list is set to TRUE */
7320:
7321: IF fnd_api.to_boolean (p_init_msg_list) THEN
7322: fnd_msg_pub.initialize;
7323: END IF;
7324:
7325: x_return_status := fnd_api.g_ret_sts_success;
7326:
7400:
7401: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7402: -- Unexpected Execution Error from call to Territory Manager
7403: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7404: fnd_msg_pub.add;
7405: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7406: RAISE fnd_api.g_exc_error;
7407: ELSE
7408: RAISE fnd_api.g_exc_unexpected_error;
7497: -- Unexpected Execution Error from call to Get_contracts_resources
7498: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7499: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7500: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7501: fnd_msg_pub.add;
7502: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7503: RAISE fnd_api.g_exc_error;
7504: ELSE
7505: RAISE fnd_api.g_exc_unexpected_error;
7509:
7510: IF ( p_calendar_flag = 'Y' AND
7511: x_assign_resources_tbl.count = 0 ) THEN
7512: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
7513: fnd_msg_pub.add;
7514: -- RAISE fnd_api.g_exc_error;
7515: END IF;
7516:
7517:
7538: END IF; -- end of auto select flag
7539:
7540: ELSE -- No resources returned from the Territory API
7541: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7542: fnd_msg_pub.add;
7543: -- RAISE fnd_api.g_exc_error;
7544: END IF;
7545:
7546: ELSE -- Territory Flag is NO
7544: END IF;
7545:
7546: ELSE -- Territory Flag is NO
7547: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
7548: fnd_msg_pub.add;
7549: -- RAISE fnd_api.g_exc_error;
7550: END IF;
7551:
7552: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
7574: -- Unexpected Execution Error from call to assign_sr_resource
7575: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7576: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
7577: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
7578: fnd_msg_pub.add;
7579:
7580: ELSE
7581: x_assign_resources_tbl.delete;
7582: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
7588: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7589: fnd_message.set_token('P_SQLCODE',SQLCODE);
7590: fnd_message.set_token('P_SQLERRM',SQLERRM);
7591: fnd_message.set_token('P_API_NAME',l_api_name);
7592: FND_MSG_PUB.add;
7593: End;
7594:
7595: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
7596:
7626:
7627: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7628: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7629: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7630: fnd_msg_pub.add;
7631: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7632: RAISE fnd_api.g_exc_error;
7633: ELSE
7634: RAISE fnd_api.g_exc_unexpected_error;
7654:
7655: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
7656: -- Execution Error from call to Assignment Manager Workflow Hook
7657: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7658: fnd_msg_pub.add;
7659: RAISE fnd_api.g_exc_error;
7660: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7661: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7662: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7659: RAISE fnd_api.g_exc_error;
7660: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
7661: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
7662: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
7663: fnd_msg_pub.add;
7664: RAISE fnd_api.g_exc_unexpected_error;
7665: END IF;
7666:
7667: END IF; -- End of JTF_ASSIGN_CUHK
7673:
7674: /* Standard call to get message count and
7675: the message information */
7676:
7677: FND_MSG_PUB.Count_And_Get
7678: (
7679: p_count => x_msg_count,
7680: p_data => x_msg_data
7681: );
7684:
7685: EXCEPTION
7686: WHEN FND_API.G_EXC_ERROR THEN
7687: x_return_status := FND_API.G_RET_STS_ERROR ;
7688: FND_MSG_PUB.Count_And_Get
7689: (
7690: p_count => x_msg_count,
7691: p_data => x_msg_data
7692: );
7692: );
7693:
7694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7696: FND_MSG_PUB.Count_And_Get
7697: (
7698: p_count => x_msg_count,
7699: p_data => x_msg_data
7700: );
7703: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
7704: fnd_message.set_token('P_SQLCODE',SQLCODE);
7705: fnd_message.set_token('P_SQLERRM',SQLERRM);
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;
7708:
7709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7711: FND_MSG_PUB.Add_Exc_Msg
7706: fnd_message.set_token('P_API_NAME',l_api_name);
7707: FND_MSG_PUB.add;
7708:
7709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7711: FND_MSG_PUB.Add_Exc_Msg
7712: (
7713: G_PKG_NAME,
7714: l_api_name
7707: FND_MSG_PUB.add;
7708:
7709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
7711: FND_MSG_PUB.Add_Exc_Msg
7712: (
7713: G_PKG_NAME,
7714: l_api_name
7715: );
7714: l_api_name
7715: );
7716: END IF;
7717:
7718: FND_MSG_PUB.Count_And_Get
7719: (
7720: p_count => x_msg_count,
7721: p_data => x_msg_data
7722: );
7844:
7845: /* Initialize message list if p_init_msg_list is set to TRUE */
7846:
7847: IF fnd_api.to_boolean (p_init_msg_list) THEN
7848: fnd_msg_pub.initialize;
7849: END IF;
7850:
7851: x_return_status := fnd_api.g_ret_sts_success;
7852:
7975:
7976: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7977: -- Unexpected Execution Error from call to Territory Manager
7978: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7979: fnd_msg_pub.add;
7980: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7981: RAISE fnd_api.g_exc_error;
7982: ELSE
7983: RAISE fnd_api.g_exc_unexpected_error;
8048:
8049: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8050: -- Unexpected Execution Error from call to Calendar
8051: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
8052: fnd_msg_pub.add;
8053: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8054: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
8055: -- Removed Comment to Show error message Bug # 2919389
8056: RAISE fnd_api.g_exc_error;
8144:
8145: IF ( p_calendar_flag = 'Y' AND
8146: x_assign_resources_tbl.count = 0 ) THEN
8147: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8148: fnd_msg_pub.add;
8149: -- RAISE fnd_api.g_exc_error;
8150: END IF;
8151:
8152: ELSE -- No resources returned from the Territory API
8150: END IF;
8151:
8152: ELSE -- No resources returned from the Territory API
8153: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8154: fnd_msg_pub.add;
8155: -- RAISE fnd_api.g_exc_error;
8156: END IF;
8157:
8158: ELSE -- Territory Flag is NO
8156: END IF;
8157:
8158: ELSE -- Territory Flag is NO
8159: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8160: fnd_msg_pub.add;
8161: -- RAISE fnd_api.g_exc_error;
8162: END IF;
8163:
8164: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
8186: -- Unexpected Execution Error from call to assign_sr_resource
8187: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8188: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8189: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');
8190: fnd_msg_pub.add;
8191:
8192: ELSE
8193: x_assign_resources_tbl.delete;
8194: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
8200: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8201: fnd_message.set_token('P_SQLCODE',SQLCODE);
8202: fnd_message.set_token('P_SQLERRM',SQLERRM);
8203: fnd_message.set_token('P_API_NAME',l_api_name);
8204: FND_MSG_PUB.add;
8205: End;
8206:
8207: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
8208:
8238:
8239: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8240: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8241: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8242: fnd_msg_pub.add;
8243: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8244: RAISE fnd_api.g_exc_error;
8245: ELSE
8246: RAISE fnd_api.g_exc_unexpected_error;
8267:
8268: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8269: -- Execution Error from call to Assignment Manager Workflow Hook
8270: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8271: fnd_msg_pub.add;
8272: RAISE fnd_api.g_exc_error;
8273: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8274: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8275: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8272: RAISE fnd_api.g_exc_error;
8273: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8274: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8275: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8276: fnd_msg_pub.add;
8277: RAISE fnd_api.g_exc_unexpected_error;
8278: END IF;
8279:
8280: END IF; -- End of JTF_ASSIGN_CUHK
8285:
8286: /* Standard call to get message count and
8287: the message information */
8288:
8289: FND_MSG_PUB.Count_And_Get
8290: (
8291: p_count => x_msg_count,
8292: p_data => x_msg_data
8293: );
8296:
8297: EXCEPTION
8298: WHEN FND_API.G_EXC_ERROR THEN
8299: x_return_status := FND_API.G_RET_STS_ERROR ;
8300: FND_MSG_PUB.Count_And_Get
8301: (
8302: p_count => x_msg_count,
8303: p_data => x_msg_data
8304: );
8304: );
8305:
8306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8308: FND_MSG_PUB.Count_And_Get
8309: (
8310: p_count => x_msg_count,
8311: p_data => x_msg_data
8312: );
8315: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8316: fnd_message.set_token('P_SQLCODE',SQLCODE);
8317: fnd_message.set_token('P_SQLERRM',SQLERRM);
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;
8320:
8321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8323: FND_MSG_PUB.Add_Exc_Msg
8318: fnd_message.set_token('P_API_NAME',l_api_name);
8319: FND_MSG_PUB.add;
8320:
8321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8323: FND_MSG_PUB.Add_Exc_Msg
8324: (
8325: G_PKG_NAME,
8326: l_api_name
8319: FND_MSG_PUB.add;
8320:
8321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8323: FND_MSG_PUB.Add_Exc_Msg
8324: (
8325: G_PKG_NAME,
8326: l_api_name
8327: );
8326: l_api_name
8327: );
8328: END IF;
8329:
8330: FND_MSG_PUB.Count_And_Get
8331: (
8332: p_count => x_msg_count,
8333: p_data => x_msg_data
8334: );
8521:
8522: /* Initialize message list if p_init_msg_list is set to TRUE */
8523:
8524: IF fnd_api.to_boolean (p_init_msg_list) THEN
8525: fnd_msg_pub.initialize;
8526: END IF;
8527:
8528: x_return_status := fnd_api.g_ret_sts_success;
8529:
8644:
8645: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8646: -- Unexpected Execution Error from call to Territory Manager
8647: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8648: fnd_msg_pub.add;
8649: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8650: RAISE fnd_api.g_exc_error;
8651: ELSE
8652: RAISE fnd_api.g_exc_unexpected_error;
8759: -- Unexpected Execution Error from call to Get_contracts_resources
8760: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8761: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8762: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8763: fnd_msg_pub.add;
8764: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8765: RAISE fnd_api.g_exc_error;
8766: ELSE
8767: RAISE fnd_api.g_exc_unexpected_error;
8771:
8772: IF ( p_calendar_flag = 'Y' AND
8773: x_assign_resources_tbl.count = 0 ) THEN
8774: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
8775: fnd_msg_pub.add;
8776: -- RAISE fnd_api.g_exc_error;
8777: END IF;
8778:
8779: -- to implement auto selection
8798:
8799: END IF; -- end of auto select flag
8800: ELSE -- No resources returned from the Territory API
8801: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8802: fnd_msg_pub.add;
8803: -- RAISE fnd_api.g_exc_error;
8804: END IF;
8805:
8806: ELSE -- Territory Flag is NO
8804: END IF;
8805:
8806: ELSE -- Territory Flag is NO
8807: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
8808: fnd_msg_pub.add;
8809: -- RAISE fnd_api.g_exc_error;
8810: END IF;
8811:
8812: /********************** Start of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
8833: -- Unexpected Execution Error from call to assign_sr_resource
8834: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8835: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
8836: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');
8837: fnd_msg_pub.add;
8838:
8839: ELSE
8840: x_assign_resources_tbl.delete;
8841: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
8847: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8848: fnd_message.set_token('P_SQLCODE',SQLCODE);
8849: fnd_message.set_token('P_SQLERRM',SQLERRM);
8850: fnd_message.set_token('P_API_NAME',l_api_name);
8851: FND_MSG_PUB.add;
8852: End;
8853:
8854: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
8855:
8886:
8887: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8888: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8889: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8890: fnd_msg_pub.add;
8891: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8892: RAISE fnd_api.g_exc_error;
8893: ELSE
8894: RAISE fnd_api.g_exc_unexpected_error;
8914:
8915: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
8916: -- Execution Error from call to Assignment Manager Workflow Hook
8917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8918: fnd_msg_pub.add;
8919: RAISE fnd_api.g_exc_error;
8920: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8921: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8922: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8919: RAISE fnd_api.g_exc_error;
8920: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
8921: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
8922: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
8923: fnd_msg_pub.add;
8924: RAISE fnd_api.g_exc_unexpected_error;
8925: END IF;
8926:
8927: END IF; -- End of JTF_ASSIGN_CUHK
8933:
8934: /* Standard call to get message count and
8935: the message information */
8936:
8937: FND_MSG_PUB.Count_And_Get
8938: (
8939: p_count => x_msg_count,
8940: p_data => x_msg_data
8941: );
8944:
8945: EXCEPTION
8946: WHEN FND_API.G_EXC_ERROR THEN
8947: x_return_status := FND_API.G_RET_STS_ERROR ;
8948: FND_MSG_PUB.Count_And_Get
8949: (
8950: p_count => x_msg_count,
8951: p_data => x_msg_data
8952: );
8952: );
8953:
8954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8956: FND_MSG_PUB.Count_And_Get
8957: (
8958: p_count => x_msg_count,
8959: p_data => x_msg_data
8960: );
8963: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
8964: fnd_message.set_token('P_SQLCODE',SQLCODE);
8965: fnd_message.set_token('P_SQLERRM',SQLERRM);
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;
8968:
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8970: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8971: FND_MSG_PUB.Add_Exc_Msg
8966: fnd_message.set_token('P_API_NAME',l_api_name);
8967: FND_MSG_PUB.add;
8968:
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8970: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8971: FND_MSG_PUB.Add_Exc_Msg
8972: (
8973: G_PKG_NAME,
8974: l_api_name
8967: FND_MSG_PUB.add;
8968:
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8970: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
8971: FND_MSG_PUB.Add_Exc_Msg
8972: (
8973: G_PKG_NAME,
8974: l_api_name
8975: );
8974: l_api_name
8975: );
8976: END IF;
8977:
8978: FND_MSG_PUB.Count_And_Get
8979: (
8980: p_count => x_msg_count,
8981: p_data => x_msg_data
8982: );
9139:
9140: /* Initialize message list if p_init_msg_list is set to TRUE */
9141:
9142: IF fnd_api.to_boolean (p_init_msg_list) THEN
9143: fnd_msg_pub.initialize;
9144: END IF;
9145:
9146: x_return_status := fnd_api.g_ret_sts_success;
9147:
9194:
9195: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9196: -- Unexpected Execution Error from call to Territory Manager
9197: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9198: fnd_msg_pub.add;
9199: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9200: RAISE fnd_api.g_exc_error;
9201: ELSE
9202: RAISE fnd_api.g_exc_unexpected_error;
9204: END IF;
9205:
9206: ELSE -- Territory Flag is NO
9207: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9208: fnd_msg_pub.add;
9209: -- RAISE fnd_api.g_exc_error;
9210: END IF;
9211:
9212: -- added 2 april 2003 by sudarsana to conver RS_SUPPLIER TO RS_SUPPLIER_CONTACT
9310: -- Unexpected Execution Error from call to Get_contracts_resources
9311: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9312: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9313: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');
9314: fnd_msg_pub.add;
9315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9316: RAISE fnd_api.g_exc_error;
9317: ELSE
9318: RAISE fnd_api.g_exc_unexpected_error;
9323:
9324: IF ( p_calendar_flag = 'Y' AND
9325: x_assign_resources_tbl.count = 0 ) THEN
9326: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
9327: fnd_msg_pub.add;
9328: -- RAISE fnd_api.g_exc_error;
9329: END IF;
9330:
9331: ELSE -- No resources returned from the Territory API
9329: END IF;
9330:
9331: ELSE -- No resources returned from the Territory API
9332: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
9333: fnd_msg_pub.add;
9334: -- RAISE fnd_api.g_exc_error;
9335: END IF;
9336:
9337:
9337:
9338: /* Standard call to get message count and
9339: the message information */
9340:
9341: FND_MSG_PUB.Count_And_Get
9342: (
9343: p_count => x_msg_count,
9344: p_data => x_msg_data
9345: );
9347:
9348: EXCEPTION
9349: WHEN FND_API.G_EXC_ERROR THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR ;
9351: FND_MSG_PUB.Count_And_Get
9352: (
9353: p_count => x_msg_count,
9354: p_data => x_msg_data
9355: );
9355: );
9356:
9357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9359: FND_MSG_PUB.Count_And_Get
9360: (
9361: p_count => x_msg_count,
9362: p_data => x_msg_data
9363: );
9366: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
9367: fnd_message.set_token('P_SQLCODE',SQLCODE);
9368: fnd_message.set_token('P_SQLERRM',SQLERRM);
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;
9371:
9372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
9374: FND_MSG_PUB.Add_Exc_Msg
9369: fnd_message.set_token('P_API_NAME',l_api_name);
9370: FND_MSG_PUB.add;
9371:
9372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
9374: FND_MSG_PUB.Add_Exc_Msg
9375: (
9376: G_PKG_NAME,
9377: l_api_name
9370: FND_MSG_PUB.add;
9371:
9372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
9374: FND_MSG_PUB.Add_Exc_Msg
9375: (
9376: G_PKG_NAME,
9377: l_api_name
9378: );
9377: l_api_name
9378: );
9379: END IF;
9380:
9381: FND_MSG_PUB.Count_And_Get
9382: (
9383: p_count => x_msg_count,
9384: p_data => x_msg_data
9385: );
9641:
9642: /* Initialize message list if p_init_msg_list is set to TRUE */
9643:
9644: IF fnd_api.to_boolean (p_init_msg_list) THEN
9645: fnd_msg_pub.initialize;
9646: END IF;
9647:
9648: x_return_status := fnd_api.g_ret_sts_success;
9649:
9655: OPEN cur_esc_id;
9656: FETCH cur_esc_id INTO l_cur_esc_id;
9657: IF ( cur_esc_id%NOTFOUND ) THEN
9658: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9659: fnd_msg_pub.add;
9660: RAISE fnd_api.g_exc_error;
9661: ELSE
9662: l_esc_source_code := l_cur_esc_id.source_object_type_code;
9663: l_esc_source_id := l_cur_esc_id.source_object_id;
9670:
9671:
9672: IF ( l_esc_source_code <> 'ESC' ) THEN
9673: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9674: fnd_msg_pub.add;
9675: RAISE fnd_api.g_exc_error;
9676: ELSE
9677: OPEN cur_reference_code;
9678: FETCH cur_reference_code INTO l_cur_reference_code;
9677: OPEN cur_reference_code;
9678: FETCH cur_reference_code INTO l_cur_reference_code;
9679: IF ( cur_reference_code%NOTFOUND) THEN
9680: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_ID');
9681: fnd_msg_pub.add;
9682: RAISE fnd_api.g_exc_error;
9683: ELSE
9684: l_reference_code := l_cur_reference_code.reference_code;
9685: l_object_type_code := l_cur_reference_code.object_type_code;
9686: l_object_id := l_cur_reference_code.object_id;
9687:
9688: IF ( l_reference_code <> 'ESC' ) THEN
9689: fnd_message.set_name('JTF', 'JTF_AM_INVALID_ESC_REF');
9690: fnd_msg_pub.add;
9691: RAISE fnd_api.g_exc_error;
9692: END IF;
9693: END IF;
9694: CLOSE cur_reference_code;
9775: FETCH cur_source_task INTO l_territory_id;
9776:
9777: IF ( cur_source_task%NOTFOUND ) THEN
9778: fnd_message.set_name('JTF', 'JTF_AM_INVALID_TASK_ID');
9779: fnd_msg_pub.add;
9780: RAISE fnd_api.g_exc_error;
9781: END IF;
9782:
9783: CLOSE cur_source_task;
9796: FETCH cur_source_sr INTO l_territory_id;
9797:
9798: IF ( cur_source_sr%NOTFOUND ) THEN
9799: fnd_message.set_name('JTF', 'JTF_AM_INVALID_SR_ID');
9800: fnd_msg_pub.add;
9801: RAISE fnd_api.g_exc_error;
9802: END IF;
9803:
9804: CLOSE cur_source_sr;
9820: FETCH cur_source_defect INTO l_territory_id;
9821:
9822: IF ( cur_source_defect%NOTFOUND ) THEN
9823: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DEFECT_ID');
9824: fnd_msg_pub.add;
9825: RAISE fnd_api.g_exc_error;
9826: END IF;
9827:
9828: CLOSE cur_source_defect;
9858:
9859: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9860: -- Unexpected Execution Error from call to Territory Manager
9861: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9862: fnd_msg_pub.add;
9863: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9864: RAISE fnd_api.g_exc_error;
9865: ELSE
9866: RAISE fnd_api.g_exc_unexpected_error;
9892:
9893: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9894: -- Unexpected Execution Error from call to Territory Manager
9895: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9896: fnd_msg_pub.add;
9897: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9898: RAISE fnd_api.g_exc_error;
9899: ELSE
9900: RAISE fnd_api.g_exc_unexpected_error;
9902: END IF;
9903:
9904: --ELSE
9905: --fnd_message.set_name('JTF', 'JTF_AM_NO_ESC_TERR');
9906: --fnd_msg_pub.add;
9907: --RAISE fnd_api.g_exc_error;
9908: END IF;
9909:
9910: END IF; -- IF (l_territory_id IS NOT NULL) THEN
9933:
9934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9935: -- Unexpected Execution Error from call to Territory Manager
9936: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9937: fnd_msg_pub.add;
9938: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9939: RAISE fnd_api.g_exc_error;
9940: ELSE
9941: RAISE fnd_api.g_exc_unexpected_error;
10049: -- Unexpected Execution Error from call to Get_contracts_resources
10050: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10051: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10052: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');
10053: fnd_msg_pub.add;
10054: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10055: RAISE fnd_api.g_exc_error;
10056: ELSE
10057: RAISE fnd_api.g_exc_unexpected_error;
10061:
10062: IF ( p_calendar_flag = 'Y' AND
10063: x_assign_resources_tbl.count = 0 ) THEN
10064: fnd_message.set_name('JTF', 'JTF_AM_RESOURCE_NOT_AVAILABLE');
10065: fnd_msg_pub.add;
10066: -- RAISE fnd_api.g_exc_error;
10067: END IF;
10068:
10069: -- to implement auto selection
10089: END IF; -- end of auto select flag
10090:
10091: ELSE -- No resources returned from the Territory API
10092: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10093: fnd_msg_pub.add;
10094: -- RAISE fnd_api.g_exc_error;
10095: END IF;
10096:
10097: ELSE -- Territory Flag is NO
10095: END IF;
10096:
10097: ELSE -- Territory Flag is NO
10098: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10099: fnd_msg_pub.add;
10100: -- RAISE fnd_api.g_exc_error;
10101: END IF;
10102:
10103: l_esc_record := p_esc_tbl.NEXT(l_esc_record);
10127:
10128: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10129: -- Unexpected Execution Error from call to Territory Manager
10130: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10131: fnd_msg_pub.add;
10132: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10133: RAISE fnd_api.g_exc_error;
10134: ELSE
10135: RAISE fnd_api.g_exc_unexpected_error;
10190: END LOOP;
10191:
10192: ELSE -- l_assign_resources_tbl.COUNT <= 0
10193: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
10194: fnd_msg_pub.add;
10195: -- RAISE fnd_api.g_exc_error;
10196: END IF;
10197:
10198:
10197:
10198:
10199: /*
10200: fnd_message.set_name('JTF', 'JTF_AM_EMPTY_ESC_TBL');
10201: fnd_msg_pub.add;
10202: RAISE fnd_api.g_exc_error;
10203: */
10204:
10205: END IF; -- End of l_esc_tbl.count > 0
10323: -- Unexpected Execution Error from call to assign_sr_resource
10324: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10325: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10326: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10327: fnd_msg_pub.add;
10328: ELSE
10329: x_assign_resources_tbl.delete;
10330: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
10331:
10353: -- Unexpected Execution Error from call to assign_sr_resource
10354: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10355: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10356: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');
10357: fnd_msg_pub.add;
10358: ELSE
10359: x_assign_resources_tbl.delete;
10360: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
10361: END IF;
10367: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10368: fnd_message.set_token('P_SQLCODE',SQLCODE);
10369: fnd_message.set_token('P_SQLERRM',SQLERRM);
10370: fnd_message.set_token('P_API_NAME',l_api_name);
10371: FND_MSG_PUB.add;
10372: End;
10373:
10374: /********************** End of Addition for Enh. No 3076744 by SBARAT, 23/09/2004 ************************/
10375:
10408:
10409: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10410: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10411: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10412: fnd_msg_pub.add;
10413: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
10414: RAISE fnd_api.g_exc_error;
10415: ELSE
10416: RAISE fnd_api.g_exc_unexpected_error;
10438:
10439: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
10440: -- Execution Error from call to Assignment Manager Workflow Hook
10441: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10442: fnd_msg_pub.add;
10443: RAISE fnd_api.g_exc_error;
10444: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10445: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10446: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10443: RAISE fnd_api.g_exc_error;
10444: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
10445: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
10446: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
10447: fnd_msg_pub.add;
10448: RAISE fnd_api.g_exc_unexpected_error;
10449: END IF;
10450:
10451: END IF; -- End of JTF_ASSIGN_CUHK
10456:
10457: /* Standard call to get message count and
10458: the message information */
10459:
10460: FND_MSG_PUB.Count_And_Get
10461: (
10462: p_count => x_msg_count,
10463: p_data => x_msg_data
10464: );
10467:
10468: EXCEPTION
10469: WHEN FND_API.G_EXC_ERROR THEN
10470: x_return_status := FND_API.G_RET_STS_ERROR ;
10471: FND_MSG_PUB.Count_And_Get
10472: (
10473: p_count => x_msg_count,
10474: p_data => x_msg_data
10475: );
10475: );
10476:
10477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10479: FND_MSG_PUB.Count_And_Get
10480: (
10481: p_count => x_msg_count,
10482: p_data => x_msg_data
10483: );
10486: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
10487: fnd_message.set_token('P_SQLCODE',SQLCODE);
10488: fnd_message.set_token('P_SQLERRM',SQLERRM);
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;
10491:
10492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10493: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
10494: FND_MSG_PUB.Add_Exc_Msg
10489: fnd_message.set_token('P_API_NAME',l_api_name);
10490: FND_MSG_PUB.add;
10491:
10492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10493: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
10494: FND_MSG_PUB.Add_Exc_Msg
10495: (
10496: G_PKG_NAME,
10497: l_api_name
10490: FND_MSG_PUB.add;
10491:
10492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10493: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
10494: FND_MSG_PUB.Add_Exc_Msg
10495: (
10496: G_PKG_NAME,
10497: l_api_name
10498: );
10497: l_api_name
10498: );
10499: END IF;
10500:
10501: FND_MSG_PUB.Count_And_Get
10502: (
10503: p_count => x_msg_count,
10504: p_data => x_msg_data
10505: );
10782:
10783: /* Initialize message list if p_init_msg_list is set to TRUE */
10784:
10785: IF fnd_api.to_boolean (p_init_msg_list) THEN
10786: fnd_msg_pub.initialize;
10787: END IF;
10788:
10789:
10790:
10795: OPEN cur_resource_type;
10796: FETCH cur_resource_type INTO l_cur_resource_type;
10797: IF ( cur_resource_type%NOTFOUND) THEN
10798: fnd_message.set_name('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
10799: fnd_msg_pub.add;
10800: RAISE fnd_api.g_exc_error;
10801: END IF;
10802: CLOSE cur_resource_type;
10803: END IF;
10808: OPEN cur_effort_uom;
10809: FETCH cur_effort_uom INTO l_cur_effort_uom;
10810: IF ( cur_effort_uom%NOTFOUND) THEN
10811: fnd_message.set_name('JTF', 'JTF_AM_INVALID_EFFORT_UOM');
10812: fnd_msg_pub.add;
10813: RAISE fnd_api.g_exc_error;
10814: END IF;
10815: CLOSE cur_effort_uom;
10816: END IF;
11148: )
11149: ) THEN
11150:
11151: fnd_message.set_name('JTF', 'JTF_AM_INVALID_DOC_TYPE');
11152: fnd_msg_pub.add;
11153: RAISE fnd_api.g_exc_error;
11154:
11155: END IF;
11156:
11200: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11201: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11202: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_SR_RESOURCES');
11203: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11204: fnd_msg_pub.add;
11205: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11206: RAISE fnd_api.g_exc_error;
11207: ELSE
11208: RAISE fnd_api.g_exc_unexpected_error;
11359:
11360: ELSE
11361: -- No resources returned from the Assignment Manager API for SERVICE REQUESTS
11362: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11363: fnd_msg_pub.add;
11364: -- RAISE fnd_api.g_exc_error;
11365: END IF;
11366:
11367:
11397: -- Unexpected Execution Error from call to assign_sr_resource
11398: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11399: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11400: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11401: fnd_msg_pub.add;
11402: /* Not raising the errors as req by tele service team
11403: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11404: RAISE fnd_api.g_exc_error;
11405: ELSE
11416: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11417: fnd_message.set_token('P_SQLCODE',SQLCODE);
11418: fnd_message.set_token('P_SQLERRM',SQLERRM);
11419: fnd_message.set_token('P_API_NAME',l_api_name);
11420: FND_MSG_PUB.add;
11421: end;
11422:
11423: -- ================code added for bug 6453896==========================
11424: -- =============== This code is added for sorting table based on territory ranking===========
11473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11474: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11475: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_TASK_RESOURCES');
11476: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11477: fnd_msg_pub.add;
11478: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11479: RAISE fnd_api.g_exc_error;
11480: ELSE
11481: RAISE fnd_api.g_exc_unexpected_error;
11653: END IF; -- Auto Select Flag
11654:
11655: ELSE -- No resources returned from the Assignment Manager API for TASKS
11656: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11657: fnd_msg_pub.add;
11658: -- RAISE fnd_api.g_exc_error;
11659: END IF;
11660:
11661: -- raise workfow event
11683: -- Unexpected Execution Error from call to assign_sr_resource
11684: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11685: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11686: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11687: fnd_msg_pub.add;
11688:
11689: ELSE
11690: x_assign_resources_tbl.delete;
11691: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
11696: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11697: fnd_message.set_token('P_SQLCODE',SQLCODE);
11698: fnd_message.set_token('P_SQLERRM',SQLERRM);
11699: fnd_message.set_token('P_API_NAME',l_api_name);
11700: FND_MSG_PUB.add;
11701: End;
11702:
11703: -- ================code added for bug 6453896==========================
11704: -- =============== This code is added for sorting table based on territory ranking===========
11745: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11746: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11747: fnd_message.set_token('P_PROC_NAME','GET_ASSIGN_DEFECT_RESOURCES');
11748: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11749: fnd_msg_pub.add;
11750: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11751: RAISE fnd_api.g_exc_error;
11752: ELSE
11753: RAISE fnd_api.g_exc_unexpected_error;
11833: END LOOP;
11834:
11835: ELSE -- No resources returned from the Assignment Manager API for DEFECTS
11836: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');
11837: fnd_msg_pub.add;
11838: -- RAISE fnd_api.g_exc_error;
11839: END IF;
11840:
11841: -- raise workfow event
11863: -- Unexpected Execution Error from call to assign_sr_resource
11864: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11865: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11866: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');
11867: fnd_msg_pub.add;
11868:
11869: ELSE
11870: x_assign_resources_tbl.delete;
11871: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;
11877: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11878: fnd_message.set_token('P_SQLCODE',SQLCODE);
11879: fnd_message.set_token('P_SQLERRM',SQLERRM);
11880: fnd_message.set_token('P_API_NAME',l_api_name);
11881: FND_MSG_PUB.add;
11882: End;
11883:
11884:
11885: END IF; -- End of UPPER(l_calling_doc_type)= 'SR'- 'TASK'- 'DEF'
11914:
11915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
11916: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11917: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11918: fnd_msg_pub.add;
11919: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11920: RAISE fnd_api.g_exc_error;
11921: ELSE
11922: RAISE fnd_api.g_exc_unexpected_error;
11944:
11945: IF (l_return_code = fnd_api.g_ret_sts_error) THEN
11946: -- Execution Error from call to Assignment Manager Workflow Hook
11947: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11948: fnd_msg_pub.add;
11949: RAISE fnd_api.g_exc_error;
11950: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
11951: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11952: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11949: RAISE fnd_api.g_exc_error;
11950: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_error) THEN
11951: -- Unexpected Execution Error from call to Assignment Manager Workflow Hook
11952: fnd_message.set_name('JTF', 'JTF_AM_ERROR_WF_API');
11953: fnd_msg_pub.add;
11954: RAISE fnd_api.g_exc_unexpected_error;
11955: END IF;
11956:
11957: END IF; -- End of JTF_ASSIGN_CUHK
11961:
11962: /* Standard call to get message count and
11963: the message information */
11964:
11965: FND_MSG_PUB.Count_And_Get
11966: (
11967: p_count => x_msg_count,
11968: p_data => x_msg_data
11969: );
11975:
11976: EXCEPTION
11977: WHEN FND_API.G_EXC_ERROR THEN
11978: x_return_status := FND_API.G_RET_STS_ERROR ;
11979: FND_MSG_PUB.Count_And_Get
11980: (
11981: p_count => x_msg_count,
11982: p_data => x_msg_data
11983: );
11983: );
11984:
11985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11987: FND_MSG_PUB.Count_And_Get
11988: (
11989: p_count => x_msg_count,
11990: p_data => x_msg_data
11991: );
11994: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
11995: fnd_message.set_token('P_SQLCODE',SQLCODE);
11996: fnd_message.set_token('P_SQLERRM',SQLERRM);
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;
11999:
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12002: FND_MSG_PUB.Add_Exc_Msg
11997: fnd_message.set_token('P_API_NAME',l_api_name);
11998: FND_MSG_PUB.add;
11999:
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12002: FND_MSG_PUB.Add_Exc_Msg
12003: (
12004: G_PKG_NAME,
12005: l_api_name
11998: FND_MSG_PUB.add;
11999:
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12002: FND_MSG_PUB.Add_Exc_Msg
12003: (
12004: G_PKG_NAME,
12005: l_api_name
12006: );
12005: l_api_name
12006: );
12007: END IF;
12008:
12009: FND_MSG_PUB.Count_And_Get
12010: (
12011: p_count => x_msg_count,
12012: p_data => x_msg_data
12013: );
12090:
12091: /* Initialize message list if p_init_msg_list is set to TRUE */
12092:
12093: IF fnd_api.to_boolean (p_init_msg_list) THEN
12094: fnd_msg_pub.initialize;
12095: END IF;
12096:
12097: x_return_status := fnd_api.g_ret_sts_success;
12098:
12217: -- Unexpected Execution Error from call to Get_contracts_resources
12218: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12219: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12220: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');
12221: fnd_msg_pub.add;
12222: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12223: RAISE fnd_api.g_exc_error;
12224: ELSE
12225: RAISE fnd_api.g_exc_unexpected_error;
12251: -- Unexpected Execution Error from call to Get_contracts_resources
12252: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12253: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12254: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');
12255: fnd_msg_pub.add;
12256: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12257: RAISE fnd_api.g_exc_error;
12258: ELSE
12259: RAISE fnd_api.g_exc_unexpected_error;
12268:
12269: EXCEPTION
12270: WHEN FND_API.G_EXC_ERROR THEN
12271: x_return_status := FND_API.G_RET_STS_ERROR ;
12272: FND_MSG_PUB.Count_And_Get
12273: (
12274: p_count => x_msg_count,
12275: p_data => x_msg_data
12276: );
12276: );
12277:
12278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12280: FND_MSG_PUB.Count_And_Get
12281: (
12282: p_count => x_msg_count,
12283: p_data => x_msg_data
12284: );
12287: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12288: fnd_message.set_token('P_SQLCODE',SQLCODE);
12289: fnd_message.set_token('P_SQLERRM',SQLERRM);
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;
12292:
12293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12295: FND_MSG_PUB.Add_Exc_Msg
12290: fnd_message.set_token('P_API_NAME',l_api_name);
12291: FND_MSG_PUB.add;
12292:
12293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12295: FND_MSG_PUB.Add_Exc_Msg
12296: (
12297: G_PKG_NAME,
12298: l_api_name
12291: FND_MSG_PUB.add;
12292:
12293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12295: FND_MSG_PUB.Add_Exc_Msg
12296: (
12297: G_PKG_NAME,
12298: l_api_name
12299: );
12298: l_api_name
12299: );
12300: END IF;
12301:
12302: FND_MSG_PUB.Count_And_Get
12303: (
12304: p_count => x_msg_count,
12305: p_data => x_msg_data
12306: );
12346:
12347: /* Initialize message list if p_init_msg_list is set to TRUE */
12348: IF fnd_api.to_boolean (p_init_msg_list)
12349: THEN
12350: fnd_msg_pub.initialize;
12351: END IF;
12352:
12353: x_return_status := fnd_api.g_ret_sts_success;
12354:
12378: -- Unexpected Execution Error from call to Get_contracts_resources
12379: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12380: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12381: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');
12382: fnd_msg_pub.add;
12383: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12384: RAISE fnd_api.g_exc_error;
12385: ELSE
12386: RAISE fnd_api.g_exc_unexpected_error;
12392:
12393: EXCEPTION
12394: WHEN FND_API.G_EXC_ERROR THEN
12395: x_return_status := FND_API.G_RET_STS_ERROR ;
12396: FND_MSG_PUB.Count_And_Get
12397: (
12398: p_count => x_msg_count,
12399: p_data => x_msg_data
12400: );
12400: );
12401:
12402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12404: FND_MSG_PUB.Count_And_Get
12405: (
12406: p_count => x_msg_count,
12407: p_data => x_msg_data
12408: );
12411: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
12412: fnd_message.set_token('P_SQLCODE',SQLCODE);
12413: fnd_message.set_token('P_SQLERRM',SQLERRM);
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;
12416:
12417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12419: FND_MSG_PUB.Add_Exc_Msg
12414: fnd_message.set_token('P_API_NAME',l_api_name);
12415: FND_MSG_PUB.add;
12416:
12417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12419: FND_MSG_PUB.Add_Exc_Msg
12420: (
12421: G_PKG_NAME,
12422: l_api_name
12415: FND_MSG_PUB.add;
12416:
12417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
12419: FND_MSG_PUB.Add_Exc_Msg
12420: (
12421: G_PKG_NAME,
12422: l_api_name
12423: );
12422: l_api_name
12423: );
12424: END IF;
12425:
12426: FND_MSG_PUB.Count_And_Get
12427: (
12428: p_count => x_msg_count,
12429: p_data => x_msg_data
12430: );