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.AMS_WFMOD_PVT dependencies on FND_API

Line 174: p_init_msg_list => FND_API.G_FALSE,

170: -- if needed, convert the time into system time from schedule time zone ??
171: -- for time being, assuming that shedule_date and workflow system date are in
172: -- in same time zone ??
173: AMS_Utility_PVT.convert_timezone (
174: p_init_msg_list => FND_API.G_FALSE,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,
177: x_msg_data => l_msg_data,
178: p_user_tz_id => p_scheduled_timezone_id,

Line 183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

179: p_in_time => p_scheduled_date,
180: p_convert_type => 'SYS',
181: x_out_time => l_system_scheduled_date
182: );
183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: IF (AMS_DEBUG_HIGH_ON) THEN

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: p_convert_type => 'SYS',
181: x_out_time => l_system_scheduled_date
182: );
183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: IF (AMS_DEBUG_HIGH_ON) THEN
188: AMS_Utility_PVT.debug_message ('SYSTEM SCHEDULED - WAIT: ' || TO_CHAR (l_system_scheduled_date, 'DD-MON-RRRR HH24:MI:SS'));

Line 350: RAISE FND_API.G_EXC_ERROR;

346: END IF;
347:
348: x_itemkey := NULL;
349:
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: CLOSE c_get_model_owner;
353:
354: ELSIF p_object_type = G_OBJECT_TYPE_SCORE THEN

Line 366: RAISE FND_API.G_EXC_ERROR;

362: END IF;
363:
364: x_itemkey := NULL;
365:
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: CLOSE c_get_score_owner;
369:
370: END IF;

Line 378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

374: x_role_name => l_owner_role,
375: x_role_display_name => l_owner_role_name,
376: x_return_status => l_return_status);
377:
378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
379: IF (AMS_DEBUG_HIGH_ON) THEN
380: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Failed. ');
381: END IF;
382:

Line 713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

709: x_role_name => l_owner_role,
710: x_role_display_name => l_owner_role_name,
711: x_return_status => l_return_status);
712:
713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
714:
715: result := 'COMPLETE:F';
716:
717: IF (AMS_DEBUG_HIGH_ON) THEN

Line 886: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

882: p_arc_object => l_object_type
883: , p_object_id => l_object_id
884: , x_return_status => l_return_status
885: );
886: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
887: result := 'COMPLETE:SUCCESS' ;
888: ELSE
889: /* populate error message */
890: WF_ENGINE.SetItemAttrText(

Line 1008: l_init_msg_list VARCHAR2(1) := FND_API.g_false;

1004: l_object_id NUMBER;
1005: l_object_type VARCHAR2(30);
1006: l_data_source_id NUMBER;
1007: l_api_version NUMBER := 1.0;
1008: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
1009: l_commit VARCHAR2(1) := FND_API.g_true;
1010: l_validation_level NUMBER := 100;
1011: l_msg_count NUMBER;
1012: l_msg_data VARCHAR2(2000);

Line 1009: l_commit VARCHAR2(1) := FND_API.g_true;

1005: l_object_type VARCHAR2(30);
1006: l_data_source_id NUMBER;
1007: l_api_version NUMBER := 1.0;
1008: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
1009: l_commit VARCHAR2(1) := FND_API.g_true;
1010: l_validation_level NUMBER := 100;
1011: l_msg_count NUMBER;
1012: l_msg_data VARCHAR2(2000);
1013: l_message VARCHAR2(4000);

Line 1105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1101: p_log_used_by_id => l_object_id,
1102: p_msg_data => ' After generate_odm_input_views status ' || l_return_status
1103: );
1104:
1105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1106: result := 'COMPLETE:FAILURE' ;
1107:
1108: /* populate error message */
1109: WF_ENGINE.SetItemAttrText(

Line 1138: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1134: , p_mode => 'I'
1135: , p_model_id => l_object_id
1136: , p_model_type => l_object_type
1137: );
1138: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1139: result := 'COMPLETE:SUCCESS' ;
1140: ELSE
1141: /* populate error message */
1142: WF_ENGINE.SetItemAttrText(

Line 1158: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1154: );
1155: result := 'COMPLETE:FAILURE' ;
1156: END IF;
1157: END IF; -- IF l_seeded_data_source THEN
1158: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1159: -- CANCEL mode - Normal Process Execution
1160: ELSIF (funcmode = 'CANCEL') THEN
1161: result := 'COMPLETE' ;
1162: -- TIMEOUT mode - Normal Process Execution

Line 1705: l_init_msg_list VARCHAR2(1) := FND_API.g_true;

1701:
1702: l_object_id NUMBER;
1703: l_object_type VARCHAR2(30);
1704: l_api_version NUMBER := 1.0;
1705: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
1706: l_commit VARCHAR2(1) := FND_API.g_true;
1707: l_validation_level NUMBER := 100;
1708: l_msg_count NUMBER;
1709: l_msg_data VARCHAR2(2000);

Line 1706: l_commit VARCHAR2(1) := FND_API.g_true;

