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

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: from dual;
118:
119: x_item_key := To_char(l_item_key);
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123:
124: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
125:

Line 142: IF x_return_status = FND_API.g_ret_sts_success then

138: , x_msg_data
139: , x_return_status
140: );
141:
142: IF x_return_status = FND_API.g_ret_sts_success then
143:
144: -- cancle the last running workflow if any
145:
146: OPEN get_last_workflow_info;

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199: IF l_err_code <> 0 THEN
200:
201: PA_UTILS.Add_Message( p_app_short_name => 'PA'
202: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205:
206: -- abort the workflow process just launched, there is a problem
207: WF_ENGINE.AbortProcess( p_Item_Type

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

218:
219:
220: x_msg_count := 1;
221: x_msg_data := substr(SQLERRM,1,2000);
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223:
224: END start_workflow;
225:
226: /********************************************************************

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242:
243: BEGIN
244:
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: --debug_msg ( 'after client cancel_workflow call' );
249:
250: IF (x_return_status = FND_API.g_ret_sts_success) THEN

Line 250: IF (x_return_status = FND_API.g_ret_sts_success) THEN

246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: --debug_msg ( 'after client cancel_workflow call' );
249:
250: IF (x_return_status = FND_API.g_ret_sts_success) THEN
251: WF_ENGINE.AbortProcess( p_Item_Type
252: , p_Item_Key
253: );
254:

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: --debug_msg ( 'Exception in Cancel_Wf ' || substr(SQLERRM,1,2000) );
266:
267: x_msg_count := 1;
268: x_msg_data := substr(SQLERRM,1,2000);
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270:
271: END Cancel_workflow;
272:
273: PROCEDURE change_status_working

Line 325: -- p_encoded => FND_API.G_FALSE));

321:
322: IF l_return_status <> 'S' then
323:
324: --debug_msg_s1('Error: || ' || fnd_msg_pub.get(p_msg_index => 1,
325: -- p_encoded => FND_API.G_FALSE));
326: NULL;
327:
328: END IF;
329:

Line 437: --p_encoded => FND_API.G_FALSE));

433:
434: IF l_return_status <> 'S' then
435:
436: --debug_msg_s1('Error: || ' || fnd_msg_pub.get(p_msg_index => 1,
437: --p_encoded => FND_API.G_FALSE));
438: NULL;
439:
440:
441: END IF;

Line 588: -- p_encoded => FND_API.G_FALSE));

584:
585: IF l_return_status <> 'S' then
586:
587: --debug_msg_s1('Error: || ' || fnd_msg_pub.get(p_msg_index => 1,
588: -- p_encoded => FND_API.G_FALSE));
589:
590: NULL;
591:
592: END IF;

Line 987: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

983: ,x_msg_count => l_msg_count
984: ,x_msg_data => l_msg_data
985: );
986:
987: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
988: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
989: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
990: end if;
991:

Line 1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

1064: WHERE ci_id = c_ci_id;
1065:
1066: BEGIN
1067: x_msg_count := 0;
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1070:
1071: IF l_debug_mode = 'Y' THEN
1072: pa_debug.set_curr_function( p_function => 'START_NOTIFICATION_WF',

Line 1148: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1144: ,x_msg_data => x_msg_data
1145: );
1146:
1147:
1148: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1149: IF l_debug_mode = 'Y' THEN
1150: pa_debug.g_err_stage:= 'Error calling pa_control_item_workflow.SET_WORKFLOW_ATTRIBUTES';
1151: pa_debug.write('START_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
1152:

Line 1188: x_return_status := FND_API.G_RET_STS_ERROR;

1184:
1185: --Log an error message and go to exception section.
1186: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1187: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: Raise Invalid_Arg_Exc_CI;
1190: END IF;
1191:
1192:

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR;

1197: END IF;
1198: EXCEPTION
1199:
1200: WHEN Invalid_Arg_Exc_CI THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: l_msg_count := FND_MSG_PUB.count_msg;
1203:
1204: IF get_project_id%ISOPEN THEN
1205: CLOSE get_project_id;

Line 1210: (p_encoded => FND_API.G_TRUE

1206: END IF;
1207:
1208: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1209: PA_INTERFACE_UTILS_PUB.get_messages
1210: (p_encoded => FND_API.G_TRUE
1211: ,p_msg_index => 1
1212: ,p_msg_count => l_msg_count
1213: ,p_msg_data => l_msg_data
1214: ,p_data => l_data

Line 1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1225: RETURN;
1226:
1227: WHEN others THEN
1228:
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: x_msg_count := 1;
1231: x_msg_data := SQLERRM;
1232:
1233: IF get_project_id%ISOPEN THEN

Line 1482: x_return_status := FND_API.G_RET_STS_SUCCESS;

1478:
1479: BEGIN
1480:
1481: x_msg_count := 0;
1482: x_return_status := FND_API.G_RET_STS_SUCCESS;
1483: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1484:
1485: IF l_debug_mode = 'Y' THEN
1486: pa_debug.set_curr_function( p_function => 'set_workflow_attributes',

Line 1925: x_return_status := FND_API.G_RET_STS_ERROR;

1921: END IF;
1922: EXCEPTION
1923:
1924: WHEN Invalid_Arg_Exc_CI THEN
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: l_msg_count := FND_MSG_PUB.count_msg;
1927:
1928: IF get_project_info%ISOPEN THEN
1929: CLOSE get_project_info;

Line 1954: (p_encoded => FND_API.G_TRUE

1950: END IF;
1951:
1952: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1953: PA_INTERFACE_UTILS_PUB.get_messages
1954: (p_encoded => FND_API.G_TRUE
1955: ,p_msg_index => 1
1956: ,p_msg_count => l_msg_count
1957: ,p_msg_data => l_msg_data
1958: ,p_data => l_data

Line 1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1969: RETURN;
1970:
1971: WHEN others THEN
1972:
1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1974: x_msg_count := 1;
1975: x_msg_data := SQLERRM;
1976:
1977: IF get_project_info%ISOPEN THEN

Line 2053: l_return_status VARCHAR2(1) :=fnd_api.g_ret_sts_success;

2049: l_num_of_actions number;
2050: l_comment_text varchar2(32767);
2051: l_ci_action_id number;
2052: l_record_version_number number;
2053: l_return_status VARCHAR2(1) :=fnd_api.g_ret_sts_success;
2054: l_msg_count number;
2055: l_msg_data varchar2(2000);
2056: l_user_sign_off VARCHAR2(1):='N';
2057: l_assign_party_id NUMBER; --added for bug# 3877985

Line 2181: p_init_msg_list => fnd_api.g_true,

2177: l_comment_text := ' ';
2178: end if;
2179: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2180: p_api_version => 1.0,
2181: p_init_msg_list => fnd_api.g_true,
2182: p_commit => FND_API.g_false,
2183: p_validate_only => FND_API.g_false,
2184: p_max_msg_count => FND_API.g_miss_num,
2185: p_ci_comment_id => l_ci_comment_id,

Line 2182: p_commit => FND_API.g_false,

2178: end if;
2179: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2180: p_api_version => 1.0,
2181: p_init_msg_list => fnd_api.g_true,
2182: p_commit => FND_API.g_false,
2183: p_validate_only => FND_API.g_false,
2184: p_max_msg_count => FND_API.g_miss_num,
2185: p_ci_comment_id => l_ci_comment_id,
2186: p_ci_id => l_ci_id,

Line 2183: p_validate_only => FND_API.g_false,

2179: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2180: p_api_version => 1.0,
2181: p_init_msg_list => fnd_api.g_true,
2182: p_commit => FND_API.g_false,
2183: p_validate_only => FND_API.g_false,
2184: p_max_msg_count => FND_API.g_miss_num,
2185: p_ci_comment_id => l_ci_comment_id,
2186: p_ci_id => l_ci_id,
2187: p_type_code => 'CLOSURE',

Line 2184: p_max_msg_count => FND_API.g_miss_num,

2180: p_api_version => 1.0,
2181: p_init_msg_list => fnd_api.g_true,
2182: p_commit => FND_API.g_false,
2183: p_validate_only => FND_API.g_false,
2184: p_max_msg_count => FND_API.g_miss_num,
2185: p_ci_comment_id => l_ci_comment_id,
2186: p_ci_id => l_ci_id,
2187: p_type_code => 'CLOSURE',
2188: p_comment_text => l_comment_text,

Line 2202: If (l_return_status = fnd_api.g_ret_sts_success) then

2198: OPEN getRecordVersionNumber;
2199: FETCH getRecordVersionNumber into l_ci_record_version_number;
2200: CLOSE getRecordVersionNumber;
2201:
2202: If (l_return_status = fnd_api.g_ret_sts_success) then
2203:
2204: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
2205: p_api_version => 1.0,
2206: p_init_msg_list => fnd_api.g_true,

Line 2206: p_init_msg_list => fnd_api.g_true,

2202: If (l_return_status = fnd_api.g_ret_sts_success) then
2203:
2204: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
2205: p_api_version => 1.0,
2206: p_init_msg_list => fnd_api.g_true,
2207: p_commit => FND_API.g_false,
2208: p_validate_only => FND_API.g_true,
2209: p_max_msg_count => FND_API.g_miss_num,
2210: p_ci_id =>l_CI_ID,

Line 2207: p_commit => FND_API.g_false,

2203:
2204: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
2205: p_api_version => 1.0,
2206: p_init_msg_list => fnd_api.g_true,
2207: p_commit => FND_API.g_false,
2208: p_validate_only => FND_API.g_true,
2209: p_max_msg_count => FND_API.g_miss_num,
2210: p_ci_id =>l_CI_ID,
2211: p_num_of_actions => -1,

Line 2208: p_validate_only => FND_API.g_true,

2204: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
2205: p_api_version => 1.0,
2206: p_init_msg_list => fnd_api.g_true,
2207: p_commit => FND_API.g_false,
2208: p_validate_only => FND_API.g_true,
2209: p_max_msg_count => FND_API.g_miss_num,
2210: p_ci_id =>l_CI_ID,
2211: p_num_of_actions => -1,
2212: p_record_version_number =>l_ci_record_version_number,

Line 2209: p_max_msg_count => FND_API.g_miss_num,

2205: p_api_version => 1.0,
2206: p_init_msg_list => fnd_api.g_true,
2207: p_commit => FND_API.g_false,
2208: p_validate_only => FND_API.g_true,
2209: p_max_msg_count => FND_API.g_miss_num,
2210: p_ci_id =>l_CI_ID,
2211: p_num_of_actions => -1,
2212: p_record_version_number =>l_ci_record_version_number,
2213: x_num_of_actions => l_num_of_actions,

Line 2224: if l_return_status = fnd_api.g_ret_sts_success then

2220: end if;
2221:
2222:
2223: -- Commit the changes if requested
2224: if l_return_status = fnd_api.g_ret_sts_success then
2225: commit;
2226: resultout := wf_engine.eng_completed||':'||'T';
2227: end if;
2228: commit;

Line 2231: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN

2227: end if;
2228: commit;
2229:
2230:
2231: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2232: ROLLBACK TO CLOSE_CI_ACTION;
2233: resultout := wf_engine.eng_completed||':'||'F';
2234: WHEN OTHERS THEN
2235: ROLLBACK TO CLOSE_CI_ACTION;

Line 2289: l_return_status VARCHAR2(1) :=fnd_api.g_ret_sts_success;

2285: l_num_of_actions number;
2286: l_comment_text varchar2(32767);
2287: l_ci_action_id number;
2288: l_record_version_number number;
2289: l_return_status VARCHAR2(1) :=fnd_api.g_ret_sts_success;
2290: l_msg_count number;
2291: l_msg_data varchar2(2000);
2292: l_assign_party_id NUMBER; --added for bug# 3877985
2293: l_fnd_usr_id NUMBER; --added for bug# 3877985

Line 2378: p_init_msg_list => fnd_api.g_true,

2374: IF is_comment_inserted_cur%NOTFOUND THEN
2375: CLOSE is_comment_inserted_cur;
2376: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2377: p_api_version => 1.0,
2378: p_init_msg_list => fnd_api.g_true,
2379: p_commit => FND_API.g_false,
2380: p_validate_only => FND_API.g_false,
2381: p_max_msg_count => FND_API.g_miss_num,
2382: p_ci_comment_id => l_ci_comment_id,

Line 2379: p_commit => FND_API.g_false,

2375: CLOSE is_comment_inserted_cur;
2376: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2377: p_api_version => 1.0,
2378: p_init_msg_list => fnd_api.g_true,
2379: p_commit => FND_API.g_false,
2380: p_validate_only => FND_API.g_false,
2381: p_max_msg_count => FND_API.g_miss_num,
2382: p_ci_comment_id => l_ci_comment_id,
2383: p_ci_id => l_ci_id,

Line 2380: p_validate_only => FND_API.g_false,

2376: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2377: p_api_version => 1.0,
2378: p_init_msg_list => fnd_api.g_true,
2379: p_commit => FND_API.g_false,
2380: p_validate_only => FND_API.g_false,
2381: p_max_msg_count => FND_API.g_miss_num,
2382: p_ci_comment_id => l_ci_comment_id,
2383: p_ci_id => l_ci_id,
2384: p_type_code => 'UNSOLICITED',

Line 2381: p_max_msg_count => FND_API.g_miss_num,

2377: p_api_version => 1.0,
2378: p_init_msg_list => fnd_api.g_true,
2379: p_commit => FND_API.g_false,
2380: p_validate_only => FND_API.g_false,
2381: p_max_msg_count => FND_API.g_miss_num,
2382: p_ci_comment_id => l_ci_comment_id,
2383: p_ci_id => l_ci_id,
2384: p_type_code => 'UNSOLICITED',
2385: p_comment_text => l_comment_text,

Line 2396: if l_return_status = fnd_api.g_ret_sts_success then

2392: x_msg_data => l_msg_data
2393: );
2394:
2395:
2396: if l_return_status = fnd_api.g_ret_sts_success then
2397: commit;
2398: resultout := wf_engine.eng_completed||':'||'T';
2399: end if;
2400: commit;

Line 2405: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN

2401: ELSE
2402: CLOSE is_comment_inserted_cur;
2403: END IF;
2404:
2405: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2406: ROLLBACK TO KEEP_OPEN;
2407: resultout := wf_engine.eng_completed||':'||'F';
2408: WHEN OTHERS THEN
2409: ROLLBACK TO KEEP_OPEN;

Line 2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

2443: and wfi.activity_type_code='NOTICE'
2444: and wfi.activity_status_code='NOTIFIED';
2445:
2446: BEGIN
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448: for nid in get_open_notification(to_char(p_ci_action_id))
2449: loop
2450: WF_NOTIFICATION.CANCEL
2451: ( nid => to_number(nid.notification_id),

Line 2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2466:
2467: WHEN OTHERS THEN
2468: x_msg_count := 1;
2469: x_msg_data := substr(SQLERRM,1,2000);
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: END cancel_notif_and_abort_wf;
2472:
2473:
2474:

Line 2505: x_return_status := FND_API.G_RET_STS_SUCCESS;

2501: l_sign_off_requested VARCHAR2(1);
2502:
2503: BEGIN
2504:
2505: x_return_status := FND_API.G_RET_STS_SUCCESS;
2506:
2507: l_sign_off_requested:= wf_engine.GetItemAttrText
2508: ( itemtype => p_item_type,
2509: itemkey => p_item_key,

Line 2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2529:
2530: WHEN OTHERS THEN
2531: x_msg_count := 1;
2532: x_msg_data := substr(SQLERRM,1,2000);
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534:
2535: END close_notification;
2536:
2537: