eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_ASSIGN_PUB dependencies on FND_API

Line 39: -- FND_API variables

35: -- Added Dynamic SQL for the cs_incidents_all_vl
36: --
37: -- : 04/05/00 ** VVUYYURU ** Vijay Vuyyuru **
38: -- Added Functions to get the default values of
39: -- FND_API variables
40: --
41: -- : 04/14/00 ** VVUYYURU ** Vijay Vuyyuru **
42: -- Added the procedure for Escalations
43: --

Line 100: -- Functions : These functions are to get the FND_API default values.

96: -- *******************************************************************************
97:
98: -- Start of comments
99:
100: -- Functions : These functions are to get the FND_API default values.
101:
102: -- End of comments
103:
104: -- *******************************************************************************

Line 115: RETURN (FND_API.g_miss_num);

111:
112: FUNCTION am_miss_num RETURN NUMBER IS
113:
114: BEGIN
115: RETURN (FND_API.g_miss_num);
116: END am_miss_num;
117:
118:
119: FUNCTION am_miss_char RETURN VARCHAR2 IS

Line 122: RETURN (FND_API.g_miss_char);

118:
119: FUNCTION am_miss_char RETURN VARCHAR2 IS
120:
121: BEGIN
122: RETURN (FND_API.g_miss_char);
123: END am_miss_char;
124:
125:
126: FUNCTION am_miss_date RETURN DATE IS

Line 129: RETURN (FND_API.g_miss_date);

125:
126: FUNCTION am_miss_date RETURN DATE IS
127:
128: BEGIN
129: RETURN (FND_API.g_miss_date);
130: END am_miss_date;
131:
132:
133: FUNCTION am_false RETURN VARCHAR2 IS

Line 136: RETURN (FND_API.g_false);

132:
133: FUNCTION am_false RETURN VARCHAR2 IS
134:
135: BEGIN
136: RETURN (FND_API.g_false);
137: END am_false;
138:
139:
140: FUNCTION am_true RETURN VARCHAR2 IS

Line 143: RETURN (FND_API.g_true);

139:
140: FUNCTION am_true RETURN VARCHAR2 IS
141:
142: BEGIN
143: RETURN (FND_API.g_true);
144: END am_true;
145:
146:
147: FUNCTION am_valid_level_full RETURN VARCHAR2 IS

Line 150: RETURN (FND_API.g_valid_level_full);

146:
147: FUNCTION am_valid_level_full RETURN VARCHAR2 IS
148:
149: BEGIN
150: RETURN (FND_API.g_valid_level_full);
151: END am_valid_level_full;
152:
153:
154:

Line 944: x_return_status := fnd_api.g_ret_sts_success;

940:
941:
942: BEGIN
943: -- initialize the variables
944: x_return_status := fnd_api.g_ret_sts_success;
945: l_current_rec := 0;
946: l_resources_tbl.delete;
947:
948: -- Added by SBARAT on 21/04/2005 for Bug-4300801

Line 1002: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

998:
999: -- set back the API name to original name
1000: l_api_name := l_api_name_1;
1001:
1002: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1003: -- Unexpected Execution Error from call to Calendar
1004: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1005: fnd_msg_pub.add;
1006: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 1006: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
1010: ELSE

Line 1009: RAISE fnd_api.g_exc_error;

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;
1010: ELSE
1011: RAISE fnd_api.g_exc_unexpected_error;
1012: END IF;
1013: END IF;

Line 1011: RAISE fnd_api.g_exc_unexpected_error;

1007: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
1008: -- Removed Comment to Show error message Bug # 2919389
1009: RAISE fnd_api.g_exc_error;
1010: ELSE
1011: RAISE fnd_api.g_exc_unexpected_error;
1012: END IF;
1013: END IF;
1014:
1015: -- Put the records into the PL/SQL Table.

Line 1077: WHEN FND_API.G_EXC_ERROR THEN

1073:
1074: END IF;
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,

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR ;

1074: END IF;
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

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1081: p_count => x_msg_count,
1082: p_data => x_msg_data
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,

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1082: p_data => x_msg_data
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

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1103: (
1104: G_PKG_NAME,

Line 1198: x_return_status := fnd_api.g_ret_sts_success;

1194: commit;
1195: end;*/
1196: BEGIN
1197: -- initialize the variables
1198: x_return_status := fnd_api.g_ret_sts_success;
1199: l_current_rec := 0;
1200: l_resources_tbl.delete;
1201: JTF_ASSIGN_PUB.g_resource_avail.delete;
1202:

Line 1338: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1334:
1335: -- set back the API name to original name
1336: l_api_name := l_api_name_1;
1337:
1338: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1339: -- Unexpected Execution Error from call to Calendar
1340: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1341: fnd_msg_pub.add;
1342:

Line 1343: IF (x_return_status = fnd_api.g_ret_sts_error) 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
1346: RAISE fnd_api.g_exc_error;
1347:

Line 1346: RAISE fnd_api.g_exc_error;

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
1346: RAISE fnd_api.g_exc_error;
1347:
1348: ELSE
1349: RAISE fnd_api.g_exc_unexpected_error;
1350:

Line 1349: RAISE fnd_api.g_exc_unexpected_error;

1345: -- Removed Comment to Show error message Bug # 2919389
1346: RAISE fnd_api.g_exc_error;
1347:
1348: ELSE
1349: RAISE fnd_api.g_exc_unexpected_error;
1350:
1351: END IF;
1352: END IF;
1353:

Line 1513: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1509: --dbms_output.put_line('Slots are ...'||to_char(x_assign_resources_tbl(l_current_rec).resource_id)||'...'||to_char(l_x_planned_end_date, 'DD-MON-YYYY HH24:MI'));
1510: -- set back the API name to original name
1511: l_api_name := l_api_name_1;
1512:
1513: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1514: -- Unexpected Execution Error from call to Calendar
1515: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
1516: fnd_msg_pub.add;
1517: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 1517: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
1521:

Line 1520: RAISE fnd_api.g_exc_error;

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;
1521:
1522: ELSE
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;

Line 1523: RAISE fnd_api.g_exc_unexpected_error;

1519: -- Removed Comment to Show error message Bug # 2919389
1520: RAISE fnd_api.g_exc_error;
1521:
1522: ELSE
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: END IF;
1526: if(l_x_shift_construct_id is not null)
1527: then

Line 1624: WHEN FND_API.G_EXC_ERROR THEN

1620: --Added for Bug # 5573916 Ends here
1621: END IF; -- if x_assign_resurces_tbl count > 0 check
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,

Line 1625: x_return_status := FND_API.G_RET_STS_ERROR ;

1621: END IF; -- if x_assign_resurces_tbl count > 0 check
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

Line 1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1628: p_count => x_msg_count,
1629: p_data => x_msg_data
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,

Line 1633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1629: p_data => x_msg_data
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

Line 1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1650: (
1651: G_PKG_NAME,

Line 1750: x_return_status := fnd_api.g_ret_sts_success;

1746: l_excl_record NUMBER := 0;
1747:
1748: BEGIN
1749:
1750: x_return_status := fnd_api.g_ret_sts_success;
1751:
1752: OPEN cur_contracts_installed;
1753: FETCH cur_contracts_installed INTO l_cur_contracts_installed;
1754: CLOSE cur_contracts_installed;

Line 1765: RAISE fnd_api.g_exc_error;

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
1769: (

Line 1778: RAISE fnd_api.g_exc_error;

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');
1782: fnd_msg_pub.add;

Line 1783: 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:
1787: IF(x_excluded_tbl.count > 0)

Line 1836: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

1832: :5 := l_msg_data;
1833: :6 := l_return_status;
1834:
1835:
1836: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1837: -- Unexpected Execution Error from call to Contracts API
1838: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_CONTRACTS_API'||''''||');'||
1839: 'fnd_msg_pub.add;
1840: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

Line 1840: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

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;
1844: END IF;

Line 1841: RAISE fnd_api.g_exc_error;

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;
1844: END IF;
1845: END IF;

Line 1843: RAISE fnd_api.g_exc_unexpected_error;

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;
1844: END IF;
1845: END IF;
1846:
1847: /* Procedure for Copying out the TABLE contents

Line 2043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2039:
2040: -- set back the API name to original name
2041: l_api_name := l_api_name_1;
2042:
2043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2044: -- Unexpected Execution Error from call to Get_contracts_resources
2045: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2046: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2047: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');

Line 2049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
2053: END IF;

Line 2050: RAISE fnd_api.g_exc_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;
2053: END IF;
2054: END IF; -- end of x_return_status check

Line 2052: RAISE fnd_api.g_exc_unexpected_error;

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;
2053: END IF;
2054: END IF; -- end of x_return_status check
2055: -- end if; -- if p_calendar_flag = Y
2056: end if; --l_preferred_engineers_tbl.COUNT > 0

Line 2060: WHEN FND_API.G_EXC_ERROR THEN

2056: end if; --l_preferred_engineers_tbl.COUNT > 0
2057:
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,

Line 2061: x_return_status := FND_API.G_RET_STS_ERROR ;

2057:
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

Line 2068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2064: p_count => x_msg_count,
2065: p_data => x_msg_data
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,

Line 2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2065: p_data => x_msg_data
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

Line 2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
2086: (
2087: G_PKG_NAME,

Line 2214: x_return_status := fnd_api.g_ret_sts_success;

2210:
2211:
2212: BEGIN
2213:
2214: x_return_status := fnd_api.g_ret_sts_success;
2215:
2216: l_pref_record := 0;
2217:
2218: -- added by sudarsana on 30th nov 2001

Line 2485: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2481:
2482: -- set back the API name to original name
2483: l_api_name := l_api_name_1;
2484:
2485: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2486: -- Unexpected Execution Error from call to Get_contracts_resources
2487: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2488: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
2489: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_IB_RESOURCES');

Line 2491: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
2495: END IF;

Line 2492: RAISE fnd_api.g_exc_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;
2495: END IF;
2496: END IF; -- end of x_return_status check

Line 2494: RAISE fnd_api.g_exc_unexpected_error;

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;
2495: END IF;
2496: END IF; -- end of x_return_status check
2497: -- end if; -- end if p_calendar_flag
2498: end if; --l_preferred_engineers_tbl.COUNT > 0

Line 2502: WHEN FND_API.G_EXC_ERROR THEN

2498: end if; --l_preferred_engineers_tbl.COUNT > 0
2499:
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,

Line 2503: x_return_status := FND_API.G_RET_STS_ERROR ;

2499:
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

Line 2510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2506: p_count => x_msg_count,
2507: p_data => x_msg_data
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,

Line 2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2507: p_data => x_msg_data
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

Line 2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
2528: (
2529: G_PKG_NAME,

Line 2558: -- DEFAULT = FND_API.G_FALSE

2554: -- Parameters :
2555:
2556: -- IN : p_api_version IN NUMBER Required
2557: -- p_init_msg_list IN VARCHAR2 Optional
2558: -- DEFAULT = FND_API.G_FALSE
2559: -- p_commit IN VARCHAR2 optional
2560: -- DEFAULT = FND_API.G_FALSE
2561:
2562: -- Assignment Manager Specific Parameters

Line 2560: -- DEFAULT = FND_API.G_FALSE

2556: -- IN : p_api_version IN NUMBER Required
2557: -- p_init_msg_list IN VARCHAR2 Optional
2558: -- DEFAULT = FND_API.G_FALSE
2559: -- p_commit IN VARCHAR2 optional
2560: -- DEFAULT = FND_API.G_FALSE
2561:
2562: -- Assignment Manager Specific Parameters
2563:
2564: -- This determines the Resource Type required by the

Line 2794: IF NOT fnd_api.compatible_api_call (l_api_version,

2790:
2791:
2792: /* Standard call to check for call compatibility */
2793:
2794: IF NOT fnd_api.compatible_api_call (l_api_version,
2795: p_api_version,
2796: l_api_name,
2797: g_pkg_name) THEN
2798: RAISE fnd_api.g_exc_unexpected_error;

Line 2798: RAISE fnd_api.g_exc_unexpected_error;

2794: IF NOT fnd_api.compatible_api_call (l_api_version,
2795: p_api_version,
2796: l_api_name,
2797: g_pkg_name) THEN
2798: RAISE fnd_api.g_exc_unexpected_error;
2799: END IF;
2800:
2801:
2802: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 2804: IF fnd_api.to_boolean (p_init_msg_list) THEN

2800:
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;

Line 2808: x_return_status := fnd_api.g_ret_sts_success;

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:
2810:
2811:
2812: /* Get TASK source and the related information for contracts and

Line 2824: RAISE fnd_api.g_exc_error;

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;
2828: l_planned_start_date := l_cur_task_id.planned_start_date;

Line 2862: RAISE fnd_api.g_exc_error;

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;
2866: END IF;

Line 2924: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2920: p_calendar_check => p_calendar_check
2921: --Added for Bug # 5573916 Ends here
2922: );
2923:
2924: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2925: -- Unexpected Execution Error from call to Get_contracts_resources
2926: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2927: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
2928: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

Line 2930: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
2934: END IF;

Line 2931: RAISE fnd_api.g_exc_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;
2934: END IF;
2935: END IF;

Line 2933: RAISE fnd_api.g_exc_unexpected_error;

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;
2934: END IF;
2935: END IF;
2936:
2937: END IF; -- p_contracts_preferred_engineer = 'Y'

Line 2966: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2962: p_calendar_check => p_calendar_check
2963: --Added for Bug # 5573916 Ends here
2964: );
2965:
2966: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2967: -- Unexpected Execution Error from call to Get_contracts_resources
2968: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
2969: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
2970: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

Line 2972: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
2976: END IF;

Line 2973: RAISE fnd_api.g_exc_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;
2976: END IF;
2977: END IF;

Line 2975: RAISE fnd_api.g_exc_unexpected_error;

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;
2976: END IF;
2977: END IF;
2978:
2979: END IF; -- p_ib_preferred_engineer = 'Y'

Line 3031: RAISE fnd_api.g_exc_error;

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 */
3035:

Line 3083: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3079:
3080: -- set back the API name to original name
3081: l_api_name := l_api_name_1;
3082:
3083: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3084: -- Unexpected Execution Error from call to Territory Manager
3085: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3086: fnd_msg_pub.add;
3087: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3087: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
3091: END IF;

Line 3088: RAISE fnd_api.g_exc_error;

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;
3091: END IF;
3092: END IF;

Line 3090: RAISE fnd_api.g_exc_unexpected_error;

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;
3091: END IF;
3092: END IF;
3093: -- added 2 april 2003 by sudarsana to conver RS_SUPPLIER TO RS_SUPPLIER_CONTACT
3094: IF(l_assign_resources_tbl.COUNT > 0)

Line 3186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3182:
3183: -- set back the API name to original name
3184: l_api_name := l_api_name_1;
3185:
3186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3187: -- Unexpected Execution Error from call to Get_contracts_resources
3188: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3189: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3190: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

Line 3192: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
3196: END IF;

Line 3193: RAISE fnd_api.g_exc_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;
3196: END IF;
3197: END IF; -- end of x_return_status check

Line 3195: RAISE fnd_api.g_exc_unexpected_error;

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;
3196: END IF;
3197: END IF; -- end of x_return_status check
3198: -- end if; -- if p_calendar_flag = Y
3199:

Line 3204: -- RAISE fnd_api.g_exc_error;

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
3208: IF(p_filter_excluded_resource = 'Y')

Line 3217: -- RAISE fnd_api.g_exc_error;

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
3221: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 3223: -- RAISE fnd_api.g_exc_error;

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'
3227:

Line 3299: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3295:
3296: -- set back the API name to original name
3297: l_api_name := l_api_name_1;
3298:
3299: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3300: -- Unexpected Execution Error from call to Territory Manager for TASKS
3301: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
3302: fnd_msg_pub.add;
3303: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 3303: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
3307: END IF;

Line 3304: RAISE fnd_api.g_exc_error;

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;
3307: END IF;
3308: END IF;

Line 3306: RAISE fnd_api.g_exc_unexpected_error;

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;
3307: END IF;
3308: END IF;
3309:
3310:

Line 3403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3399:
3400: -- set back the API name to original name
3401: l_api_name := l_api_name_1;
3402:
3403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3404: -- Unexpected Execution Error from call to Get_contracts_resources
3405: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
3406: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
3407: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

Line 3409: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
3413: END IF;

Line 3410: RAISE fnd_api.g_exc_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;
3413: END IF;
3414: END IF; -- end of x_return_status check

Line 3412: RAISE fnd_api.g_exc_unexpected_error;

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;
3413: END IF;
3414: END IF; -- end of x_return_status check
3415: -- end if; -- if p_calendar_flag = Y
3416:

Line 3421: -- RAISE fnd_api.g_exc_error;

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
3425: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 3427: -- RAISE fnd_api.g_exc_error;

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
3431:

Line 3545: WHEN FND_API.G_EXC_ERROR THEN

3541:
3542:
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,

Line 3546: x_return_status := FND_API.G_RET_STS_ERROR ;

3542:
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

Line 3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3549: p_count => x_msg_count,
3550: p_data => x_msg_data
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,

Line 3554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3550: p_data => x_msg_data
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

Line 3567: x_return_status := FND_API.G_RET_STS_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: (
3571: G_PKG_NAME,

Line 3602: -- DEFAULT = FND_API.G_FALSE

3598: -- Parameters :
3599:
3600: -- IN : p_api_version IN NUMBER Required
3601: -- p_init_msg_list IN VARCHAR2 Optional
3602: -- DEFAULT = FND_API.G_FALSE
3603: -- p_commit IN VARCHAR2 optional
3604: -- DEFAULT = FND_API.G_FALSE
3605:
3606: -- Assignment Manager Specific Parameters

Line 3604: -- DEFAULT = FND_API.G_FALSE

3600: -- IN : p_api_version IN NUMBER Required
3601: -- p_init_msg_list IN VARCHAR2 Optional
3602: -- DEFAULT = FND_API.G_FALSE
3603: -- p_commit IN VARCHAR2 optional
3604: -- DEFAULT = FND_API.G_FALSE
3605:
3606: -- Assignment Manager Specific Parameters
3607:
3608: -- This determines the Resource Type required by the

Line 3850: IF NOT fnd_api.compatible_api_call (l_api_version,

3846:
3847:
3848: /* Standard call to check for call compatibility */
3849:
3850: IF NOT fnd_api.compatible_api_call (l_api_version,
3851: p_api_version,
3852: l_api_name,
3853: g_pkg_name) THEN
3854: RAISE fnd_api.g_exc_unexpected_error;

Line 3854: RAISE fnd_api.g_exc_unexpected_error;

3850: IF NOT fnd_api.compatible_api_call (l_api_version,
3851: p_api_version,
3852: l_api_name,
3853: g_pkg_name) THEN
3854: RAISE fnd_api.g_exc_unexpected_error;
3855: END IF;
3856:
3857: /* Initialize message list if p_init_msg_list is set to TRUE */
3858:

Line 3859: IF fnd_api.to_boolean (p_init_msg_list) THEN

3855: END IF;
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:

Line 3864: x_return_status := fnd_api.g_ret_sts_success;

3860: fnd_msg_pub.initialize;
3861: END IF;
3862:
3863:
3864: x_return_status := fnd_api.g_ret_sts_success;
3865:
3866:
3867: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
3868: l_p_resource_type := 'RS_INDIVIDUAL';

Line 3948: RAISE fnd_api.g_exc_error;

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';
3952: */

Line 4003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3999: p_calendar_check => p_calendar_check
4000: --Added for Bug # 5573916 Ends here
4001: );
4002:
4003: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4004: -- Unexpected Execution Error from call to Get_contracts_resources
4005: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4006: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
4007: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

Line 4009: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4013: END IF;

Line 4010: RAISE fnd_api.g_exc_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;
4013: END IF;
4014: END IF;

Line 4012: RAISE fnd_api.g_exc_unexpected_error;

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;
4013: END IF;
4014: END IF;
4015: END IF;
4016:

Line 4040: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

4036: p_calendar_check => p_calendar_check
4037: --Added for Bug # 5573916 Ends here
4038: );
4039:
4040: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4041: -- Unexpected Execution Error from call to Get_contracts_resources
4042: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4043: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
4044: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

Line 4046: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4050: END IF;

Line 4047: RAISE fnd_api.g_exc_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;
4050: END IF;
4051: END IF;

Line 4049: RAISE fnd_api.g_exc_unexpected_error;

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;
4050: END IF;
4051: END IF;
4052:
4053: END IF; -- p_ib_preferred_engineer = 'Y'

Line 4082: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 4088: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4092: END IF;

Line 4089: RAISE fnd_api.g_exc_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;
4092: END IF;
4093: END IF;

Line 4091: RAISE fnd_api.g_exc_unexpected_error;

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;
4092: END IF;
4093: END IF;
4094:
4095: end IF; -- end of security check for contracts resource

Line 4107: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 4113: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4117: END IF;

Line 4114: RAISE fnd_api.g_exc_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;
4117: END IF;
4118: END IF;

Line 4116: RAISE fnd_api.g_exc_unexpected_error;

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;
4117: END IF;
4118: END IF;
4119:
4120: end IF; -- end of security check for contracts resource

Line 4304: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

4300:
4301: -- set back the API name to original name
4302: l_api_name := l_api_name_1;
4303:
4304: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4305: -- Unexpected Execution Error from call to Territory Manager
4306: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
4307: fnd_msg_pub.add;
4308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 4308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4312: END IF;

Line 4309: RAISE fnd_api.g_exc_error;

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;
4312: END IF;
4313: END IF;

Line 4311: RAISE fnd_api.g_exc_unexpected_error;

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;
4312: END IF;
4313: END IF;
4314:
4315: -- added 2 april 2003 by sudarsana to convert RS_SUPPLIER TO RS_SUPPLIER_CONTACT

Line 4433: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 4437: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4441: END IF;

Line 4438: RAISE fnd_api.g_exc_error;

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;
4441: END IF;
4442: END IF;

Line 4440: RAISE fnd_api.g_exc_unexpected_error;

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;
4441: END IF;
4442: END IF;
4443:
4444: -- added 2 april 2003 by sudarsana to conver RS_SUPPLIER TO RS_SUPPLIER_CONTACT

Line 4551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

4547:
4548: -- set back the API name to original name
4549: l_api_name := l_api_name_1;
4550:
4551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4552: -- Unexpected Execution Error from call to Get_contracts_resources
4553: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
4554: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
4555: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

Line 4557: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4561: END IF;

Line 4558: RAISE fnd_api.g_exc_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;
4561: END IF;
4562: END IF; -- end of x_return_status check

Line 4560: RAISE fnd_api.g_exc_unexpected_error;

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;
4561: END IF;
4562: END IF; -- end of x_return_status check
4563: -- end if; -- if p_calendar_flag = Y
4564:

Line 4570: -- RAISE fnd_api.g_exc_error;

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:
4574: -- remove excluded resources from territory qualifeid resource list

Line 4593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 4599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
4603: END IF;

Line 4600: RAISE fnd_api.g_exc_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;
4603: END IF;
4604: END IF;

Line 4602: RAISE fnd_api.g_exc_unexpected_error;

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;
4603: END IF;
4604: END IF;
4605: END IF; -- end of security check
4606: ELSE -- No resources returned from the Territory API

Line 4610: -- RAISE fnd_api.g_exc_error;

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:
4614: -- Logic for getting resources belonging to group id passed in

Line 4928: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)

4924: x_msg_data => x_msg_data );
4925:
4926: -- set back the API name to original name
4927: l_api_name := l_api_name_1;
4928: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
4929: then
4930: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
4931: RAISE fnd_api.g_exc_error;
4932: ELSE

Line 4930: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN

4926: -- set back the API name to original name
4927: l_api_name := l_api_name_1;
4928: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
4929: then
4930: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
4931: RAISE fnd_api.g_exc_error;
4932: ELSE
4933: RAISE fnd_api.g_exc_unexpected_error;
4934: END IF;

Line 4931: RAISE fnd_api.g_exc_error;

4927: l_api_name := l_api_name_1;
4928: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
4929: then
4930: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
4931: RAISE fnd_api.g_exc_error;
4932: ELSE
4933: RAISE fnd_api.g_exc_unexpected_error;
4934: END IF;
4935: end if;

Line 4933: RAISE fnd_api.g_exc_unexpected_error;

4929: then
4930: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
4931: RAISE fnd_api.g_exc_error;
4932: ELSE
4933: RAISE fnd_api.g_exc_unexpected_error;
4934: END IF;
4935: end if;
4936:
4937: -- End of enhancement

Line 4954: WHEN FND_API.G_EXC_ERROR THEN

4950:
4951:
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,

Line 4955: x_return_status := FND_API.G_RET_STS_ERROR ;

4951:
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

Line 4962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4958: p_count => x_msg_count,
4959: p_data => x_msg_data
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,

Line 4963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4959: p_data => x_msg_data
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

Line 4977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
4980: (
4981: G_PKG_NAME,

Line 5013: -- DEFAULT = FND_API.G_FALSE

5009: -- Parameters :
5010:
5011: -- IN : p_api_version IN NUMBER Required
5012: -- p_init_msg_list IN VARCHAR2 Optional
5013: -- DEFAULT = FND_API.G_FALSE
5014:
5015: -- Assignment Manager Specific Parameters
5016:
5017: -- This determines the Resource Type required by the

Line 5296: IF NOT fnd_api.compatible_api_call (l_api_version,

5292: -- Started Assignment Manager Public API
5293:
5294: /* Standard call to check for call compatibility */
5295:
5296: IF NOT fnd_api.compatible_api_call (l_api_version,
5297: p_api_version,
5298: l_api_name,
5299: g_pkg_name) THEN
5300: RAISE fnd_api.g_exc_unexpected_error;

Line 5300: RAISE fnd_api.g_exc_unexpected_error;

5296: IF NOT fnd_api.compatible_api_call (l_api_version,
5297: p_api_version,
5298: l_api_name,
5299: g_pkg_name) THEN
5300: RAISE fnd_api.g_exc_unexpected_error;
5301: END IF;
5302:
5303:
5304: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 5306: IF fnd_api.to_boolean (p_init_msg_list) THEN

5302:
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;

Line 5310: x_return_status := fnd_api.g_ret_sts_success;

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:
5312: /* Paramater Validation */
5313:
5314: IF (p_resource_type IS NOT NULL) THEN

Line 5320: RAISE fnd_api.g_exc_error;

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;
5324:

Line 5403: the direct use of the variables FND_API.MISS_NUM, MISS_CHAR etc. */

5399: l_effort_duration := p_effort_duration;
5400: END IF;
5401:
5402: /* This assigning is being done because of the limitation for
5403: the direct use of the variables FND_API.MISS_NUM, MISS_CHAR etc. */
5404:
5405:
5406: /* Assigning values to the Depot Repair Record Type */
5407:

Line 5540: RAISE fnd_api.g_exc_error;

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;
5544:

Line 5593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

5589: p_calendar_check => p_calendar_check
5590: --Added for Bug # 5573916 Ends here
5591: );
5592:
5593: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5594: -- Unexpected Execution Error from call to Get_contracts_resources
5595: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5596: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
5597: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

Line 5599: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5603: END IF;

Line 5600: RAISE fnd_api.g_exc_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;
5603: END IF;
5604: END IF;

Line 5602: RAISE fnd_api.g_exc_unexpected_error;

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;
5603: END IF;
5604: END IF;
5605: END IF;
5606:

Line 5630: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

5626: p_calendar_check => p_calendar_check
5627: --Added for Bug # 5573916 Ends here
5628: );
5629:
5630: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5631: -- Unexpected Execution Error from call to Get_contracts_resources
5632: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5633: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
5634: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

Line 5636: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5640: END IF;

Line 5637: RAISE fnd_api.g_exc_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;
5640: END IF;
5641: END IF;

Line 5639: RAISE fnd_api.g_exc_unexpected_error;

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;
5640: END IF;
5641: END IF;
5642:
5643: END IF; -- p_ib_preferred_engineer = 'Y'

Line 5672: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 5678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5682: END IF;

Line 5679: RAISE fnd_api.g_exc_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;
5682: END IF;
5683: END IF;

Line 5681: RAISE fnd_api.g_exc_unexpected_error;

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;
5682: END IF;
5683: END IF;
5684:
5685: end IF; -- end of security check for contracts resource

Line 5697: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 5703: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5707: END IF;

Line 5704: RAISE fnd_api.g_exc_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;
5707: END IF;
5708: END IF;

Line 5706: RAISE fnd_api.g_exc_unexpected_error;

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;
5707: END IF;
5708: END IF;
5709:
5710: end IF; -- end of security check for contracts resource

Line 5802: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

5798:
5799: -- set back the API name to original name
5800: l_api_name := l_api_name_1;
5801:
5802: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5803: -- Unexpected Execution Error from call to Territory Manager
5804: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
5805: fnd_msg_pub.add;
5806: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5806: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5810: END IF;

Line 5807: RAISE fnd_api.g_exc_error;

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;
5810: END IF;
5811: END IF;

Line 5809: RAISE fnd_api.g_exc_unexpected_error;

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;
5810: END IF;
5811: END IF;
5812:
5813: IF(l_winningterrmember_tbl.COUNT > 0)

Line 5896: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

5892: -- set back the API name to original name
5893:
5894: l_api_name := l_api_name_1;
5895:
5896: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
5897: -- Unexpected Execution Error from call to Get_contracts_resources
5898: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
5899: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
5900: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DR_RESOURCES');

Line 5902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5906: END IF;

Line 5903: RAISE fnd_api.g_exc_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;
5906: END IF;
5907: END IF; -- end of x_return_status check

Line 5905: RAISE fnd_api.g_exc_unexpected_error;

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;
5906: END IF;
5907: END IF; -- end of x_return_status check
5908:
5909: IF ( p_calendar_flag = 'Y' AND

Line 5934: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 5940: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
5944: END IF;

Line 5941: RAISE fnd_api.g_exc_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;
5944: END IF;
5945: END IF;

Line 5943: RAISE fnd_api.g_exc_unexpected_error;

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;
5944: END IF;
5945: END IF;
5946: END IF; -- end of security check
5947: ELSE -- No resources returned from the Territory API

Line 6186: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)

6182:
6183: -- set back the API name to original name
6184: l_api_name := l_api_name_1;
6185:
6186: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
6187: then
6188: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
6189: RAISE fnd_api.g_exc_error;
6190: ELSE

Line 6188: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN

6184: l_api_name := l_api_name_1;
6185:
6186: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
6187: then
6188: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
6189: RAISE fnd_api.g_exc_error;
6190: ELSE
6191: RAISE fnd_api.g_exc_unexpected_error;
6192: END IF;

Line 6189: RAISE fnd_api.g_exc_error;

6185:
6186: if(l_skill_ret_sts <> fnd_api.g_ret_sts_success)
6187: then
6188: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
6189: RAISE fnd_api.g_exc_error;
6190: ELSE
6191: RAISE fnd_api.g_exc_unexpected_error;
6192: END IF;
6193: end if;

Line 6191: RAISE fnd_api.g_exc_unexpected_error;

6187: then
6188: IF (l_skill_ret_sts = fnd_api.g_ret_sts_error) THEN
6189: RAISE fnd_api.g_exc_error;
6190: ELSE
6191: RAISE fnd_api.g_exc_unexpected_error;
6192: END IF;
6193: end if;
6194:
6195:

Line 6199: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND

6195:
6196: -- added this to filter by usage
6197:
6198: IF ((l_assign_resources_tbl.count > 0 ) AND
6199: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND
6200: (l_usage is not null)
6201: )
6202: THEN
6203: get_usage_resource(l_usage ,

Line 6361: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 6410: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 6414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
6418: END IF;

Line 6415: RAISE fnd_api.g_exc_error;

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;
6418: END IF;
6419: END IF;

Line 6417: RAISE fnd_api.g_exc_unexpected_error;

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;
6418: END IF;
6419: END IF;
6420:
6421:

Line 6440: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 6444: RAISE fnd_api.g_exc_error;

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');
6448: fnd_msg_pub.add;

Line 6445: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
6448: fnd_msg_pub.add;
6449: RAISE fnd_api.g_exc_unexpected_error;

Line 6449: RAISE fnd_api.g_exc_unexpected_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
6453:

Line 6467: x_return_status := fnd_api.g_ret_sts_success;

6463: p_data => x_msg_data
6464: );
6465:
6466:
6467: x_return_status := fnd_api.g_ret_sts_success;
6468:
6469: EXCEPTION
6470: WHEN FND_API.G_EXC_ERROR THEN
6471: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 6470: WHEN FND_API.G_EXC_ERROR THEN

6466:
6467: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 6471: x_return_status := FND_API.G_RET_STS_ERROR ;

6467: x_return_status := fnd_api.g_ret_sts_success;
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

Line 6478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6474: p_count => x_msg_count,
6475: p_data => x_msg_data
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,

Line 6479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6475: p_data => x_msg_data
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

Line 6493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
6496: (
6497: G_PKG_NAME,

Line 6529: -- DEFAULT = FND_API.G_FALSE

6525: -- Parameters :
6526:
6527: -- IN : p_api_version IN NUMBER Required
6528: -- p_init_msg_list IN VARCHAR2 Optional
6529: -- DEFAULT = FND_API.G_FALSE
6530: -- p_commit IN VARCHAR2 optional
6531: -- DEFAULT = FND_API.G_FALSE
6532:
6533: -- Assignment Manager Specific Parameters

Line 6531: -- DEFAULT = FND_API.G_FALSE

6527: -- IN : p_api_version IN NUMBER Required
6528: -- p_init_msg_list IN VARCHAR2 Optional
6529: -- DEFAULT = FND_API.G_FALSE
6530: -- p_commit IN VARCHAR2 optional
6531: -- DEFAULT = FND_API.G_FALSE
6532:
6533: -- Assignment Manager Specific Parameters
6534:
6535: -- This determines the Resource Type required by the

Line 6690: IF NOT fnd_api.compatible_api_call (l_api_version,

6686:
6687:
6688: /* Standard call to check for call compatibility */
6689:
6690: IF NOT fnd_api.compatible_api_call (l_api_version,
6691: p_api_version,
6692: l_api_name,
6693: g_pkg_name) THEN
6694: RAISE fnd_api.g_exc_unexpected_error;

Line 6694: RAISE fnd_api.g_exc_unexpected_error;

6690: IF NOT fnd_api.compatible_api_call (l_api_version,
6691: p_api_version,
6692: l_api_name,
6693: g_pkg_name) THEN
6694: RAISE fnd_api.g_exc_unexpected_error;
6695: END IF;
6696:
6697:
6698: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 6700: IF fnd_api.to_boolean (p_init_msg_list) THEN

6696:
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;

Line 6704: x_return_status := fnd_api.g_ret_sts_success;

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:
6706:
6707:
6708: /* Getting the Auto Select Profile value defined for the Assignment Manager */

Line 6748: RAISE fnd_api.g_exc_error;

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: */
6752:

Line 6865: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

6861: -- set back the API name to original name
6862: l_api_name := l_api_name_1;
6863:
6864:
6865: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6866: -- Unexpected Execution Error from call to Territory Manager
6867: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
6868: fnd_msg_pub.add;
6869: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 6869: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
6873: END IF;

Line 6870: RAISE fnd_api.g_exc_error;

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;
6873: END IF;
6874: END IF;

Line 6872: RAISE fnd_api.g_exc_unexpected_error;

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;
6873: END IF;
6874: END IF;
6875:
6876:

Line 6972: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

6968:
6969: -- set back the API name to original name
6970: l_api_name := l_api_name_1;
6971:
6972: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6973: -- Unexpected Execution Error from call to Get_contracts_resources
6974: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
6975: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
6976: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_OPPR_RESOURCES');

Line 6978: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
6982: END IF;

Line 6979: RAISE fnd_api.g_exc_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;
6982: END IF;
6983: END IF; -- end of x_return_status check

Line 6981: RAISE fnd_api.g_exc_unexpected_error;

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;
6982: END IF;
6983: END IF; -- end of x_return_status check
6984: end if; -- if p_calendar_flag = Y
6985:

Line 6990: -- RAISE fnd_api.g_exc_error;

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
6994: -- if auto assignment is Y then return only the number of resources that have been requested

Line 7019: -- RAISE fnd_api.g_exc_error;

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
7023: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 7025: -- RAISE fnd_api.g_exc_error;

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 ************************/
7029:

Line 7048: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 7103: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 7107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
7111: END IF;

Line 7108: RAISE fnd_api.g_exc_error;

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;
7111: END IF;
7112: END IF;

Line 7110: RAISE fnd_api.g_exc_unexpected_error;

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;
7111: END IF;
7112: END IF;
7113:
7114: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

Line 7131: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 7135: RAISE fnd_api.g_exc_error;

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');
7139: fnd_msg_pub.add;

Line 7136: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
7139: fnd_msg_pub.add;
7140: RAISE fnd_api.g_exc_unexpected_error;

Line 7140: RAISE fnd_api.g_exc_unexpected_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
7144:

Line 7163: WHEN FND_API.G_EXC_ERROR THEN

7159:
7160:
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,

Line 7164: x_return_status := FND_API.G_RET_STS_ERROR ;

7160:
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

Line 7171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7167: p_count => x_msg_count,
7168: p_data => x_msg_data
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,

Line 7172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7168: p_data => x_msg_data
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

Line 7186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
7189: (
7190: G_PKG_NAME,

Line 7375: IF NOT fnd_api.compatible_api_call (l_api_version,

7371:
7372:
7373: /* Standard call to check for call compatibility */
7374:
7375: IF NOT fnd_api.compatible_api_call (l_api_version,
7376: p_api_version,
7377: l_api_name,
7378: g_pkg_name) THEN
7379: RAISE fnd_api.g_exc_unexpected_error;

Line 7379: RAISE fnd_api.g_exc_unexpected_error;

7375: IF NOT fnd_api.compatible_api_call (l_api_version,
7376: p_api_version,
7377: l_api_name,
7378: g_pkg_name) THEN
7379: RAISE fnd_api.g_exc_unexpected_error;
7380: END IF;
7381:
7382:
7383: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 7385: IF fnd_api.to_boolean (p_init_msg_list) THEN

7381:
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;

Line 7389: x_return_status := fnd_api.g_ret_sts_success;

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:
7391:
7392:
7393: /* Getting the Auto Select Profile value defined for the Assignment Manager */

Line 7465: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

7461:
7462: -- set back the API name to original name
7463: l_api_name := l_api_name_1;
7464:
7465: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7466: -- Unexpected Execution Error from call to Territory Manager
7467: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
7468: fnd_msg_pub.add;
7469: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 7469: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
7473: END IF;

Line 7470: RAISE fnd_api.g_exc_error;

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;
7473: END IF;
7474: END IF;

Line 7472: RAISE fnd_api.g_exc_unexpected_error;

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;
7473: END IF;
7474: END IF;
7475:
7476:

Line 7560: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

7556:
7557: -- set back the API name to original name
7558: l_api_name := l_api_name_1;
7559:
7560: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
7561: -- Unexpected Execution Error from call to Get_contracts_resources
7562: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
7563: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
7564: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_LEAD_RESOURCES');

Line 7566: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
7570: END IF;

Line 7567: RAISE fnd_api.g_exc_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;
7570: END IF;
7571: END IF; -- end of x_return_status check

Line 7569: RAISE fnd_api.g_exc_unexpected_error;

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;
7570: END IF;
7571: END IF; -- end of x_return_status check
7572: end if; -- if p_calendar_flag = Y
7573:

Line 7578: -- RAISE fnd_api.g_exc_error;

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:
7582: -- If auto_select is Y then ensure correct number of resources are returned

Line 7607: -- RAISE fnd_api.g_exc_error;

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
7611: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 7613: -- RAISE fnd_api.g_exc_error;

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 ************************/
7617:

Line 7637: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 7691: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 7695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
7699: END IF;

Line 7696: RAISE fnd_api.g_exc_error;

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;
7699: END IF;
7700: END IF;

Line 7698: RAISE fnd_api.g_exc_unexpected_error;

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;
7699: END IF;
7700: END IF;
7701:
7702: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

Line 7719: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 7723: RAISE fnd_api.g_exc_error;

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');
7727: fnd_msg_pub.add;

Line 7724: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
7727: fnd_msg_pub.add;
7728: RAISE fnd_api.g_exc_unexpected_error;

Line 7728: RAISE fnd_api.g_exc_unexpected_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
7732:

Line 7750: WHEN FND_API.G_EXC_ERROR THEN

7746:
7747:
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,

Line 7751: x_return_status := FND_API.G_RET_STS_ERROR ;

7747:
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

Line 7758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7754: p_count => x_msg_count,
7755: p_data => x_msg_data
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,

Line 7759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7755: p_data => x_msg_data
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

Line 7773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
7776: (
7777: G_PKG_NAME,

Line 7901: IF NOT fnd_api.compatible_api_call (l_api_version,

7897:
7898:
7899: /* Standard call to check for call compatibility */
7900:
7901: IF NOT fnd_api.compatible_api_call (l_api_version,
7902: p_api_version,
7903: l_api_name,
7904: g_pkg_name) THEN
7905: RAISE fnd_api.g_exc_unexpected_error;

Line 7905: RAISE fnd_api.g_exc_unexpected_error;

7901: IF NOT fnd_api.compatible_api_call (l_api_version,
7902: p_api_version,
7903: l_api_name,
7904: g_pkg_name) THEN
7905: RAISE fnd_api.g_exc_unexpected_error;
7906: END IF;
7907:
7908:
7909: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 7911: IF fnd_api.to_boolean (p_init_msg_list) THEN

7907:
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;

Line 7915: x_return_status := fnd_api.g_ret_sts_success;

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:
7917:
7918: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7919:

Line 8040: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

8036:
8037: -- set back the API name to original name
8038: l_api_name := l_api_name_1;
8039:
8040: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8041: -- Unexpected Execution Error from call to Territory Manager
8042: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8043: fnd_msg_pub.add;
8044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 8044: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8048: END IF;

Line 8045: RAISE fnd_api.g_exc_error;

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;
8048: END IF;
8049: END IF;

Line 8047: RAISE fnd_api.g_exc_unexpected_error;

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;
8048: END IF;
8049: END IF;
8050:
8051: -- added 2 april 2003 by sudarsana to conver RS_SUPPLIER TO RS_SUPPLIER_CONTACT

Line 8113: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

8109:
8110: -- set back the API name to original name
8111: l_api_name := l_api_name_1;
8112:
8113: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8114: -- Unexpected Execution Error from call to Calendar
8115: fnd_message.set_name('JTF', 'JTF_AM_ERROR_CAL_API');
8116: fnd_msg_pub.add;
8117: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 8117: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8121: ELSE

Line 8120: RAISE fnd_api.g_exc_error;

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;
8121: ELSE
8122: RAISE fnd_api.g_exc_unexpected_error;
8123: END IF;
8124: END IF;

Line 8122: RAISE fnd_api.g_exc_unexpected_error;

8118: -- 12/22/05 ** MPADHIAR ** Manas padhiary **
8119: -- Removed Comment to Show error message Bug # 2919389
8120: RAISE fnd_api.g_exc_error;
8121: ELSE
8122: RAISE fnd_api.g_exc_unexpected_error;
8123: END IF;
8124: END IF;
8125:
8126:

Line 8213: -- RAISE fnd_api.g_exc_error;

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
8217: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 8219: -- RAISE fnd_api.g_exc_error;

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
8223: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 8225: -- RAISE fnd_api.g_exc_error;

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 ************************/
8229:

Line 8249: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 8303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 8307: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8311: END IF;

Line 8308: RAISE fnd_api.g_exc_error;

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;
8311: END IF;
8312: END IF;

Line 8310: RAISE fnd_api.g_exc_unexpected_error;

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;
8311: END IF;
8312: END IF;
8313:
8314: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

Line 8332: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 8336: RAISE fnd_api.g_exc_error;

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');
8340: fnd_msg_pub.add;

Line 8337: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
8340: fnd_msg_pub.add;
8341: RAISE fnd_api.g_exc_unexpected_error;

Line 8341: RAISE fnd_api.g_exc_unexpected_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
8345:

Line 8362: WHEN FND_API.G_EXC_ERROR THEN

8358:
8359:
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,

Line 8363: x_return_status := FND_API.G_RET_STS_ERROR ;

8359:
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

Line 8370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8366: p_count => x_msg_count,
8367: p_data => x_msg_data
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,

Line 8371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8367: p_data => x_msg_data
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

Line 8385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
8388: (
8389: G_PKG_NAME,

Line 8578: IF NOT fnd_api.compatible_api_call (l_api_version,

8574:
8575:
8576: /* Standard call to check for call compatibility */
8577:
8578: IF NOT fnd_api.compatible_api_call (l_api_version,
8579: p_api_version,
8580: l_api_name,
8581: g_pkg_name) THEN
8582: RAISE fnd_api.g_exc_unexpected_error;

Line 8582: RAISE fnd_api.g_exc_unexpected_error;

8578: IF NOT fnd_api.compatible_api_call (l_api_version,
8579: p_api_version,
8580: l_api_name,
8581: g_pkg_name) THEN
8582: RAISE fnd_api.g_exc_unexpected_error;
8583: END IF;
8584:
8585:
8586: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 8588: IF fnd_api.to_boolean (p_init_msg_list) THEN

8584:
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;

Line 8592: x_return_status := fnd_api.g_ret_sts_success;

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:
8594:
8595:
8596: /* Getting the Auto Select Profile value defined for the Assignment Manager */

Line 8709: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

8705:
8706: -- set back the API name to original name
8707: l_api_name := l_api_name_1;
8708:
8709: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8710: -- Unexpected Execution Error from call to Territory Manager
8711: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
8712: fnd_msg_pub.add;
8713: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 8713: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8717: END IF;

Line 8714: RAISE fnd_api.g_exc_error;

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;
8717: END IF;
8718: END IF;

Line 8716: RAISE fnd_api.g_exc_unexpected_error;

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;
8717: END IF;
8718: END IF;
8719:
8720:

Line 8822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

8818:
8819: -- set back the API name to original name
8820: l_api_name := l_api_name_1;
8821:
8822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
8823: -- Unexpected Execution Error from call to Get_contracts_resources
8824: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
8825: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
8826: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ACCOUNT_RESOURCES');

Line 8828: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8832: END IF;

Line 8829: RAISE fnd_api.g_exc_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;
8832: END IF;
8833: END IF; -- end of x_return_status check

Line 8831: RAISE fnd_api.g_exc_unexpected_error;

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;
8832: END IF;
8833: END IF; -- end of x_return_status check
8834: end if; -- if p_calendar_flag = Y
8835:

Line 8840: -- RAISE fnd_api.g_exc_error;

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
8844: IF(l_auto_select_flag = 'Y')

Line 8867: -- RAISE fnd_api.g_exc_error;

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
8871: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 8873: -- RAISE fnd_api.g_exc_error;

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 ************************/
8877:

Line 8896: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 8951: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 8955: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
8959: END IF;

Line 8956: RAISE fnd_api.g_exc_error;

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;
8959: END IF;
8960: END IF;

Line 8958: RAISE fnd_api.g_exc_unexpected_error;

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;
8959: END IF;
8960: END IF;
8961:
8962: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

Line 8979: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 8983: RAISE fnd_api.g_exc_error;

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');
8987: fnd_msg_pub.add;

Line 8984: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
8987: fnd_msg_pub.add;
8988: RAISE fnd_api.g_exc_unexpected_error;

Line 8988: RAISE fnd_api.g_exc_unexpected_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
8992:

Line 9010: WHEN FND_API.G_EXC_ERROR THEN

9006:
9007:
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,

Line 9011: x_return_status := FND_API.G_RET_STS_ERROR ;

9007:
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

Line 9018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9014: p_count => x_msg_count,
9015: p_data => x_msg_data
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,

Line 9019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9015: p_data => x_msg_data
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

Line 9033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
9036: (
9037: G_PKG_NAME,

Line 9077: -- DEFAULT = FND_API.G_FALSE

9073: -- Parameters :
9074:
9075: -- IN : p_api_version IN NUMBER Required
9076: -- p_init_msg_list IN VARCHAR2 Optional
9077: -- DEFAULT = FND_API.G_FALSE
9078: -- Assignment Manager Specific Parameters
9079:
9080: -- This determines the Resource Type required by the
9081: -- calling document

Line 9195: IF NOT fnd_api.compatible_api_call (l_api_version,

9191:
9192:
9193: /* Standard call to check for call compatibility */
9194:
9195: IF NOT fnd_api.compatible_api_call (l_api_version,
9196: p_api_version,
9197: l_api_name,
9198: g_pkg_name) THEN
9199: RAISE fnd_api.g_exc_unexpected_error;

Line 9199: RAISE fnd_api.g_exc_unexpected_error;

9195: IF NOT fnd_api.compatible_api_call (l_api_version,
9196: p_api_version,
9197: l_api_name,
9198: g_pkg_name) THEN
9199: RAISE fnd_api.g_exc_unexpected_error;
9200: END IF;
9201:
9202:
9203:

Line 9206: IF fnd_api.to_boolean (p_init_msg_list) THEN

9202:
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;

Line 9210: x_return_status := fnd_api.g_ret_sts_success;

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:
9212:
9213:
9214:

Line 9259: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

9255:
9256: -- set back the API name to original name
9257: l_api_name := l_api_name_1;
9258:
9259: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9260: -- Unexpected Execution Error from call to Territory Manager
9261: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9262: fnd_msg_pub.add;
9263: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9263: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
9267: END IF;

Line 9264: RAISE fnd_api.g_exc_error;

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;
9267: END IF;
9268: END IF;

Line 9266: RAISE fnd_api.g_exc_unexpected_error;

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;
9267: END IF;
9268: END IF;
9269:
9270: ELSE -- Territory Flag is NO

Line 9273: -- RAISE fnd_api.g_exc_error;

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
9277:

Line 9373: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

9369:
9370: -- set back the API name to original name
9371: l_api_name := l_api_name_1;
9372:
9373: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9374: -- Unexpected Execution Error from call to Get_contracts_resources
9375: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
9376: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
9377: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_DEFECT_RESOURCES');

Line 9379: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
9383: END IF;

Line 9380: RAISE fnd_api.g_exc_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;
9383: END IF;
9384: END IF; -- end of x_return_status check

Line 9382: RAISE fnd_api.g_exc_unexpected_error;

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;
9383: END IF;
9384: END IF; -- end of x_return_status check
9385: end if; -- if p_calendar_flag = Y
9386:

Line 9392: -- RAISE fnd_api.g_exc_error;

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
9396: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 9398: -- RAISE fnd_api.g_exc_error;

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:
9402: /* Standard call to get message count and

Line 9413: WHEN FND_API.G_EXC_ERROR THEN

9409: );
9410:
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,

Line 9414: x_return_status := FND_API.G_RET_STS_ERROR ;

9410:
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

Line 9421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9417: p_count => x_msg_count,
9418: p_data => x_msg_data
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,

Line 9422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9418: p_data => x_msg_data
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

Line 9436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
9439: (
9440: G_PKG_NAME,

Line 9698: IF NOT fnd_api.compatible_api_call (l_api_version,

9694:
9695:
9696: /* Standard call to check for call compatibility */
9697:
9698: IF NOT fnd_api.compatible_api_call (l_api_version,
9699: p_api_version,
9700: l_api_name,
9701: g_pkg_name) THEN
9702: RAISE fnd_api.g_exc_unexpected_error;

Line 9702: RAISE fnd_api.g_exc_unexpected_error;

9698: IF NOT fnd_api.compatible_api_call (l_api_version,
9699: p_api_version,
9700: l_api_name,
9701: g_pkg_name) THEN
9702: RAISE fnd_api.g_exc_unexpected_error;
9703: END IF;
9704:
9705:
9706: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 9708: IF fnd_api.to_boolean (p_init_msg_list) THEN

9704:
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;

Line 9712: x_return_status := fnd_api.g_ret_sts_success;

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:
9714:
9715:
9716: /* Get TASK source and the related information */

Line 9724: RAISE fnd_api.g_exc_error;

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;
9728: l_planned_start_date := l_cur_esc_id.planned_start_date;

Line 9739: RAISE fnd_api.g_exc_error;

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;
9743: IF ( cur_reference_code%NOTFOUND) THEN

Line 9746: RAISE fnd_api.g_exc_error;

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;

Line 9755: RAISE fnd_api.g_exc_error;

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;
9759: END IF;

Line 9844: RAISE fnd_api.g_exc_error;

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;
9848:

Line 9865: RAISE fnd_api.g_exc_error;

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;
9869:

Line 9889: RAISE fnd_api.g_exc_error;

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;
9893:

Line 9923: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

9919: -- set back the API name to original name
9920: l_api_name := l_api_name_1;
9921:
9922:
9923: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9924: -- Unexpected Execution Error from call to Territory Manager
9925: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9926: fnd_msg_pub.add;
9927: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9927: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
9931: END IF;

Line 9928: RAISE fnd_api.g_exc_error;

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;
9931: END IF;
9932: END IF;

Line 9930: RAISE fnd_api.g_exc_unexpected_error;

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;
9931: END IF;
9932: END IF;
9933:
9934: l_assign_resources_tbl.DELETE;

Line 9957: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

9953:
9954: -- set back the API name to original name
9955: l_api_name := l_api_name_1;
9956:
9957: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9958: -- Unexpected Execution Error from call to Territory Manager
9959: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
9960: fnd_msg_pub.add;
9961: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9961: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
9965: END IF;

Line 9962: RAISE fnd_api.g_exc_error;

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;
9965: END IF;
9966: END IF;

Line 9964: RAISE fnd_api.g_exc_unexpected_error;

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;
9965: END IF;
9966: END IF;
9967:
9968: --ELSE

Line 9971: --RAISE fnd_api.g_exc_error;

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
9975:

Line 9998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

9994:
9995: -- set back the API name to original name
9996: l_api_name := l_api_name_1;
9997:
9998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
9999: -- Unexpected Execution Error from call to Territory Manager
10000: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10001: fnd_msg_pub.add;
10002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 10002: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
10006: END IF;

Line 10003: RAISE fnd_api.g_exc_error;

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;
10006: END IF;
10007: END IF;

Line 10005: RAISE fnd_api.g_exc_unexpected_error;

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;
10006: END IF;
10007: END IF;
10008: END IF;
10009:

Line 10112: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

10108:
10109: -- set back the API name to original name
10110: l_api_name := l_api_name_1;
10111:
10112: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10113: -- Unexpected Execution Error from call to Get_contracts_resources
10114: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10115: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
10116: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_ESC_RESOURCES');

Line 10118: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
10122: END IF;

Line 10119: RAISE fnd_api.g_exc_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;
10122: END IF;
10123: END IF; -- end of x_return_status check

Line 10121: RAISE fnd_api.g_exc_unexpected_error;

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;
10122: END IF;
10123: END IF; -- end of x_return_status check
10124: -- end if; -- if p_calendar_flag = Y
10125:

Line 10130: -- RAISE fnd_api.g_exc_error;

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
10134: IF(l_auto_select_flag = 'Y')

Line 10158: -- RAISE fnd_api.g_exc_error;

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
10162: fnd_message.set_name('JTF', 'JTF_AM_NO_RESOURCES_FOUND');

Line 10164: -- RAISE fnd_api.g_exc_error;

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);
10168:

Line 10192: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

10188:
10189: -- set back the API name to original name
10190: l_api_name := l_api_name_1;
10191:
10192: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
10193: -- Unexpected Execution Error from call to Territory Manager
10194: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');
10195: fnd_msg_pub.add;
10196: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 10196: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
10200: END IF;

Line 10197: RAISE fnd_api.g_exc_error;

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;
10200: END IF;
10201: END IF;

Line 10199: RAISE fnd_api.g_exc_unexpected_error;

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;
10200: END IF;
10201: END IF;
10202:
10203:

Line 10259: -- RAISE fnd_api.g_exc_error;

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:
10263: /*

Line 10266: RAISE fnd_api.g_exc_error;

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
10270:

Line 10386: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

10382: X_MSG_DATA => l_wf_msg_data
10383: );
10384:
10385:
10386: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10387: -- Unexpected Execution Error from call to assign_sr_resource
10388: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10389: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10390: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');

Line 10416: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

10412: X_MSG_DATA => l_wf_msg_data
10413: );
10414:
10415:
10416: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
10417: -- Unexpected Execution Error from call to assign_sr_resource
10418: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
10419: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
10420: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ESC_RESOURCES');

Line 10473: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 10477: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
10481: END IF;

Line 10478: RAISE fnd_api.g_exc_error;

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;
10481: END IF;
10482: END IF;

Line 10480: RAISE fnd_api.g_exc_unexpected_error;

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;
10481: END IF;
10482: END IF;
10483:
10484:

Line 10503: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 10507: RAISE fnd_api.g_exc_error;

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');
10511: fnd_msg_pub.add;

Line 10508: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
10511: fnd_msg_pub.add;
10512: RAISE fnd_api.g_exc_unexpected_error;

Line 10512: RAISE fnd_api.g_exc_unexpected_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
10516:

Line 10533: WHEN FND_API.G_EXC_ERROR THEN

10529:
10530:
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,

Line 10534: x_return_status := FND_API.G_RET_STS_ERROR ;

10530:
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

Line 10541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10537: p_count => x_msg_count,
10538: p_data => x_msg_data
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,

Line 10542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

10538: p_data => x_msg_data
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

Line 10556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
10559: (
10560: G_PKG_NAME,

Line 10845: IF NOT fnd_api.compatible_api_call (l_api_version,

10841:
10842:
10843: /* Standard call to check for call compatibility */
10844:
10845: IF NOT fnd_api.compatible_api_call (l_api_version,
10846: p_api_version,
10847: l_api_name,
10848: g_pkg_name) THEN
10849: RAISE fnd_api.g_exc_unexpected_error;

Line 10849: RAISE fnd_api.g_exc_unexpected_error;

10845: IF NOT fnd_api.compatible_api_call (l_api_version,
10846: p_api_version,
10847: l_api_name,
10848: g_pkg_name) THEN
10849: RAISE fnd_api.g_exc_unexpected_error;
10850: END IF;
10851:
10852:
10853: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 10855: IF fnd_api.to_boolean (p_init_msg_list) THEN

10851:
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:

Line 10870: RAISE fnd_api.g_exc_error;

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;
10874:

Line 10883: RAISE fnd_api.g_exc_error;

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;
10887: */

Line 10999: the direct use of the variables FND_API.MISS_NUM, MISS_CHAR etc. */

10995:
10996: l_effort_duration := p_effort_duration; --Added by SBARAT on 21/04/2005 for Bug-4300801
10997:
10998: /* This assigning is being done because of the limitation for
10999: the direct use of the variables FND_API.MISS_NUM, MISS_CHAR etc. */
11000:
11001:
11002: /* Assigning values to the Service Request Record Type */
11003:

Line 11231: RAISE fnd_api.g_exc_error;

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:
11235:

Line 11278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11283: IF (x_return_status = fnd_api.g_ret_sts_error) 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;
11287: END IF;

Line 11284: RAISE fnd_api.g_exc_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;
11287: END IF;
11288: END IF;

Line 11286: RAISE fnd_api.g_exc_unexpected_error;

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;
11287: END IF;
11288: END IF;
11289:
11290: -- added this to filter by usage

Line 11292: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND

11288: END IF;
11289:
11290: -- added this to filter by usage
11291: IF ((l_assign_resources_tbl.count > 0 ) AND
11292: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND
11293: (l_usage is not null)
11294: )
11295: THEN
11296: get_usage_resource(l_usage ,

Line 11442: -- RAISE fnd_api.g_exc_error;

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:
11446: -- raise workfow event

Line 11474: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

11470: X_MSG_DATA => l_wf_msg_data
11471: );
11472:
11473:
11474: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN
11475: -- Unexpected Execution Error from call to assign_sr_resource
11476: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
11477: fnd_message.set_token('P_PROC_NAME','JTF_AM_WF_EVENTS_PUB');
11478: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_RESOURCES');

Line 11481: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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
11484: RAISE fnd_api.g_exc_unexpected_error;
11485: END IF;

Line 11482: RAISE fnd_api.g_exc_error;

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
11484: RAISE fnd_api.g_exc_unexpected_error;
11485: END IF;
11486: */

Line 11484: RAISE fnd_api.g_exc_unexpected_error;

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
11484: RAISE fnd_api.g_exc_unexpected_error;
11485: END IF;
11486: */
11487: ELSE
11488: x_assign_resources_tbl := jtf_assign_pub.g_assign_resources_tbl;

Line 11551: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11556: IF (x_return_status = fnd_api.g_ret_sts_error) 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;
11560: END IF;

Line 11557: RAISE fnd_api.g_exc_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;
11560: END IF;
11561: END IF;

Line 11559: RAISE fnd_api.g_exc_unexpected_error;

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;
11560: END IF;
11561: END IF;
11562:
11563: /* Begin code to implement the sorting of resources by postal code */

Line 11566: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND

11562:
11563: /* Begin code to implement the sorting of resources by postal code */
11564: -- added this to filter by usage
11565: IF ((l_assign_resources_tbl.count > 0 ) AND
11566: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND
11567: (l_usage is not null)
11568: --(l_usage is not null or l_usage <> 'ALL')
11569: )
11570: THEN

Line 11736: -- RAISE fnd_api.g_exc_error;

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
11740: -- workflow test

Line 11760: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11823: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11828: IF (x_return_status = fnd_api.g_ret_sts_error) 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;
11832: END IF;

Line 11829: RAISE fnd_api.g_exc_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;
11832: END IF;
11833: END IF;

Line 11831: RAISE fnd_api.g_exc_unexpected_error;

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;
11832: END IF;
11833: END IF;
11834:
11835: -- added this to filter by usage

Line 11837: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND

11833: END IF;
11834:
11835: -- added this to filter by usage
11836: IF ((l_assign_resources_tbl.count > 0 ) AND
11837: (nvl(l_usage, fnd_api.g_miss_char) <> 'ALL' ) AND
11838: (l_usage is not null)
11839: --(l_usage is not null or l_usage <> 'ALL')
11840: )
11841: THEN

Line 11916: -- RAISE fnd_api.g_exc_error;

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
11920: -- workflow test

Line 11940: IF NOT (l_wf_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11993: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

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

Line 11997: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
12001: END IF;

Line 11998: RAISE fnd_api.g_exc_error;

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;
12001: END IF;
12002: END IF;

Line 12000: RAISE fnd_api.g_exc_unexpected_error;

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;
12001: END IF;
12002: END IF;
12003:
12004:

Line 12023: IF (l_return_code = fnd_api.g_ret_sts_error) THEN

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

Line 12027: RAISE fnd_api.g_exc_error;

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');
12031: fnd_msg_pub.add;

Line 12028: ELSIF (l_return_code = fnd_api.g_ret_sts_unexp_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');
12031: fnd_msg_pub.add;
12032: RAISE fnd_api.g_exc_unexpected_error;

Line 12032: RAISE fnd_api.g_exc_unexpected_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
12036:

Line 12050: x_return_status := fnd_api.g_ret_sts_success;

12046: p_data => x_msg_data
12047: );
12048:
12049:
12050: x_return_status := fnd_api.g_ret_sts_success;
12051:
12052:
12053:
12054: EXCEPTION

Line 12055: WHEN FND_API.G_EXC_ERROR THEN

12051:
12052:
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,

Line 12056: x_return_status := FND_API.G_RET_STS_ERROR ;

12052:
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

Line 12063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12059: p_count => x_msg_count,
12060: p_data => x_msg_data
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,

Line 12064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12060: p_data => x_msg_data
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

Line 12078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
12081: (
12082: G_PKG_NAME,

Line 12161: IF NOT fnd_api.compatible_api_call (l_api_version,

12157: BEGIN
12158:
12159: /* Standard call to check for call compatibility */
12160:
12161: IF NOT fnd_api.compatible_api_call (l_api_version,
12162: p_api_version,
12163: l_api_name,
12164: g_pkg_name) THEN
12165: RAISE fnd_api.g_exc_unexpected_error;

Line 12165: RAISE fnd_api.g_exc_unexpected_error;

12161: IF NOT fnd_api.compatible_api_call (l_api_version,
12162: p_api_version,
12163: l_api_name,
12164: g_pkg_name) THEN
12165: RAISE fnd_api.g_exc_unexpected_error;
12166: END IF;
12167:
12168:
12169: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 12171: IF fnd_api.to_boolean (p_init_msg_list) THEN

12167:
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;

Line 12175: x_return_status := fnd_api.g_ret_sts_success;

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:
12177: -- If p_document_type = TASK then get the contract_service_id and the customer_product_id from the table
12178: IF(p_calling_doc_type = 'TASK')
12179: THEN

Line 12294: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

12290: x_assign_resources_tbl => l_contracts_tbl,
12291: x_excluded_tbl => l_excluded_resource_tbl
12292: );
12293:
12294: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12295: -- Unexpected Execution Error from call to Get_contracts_resources
12296: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12297: fnd_message.set_token('P_PROC_NAME','GET_CONTRACTS_RESOURCES');
12298: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_SR_RESOURCES');

Line 12300: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
12304: END IF;

Line 12301: RAISE fnd_api.g_exc_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;
12304: END IF;
12305: END IF;

Line 12303: RAISE fnd_api.g_exc_unexpected_error;

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;
12304: END IF;
12305: END IF;
12306: END IF;
12307:

Line 12328: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

12324: x_assign_resources_tbl => l_ib_tbl,
12325: x_excluded_tbl => l_excluded_resource_tbl
12326: );
12327:
12328: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12329: -- Unexpected Execution Error from call to Get_contracts_resources
12330: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12331: fnd_message.set_token('P_PROC_NAME','GET_IB_RESOURCES');
12332: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_ASSIGN_TASK_RESOURCES');

Line 12334: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
12338: END IF;

Line 12335: RAISE fnd_api.g_exc_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;
12338: END IF;
12339: END IF;

Line 12337: RAISE fnd_api.g_exc_unexpected_error;

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;
12338: END IF;
12339: END IF;
12340: END IF;
12341:

Line 12348: WHEN FND_API.G_EXC_ERROR THEN

12344: x_excluded_resouurce_tbl.delete;
12345: x_excluded_resouurce_tbl := l_excluded_resource_tbl;
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,

Line 12349: x_return_status := FND_API.G_RET_STS_ERROR ;

12345: x_excluded_resouurce_tbl := l_excluded_resource_tbl;
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

Line 12356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12352: p_count => x_msg_count,
12353: p_data => x_msg_data
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,

Line 12357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12353: p_data => x_msg_data
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

Line 12371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
12374: (
12375: G_PKG_NAME,

Line 12416: IF NOT fnd_api.compatible_api_call (l_api_version,

12412: l_api_version NUMBER := 1.0;
12413:
12414: BEGIN
12415: /* Standard call to check for call compatibility */
12416: IF NOT fnd_api.compatible_api_call (l_api_version,
12417: p_api_version,
12418: l_api_name,
12419: g_pkg_name)
12420: THEN

Line 12421: RAISE fnd_api.g_exc_unexpected_error;

12417: p_api_version,
12418: l_api_name,
12419: g_pkg_name)
12420: THEN
12421: RAISE fnd_api.g_exc_unexpected_error;
12422: END IF;
12423:
12424:
12425: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 12426: IF fnd_api.to_boolean (p_init_msg_list)

12422: END IF;
12423:
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:

Line 12431: x_return_status := fnd_api.g_ret_sts_success;

12427: THEN
12428: fnd_msg_pub.initialize;
12429: END IF;
12430:
12431: x_return_status := fnd_api.g_ret_sts_success;
12432:
12433: l_api_name := l_api_name||'-GET_AVAILABLE_RESOURCE';
12434: l_return_status_1 := x_return_status ;
12435: -- call the api to check resource availability

Line 12455: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

12451:
12452: -- set back the API name to original name
12453: l_api_name := l_api_name_1;
12454:
12455: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
12456: -- Unexpected Execution Error from call to Get_contracts_resources
12457: fnd_message.set_name('JTF', 'JTF_AM_GENERIC_API_ERROR');
12458: fnd_message.set_token('P_PROC_NAME','GET_AVAILABLE_RESOURCE');
12459: fnd_message.set_token('P_API_NAME','JTF_ASSIGN_PUB.GET_CONTRACTS_RESOURCES');

Line 12461: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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;
12465: END IF;

Line 12462: RAISE fnd_api.g_exc_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;
12465: END IF;
12466: END IF; -- end of x_return_status check

Line 12464: RAISE fnd_api.g_exc_unexpected_error;

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;
12465: END IF;
12466: END IF; -- end of x_return_status check
12467:
12468:

Line 12472: WHEN FND_API.G_EXC_ERROR THEN

12468:
12469:
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,

Line 12473: x_return_status := FND_API.G_RET_STS_ERROR ;

12469:
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

Line 12480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12476: p_count => x_msg_count,
12477: p_data => x_msg_data
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,

Line 12481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12477: p_data => x_msg_data
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

Line 12495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
12498: (
12499: G_PKG_NAME,