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

Line 17: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

13: l_syndicate_flag VARCHAR2(10) := 'N';
14: l_case_number VARCHAR2(240) := NULL;
15: --l_notification_role VARCHAR2(25) := 'ADMIN';
16: l_report_date Date := NULL;
17: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
18:
19: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
20: ,ica.case_number
21: FROM iex_delinquencies_all ida

Line 40: IF(l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN

36: p_contract_id => cur.object_id
37: ,x_syndicate_flag => l_syndicate_flag);
38: l_case_number := cur.case_number;
39:
40: IF(l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
41: raise G_EXCEPTION_HALT_VALIDATION;
42: END IF;
43:
44: EXIT;

Line 115: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

111: l_delinquency_id NUMBER := NULL;
112: l_sendtothirdparty_flag VARCHAR2(10) := NULL;
113: l_id1 VARCHAR2(200) := NULL;
114:
115: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
116:
117: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
118: , okh.contract_number
119: FROM iex_delinquencies_all ida

Line 221: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

217: l_delinquency_id NUMBER := NULL;
218: l_vendorapproval_flag VARCHAR2(10) := NULL;
219: l_id1 VARCHAR2(200) := NULL;
220:
221: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
222:
223: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
224: , okh.contract_number
225: FROM iex_delinquencies_all ida

Line 327: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

323: l_delinquency_id NUMBER := NULL;
324: l_vendornotify_flag VARCHAR2(10) := NULL;
325: l_id1 VARCHAR2(200) := NULL;
326:
327: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
328:
329: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
330: , okh.contract_number
331: FROM iex_delinquencies_all ida

Line 527: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

523: funcmode in varchar2,
524: resultout out nocopy varchar2) AS
525: l_delinquency_id NUMBER := NULL;
526: l_api_version NUMBER := 1.0;
527: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
528: l_return_status VARCHAR2(1);
529: lx_msg_count NUMBER ;
530: lx_msg_data VARCHAR2(2000);
531:

Line 641: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

637: funcmode in varchar2,
638: resultout out nocopy varchar2) AS
639: l_delinquency_id NUMBER := NULL;
640: l_api_version NUMBER := 1.0;
641: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
642: l_return_status VARCHAR2(1);
643: lx_msg_count NUMBER ;
644: lx_msg_data VARCHAR2(2000);
645:

Line 720: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

716: actid in number,
717: funcmode in varchar2,
718: resultout out nocopy varchar2) AS
719: l_api_version NUMBER := 1.0;
720: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
721: l_return_status VARCHAR2(1);
722: lx_msg_count NUMBER ;
723: lx_msg_data VARCHAR2(2000);
724:

Line 834: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

830: funcmode in varchar2,
831: resultout out nocopy varchar2) AS
832: l_delinquency_id NUMBER := NULL;
833: l_api_version NUMBER := 1.0;
834: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
835: l_return_status VARCHAR2(1);
836: lx_msg_count NUMBER ;
837: lx_msg_data VARCHAR2(2000);
838:

Line 914: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

910: funcmode in varchar2,
911: resultout out nocopy varchar2) AS
912: l_delinquency_id NUMBER := NULL;
913: l_api_version NUMBER := 1.0;
914: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
915: l_return_status VARCHAR2(1);
916: lx_msg_count NUMBER ;
917: lx_msg_data VARCHAR2(2000);
918:

Line 1023: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

1019: funcmode in varchar2,
1020: resultout out nocopy varchar2) AS
1021: l_delinquency_id NUMBER := NULL;
1022: l_api_version NUMBER := 1.0;
1023: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
1024: l_return_status VARCHAR2(1);
1025: lx_msg_count NUMBER ;
1026: lx_msg_data VARCHAR2(2000);
1027:

Line 1120: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

1116: actid in number,
1117: funcmode in varchar2,
1118: resultout out nocopy varchar2) AS
1119: l_api_version NUMBER := 1.0;
1120: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
1121: l_return_status VARCHAR2(1);
1122: lx_msg_count NUMBER ;
1123: lx_msg_data VARCHAR2(2000);
1124:

Line 1266: p_commit => FND_API.G_TRUE,

1262: if (l_work_item_id is not null) then
1263:
1264: iex_stry_utl_pub.update_work_item(
1265: p_api_version => 1.0,
1266: p_commit => FND_API.G_TRUE,
1267: p_init_msg_list => FND_API.G_TRUE,
1268: p_work_item_id => l_work_item_id,
1269: p_status => 'CANCELLED',
1270: x_return_status => l_return_status,

Line 1267: p_init_msg_list => FND_API.G_TRUE,

1263:
1264: iex_stry_utl_pub.update_work_item(
1265: p_api_version => 1.0,
1266: p_commit => FND_API.G_TRUE,
1267: p_init_msg_list => FND_API.G_TRUE,
1268: p_work_item_id => l_work_item_id,
1269: p_status => 'CANCELLED',
1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,

Line 1275: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1271: x_msg_count => l_msg_count,
1272: x_msg_data => l_msg_data
1273: );
1274:
1275: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1276: iex_strategy_wf.send_signal(
1277: process => 'IEXSTRY' ,
1278: strategy_id => l_strategy_id,
1279: status => 'CANCELLED',

Line 1348: p_commit => FND_API.G_TRUE,

1344: if (l_work_item_id is not null) then
1345:
1346: iex_stry_utl_pub.update_work_item(
1347: p_api_version => 1.0,
1348: p_commit => FND_API.G_TRUE,
1349: p_init_msg_list => FND_API.G_TRUE,
1350: p_work_item_id => l_work_item_id,
1351: p_status => 'COMPLETE',
1352: x_return_status => l_return_status,

Line 1349: p_init_msg_list => FND_API.G_TRUE,

1345:
1346: iex_stry_utl_pub.update_work_item(
1347: p_api_version => 1.0,
1348: p_commit => FND_API.G_TRUE,
1349: p_init_msg_list => FND_API.G_TRUE,
1350: p_work_item_id => l_work_item_id,
1351: p_status => 'COMPLETE',
1352: x_return_status => l_return_status,
1353: x_msg_count => l_msg_count,

Line 1357: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1353: x_msg_count => l_msg_count,
1354: x_msg_data => l_msg_data
1355: );
1356:
1357: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1358: iex_strategy_wf.send_signal(
1359: process => 'IEXSTRY' ,
1360: strategy_id => l_strategy_id,
1361: status => 'COMPLETE',