1702: l_object_id NUMBER;
1703: l_object_type VARCHAR2(30);
1704: l_api_version NUMBER := 1.0;
1705: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
1706: l_commit VARCHAR2(1) := FND_API.g_true;
1707: l_validation_level NUMBER := 100;
1708: l_msg_count NUMBER;
1709: l_msg_data VARCHAR2(2000);
1710: l_message VARCHAR2(4000);

Line 1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1761: , x_msg_count => l_msg_count
1762: , x_msg_data => l_msg_data
1763: , p_score_id => l_object_id
1764: );
1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: result := 'COMPLETE:FAILURE' ;
1767:
1768: AMS_Utility_PVT.create_log (
1769: x_return_status => l_return_status,

Line 1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1801: , x_msg_count => l_msg_count
1802: , x_msg_data => l_msg_data
1803: , p_score_id => l_object_id
1804: );
1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: result := 'COMPLETE:FAILURE' ;
1807:
1808: /* populate error message */
1809: WF_ENGINE.SetItemAttrText(

Line 1836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1832: , x_msg_count => l_msg_count
1833: , x_msg_data => l_msg_data
1834: , p_score_id => l_object_id
1835: );
1836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1837: result := 'COMPLETE:SUCCESS' ;
1838: /* populate status to COMPLETED */
1839: WF_ENGINE.SetItemAttrText(
1840: itemtype => itemtype

Line 1862: END IF; --IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

1858: , itemkey => itemkey
1859: , aname => 'STATUS_CODE'
1860: , avalue => G_STATUS_DRAFT
1861: );
1862: END IF; --IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
1863:
1864: COMMIT;
1865:
1866: END IF; --IF l_object_type = G_OBJECT_TYPE_SCORE

Line 2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2019: p_model_id => l_object_id,
2020: p_status_code => l_object_status,
2021: x_return_status => l_return_status
2022: );
2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: ELSE
2027: AMS_DM_Score_PVT.wf_revert (

Line 2024: RAISE FND_API.G_EXC_ERROR;

2020: p_status_code => l_object_status,
2021: x_return_status => l_return_status
2022: );
2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: ELSE
2027: AMS_DM_Score_PVT.wf_revert (
2028: p_score_id => l_object_id,

Line 2032: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2028: p_score_id => l_object_id,
2029: p_status_code => l_object_status,
2030: x_return_status => l_return_status
2031: );
2032: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035: END IF;
2036: ELSIF l_object_status = G_STATUS_AVAILABLE THEN

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029: p_status_code => l_object_status,
2030: x_return_status => l_return_status
2031: );
2032: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035: END IF;
2036: ELSIF l_object_status = G_STATUS_AVAILABLE THEN
2037: AMS_DM_Model_PVT.process_build_success (

Line 2042: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2038: p_model_id => l_object_id,
2039: p_status_code => l_object_status,
2040: x_return_status => l_return_status
2041: );
2042: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: ELSIF l_object_status = G_STATUS_COMPLETED THEN
2046: AMS_DM_Score_PVT.process_score_success (

Line 2043: RAISE FND_API.G_EXC_ERROR;

2039: p_status_code => l_object_status,
2040: x_return_status => l_return_status
2041: );
2042: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: ELSIF l_object_status = G_STATUS_COMPLETED THEN
2046: AMS_DM_Score_PVT.process_score_success (
2047: p_score_id => l_object_id,

Line 2051: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2047: p_score_id => l_object_id,
2048: p_status_code => l_object_status,
2049: x_return_status => l_return_status
2050: );
2051: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054: ELSIF l_object_status = G_STATUS_SCORING THEN
2055: AMS_DM_Score_PVT.wf_score (

Line 2052: RAISE FND_API.G_EXC_ERROR;

2048: p_status_code => l_object_status,
2049: x_return_status => l_return_status
2050: );
2051: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054: ELSIF l_object_status = G_STATUS_SCORING THEN
2055: AMS_DM_Score_PVT.wf_score (
2056: p_score_id => l_object_id,

Line 2060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2056: p_score_id => l_object_id,
2057: x_status_code => l_object_status,
2058: x_return_status => l_return_status
2059: );
2060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2061: RAISE FND_API.G_EXC_ERROR;
2062: END IF;
2063: -- handle if l_status_code comes back as DRAFT
2064: ELSIF l_object_status = G_STATUS_BUILDING THEN

Line 2061: RAISE FND_API.G_EXC_ERROR;

2057: x_status_code => l_object_status,
2058: x_return_status => l_return_status
2059: );
2060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2061: RAISE FND_API.G_EXC_ERROR;
2062: END IF;
2063: -- handle if l_status_code comes back as DRAFT
2064: ELSIF l_object_status = G_STATUS_BUILDING THEN
2065: AMS_DM_Model_PVT.wf_build (

Line 2069: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2065: AMS_DM_Model_PVT.wf_build (
2066: p_model_id => l_object_id,
2067: x_return_status => l_return_status
2068: );
2069: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: END IF;
2072: END IF;
2073:

Line 2070: RAISE FND_API.G_EXC_ERROR;

2066: p_model_id => l_object_id,
2067: x_return_status => l_return_status
2068: );
2069: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: END IF;
2072: END IF;
2073:
2074: result := 'COMPLETE' ;

Line 2137: x_return_status := FND_API.G_RET_STS_SUCCESS;

2133: FROM ams_jtf_rs_emp_v
2134: WHERE resource_id = p_user_id ;
2135: l_person_id number;
2136: BEGIN
2137: x_return_status := FND_API.G_RET_STS_SUCCESS;
2138: OPEN c_resource ;
2139: FETCH c_resource INTO l_person_id ;
2140: IF c_resource%NOTFOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2141: x_return_status := FND_API.G_RET_STS_ERROR;

2137: x_return_status := FND_API.G_RET_STS_SUCCESS;
2138: OPEN c_resource ;
2139: FETCH c_resource INTO l_person_id ;
2140: IF c_resource%NOTFOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
2143: FND_MSG_PUB.Add;
2144: END IF;
2145: CLOSE c_resource ;

Line 2153: x_return_status := FND_API.G_RET_STS_ERROR;

2149: p_orig_system_id => l_person_id ,
2150: p_name => x_role_name,
2151: p_display_name => x_role_display_name );
2152: IF x_role_name is null then
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
2155: FND_MSG_PUB.Add;
2156: END IF;
2157: END Get_User_Role;

Line 2192: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

2188: END IF;
2189:
2190: l_msg_count := FND_MSG_PUB.count_msg;
2191: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
2192: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
2193: Ams_Utility_PVT.Create_Log (
2194: x_return_status => l_return_status_log
2195: , p_arc_log_used_by => p_object_type
2196: , p_log_used_by_id => p_object_id

Line 2222: x_return_status := FND_API.G_RET_STS_SUCCESS;

2218: L_API_NAME CONSTANT VARCHAR2(30) := 'cancel_process';
2219:
2220: l_wf_result VARCHAR2(30);
2221: BEGIN
2222: x_return_status := FND_API.G_RET_STS_SUCCESS;
2223:
2224: WF_Engine.AbortProcess (
2225: itemtype => G_DEFAULT_ITEMTYPE,
2226: itemkey => p_itemkey,

Line 2237: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: -- Change by nyostos on Jan 6, 2003
2236: -- Commented the following line to ignore any errors when aborting the WF process
2237: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2238: --COMMIT;
2239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2241: END IF;

Line 2270: x_return_status := FND_API.G_RET_STS_SUCCESS;

2266:
2267: l_msg_count NUMBER;
2268: l_msg_data VARCHAR2(4000);
2269: BEGIN
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271:
2272: -- after copying all the process attributes,
2273: -- cancel the current process and create a
2274: -- new one.

Line 2292: p_init_msg_list => FND_API.G_FALSE,

2288: , aname => 'ORIG_USER_STATUS_ID'
2289: );
2290:
2291: AMS_Utility_PVT.convert_timezone (
2292: p_init_msg_list => FND_API.G_FALSE,
2293: x_return_status => x_return_status,
2294: x_msg_count => l_msg_count,
2295: x_msg_data => l_msg_data,
2296: p_user_tz_id => p_scheduled_timezone_id,

Line 2301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2297: p_in_time => p_scheduled_date,
2298: p_convert_type => 'SYS',
2299: x_out_time => l_system_scheduled_date
2300: );
2301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303: END IF;
2304:
2305: -- abort the current process

Line 2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2298: p_convert_type => 'SYS',
2299: x_out_time => l_system_scheduled_date
2300: );
2301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303: END IF;
2304:
2305: -- abort the current process
2306: WF_Engine.AbortProcess (

Line 2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2323:
2324: --COMMIT; -- otherwise, WF engine does not get this
2325: EXCEPTION
2326: WHEN OTHERS THEN
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2328: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2330: END IF;
2331: END change_schedule;

Line 2618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2614: p_model_id => l_object_id,
2615: p_status_code => G_STATUS_FAILED,
2616: x_return_status => l_return_status
2617: );
2618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621: ELSE
2622: AMS_DM_Score_PVT.wf_revert (

Line 2619: RAISE FND_API.G_EXC_ERROR;

2615: p_status_code => G_STATUS_FAILED,
2616: x_return_status => l_return_status
2617: );
2618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621: ELSE
2622: AMS_DM_Score_PVT.wf_revert (
2623: p_score_id => l_object_id,

Line 2627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2623: p_score_id => l_object_id,
2624: p_status_code => G_STATUS_FAILED,
2625: x_return_status => l_return_status
2626: );
2627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2630: END IF;
2631:

Line 2628: RAISE FND_API.G_EXC_ERROR;

2624: p_status_code => G_STATUS_FAILED,
2625: x_return_status => l_return_status
2626: );
2627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2630: END IF;
2631:
2632: -- nyostos 09/17/2002 - Set STATUS_CODE Workflow global variable to FAILED instead of DRAFT

Line 2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2981: p_score_id => l_object_id,
2982: x_return_status => l_return_status,
2983: x_model_status => l_model_status
2984: );
2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2986: AMS_Utility_PVT.create_log (
2987: x_return_status => l_return_status,
2988: p_arc_log_used_by => 'SCOR',
2989: p_log_used_by_id => l_object_id,