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

Line 87: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;

83: errbuf OUT NOCOPY VARCHAR2,
84: retcode OUT NOCOPY NUMBER
85: )
86: IS
87: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
88: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
89: l_return_status VARCHAR2 (1);
90: l_msg_count NUMBER;
91: l_msg_data VARCHAR2 (2000);

Line 88: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;

84: retcode OUT NOCOPY NUMBER
85: )
86: IS
87: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
88: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
89: l_return_status VARCHAR2 (1);
90: l_msg_count NUMBER;
91: l_msg_data VARCHAR2 (2000);
92: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

Line 247: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

243: x_old_lot_serial_tbl => l_old_lot_serial_tbl,
244: x_action_request_tbl => l_action_request_tbl
245: );
246:
247: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
248: THEN
249: FOR i IN 1 .. fnd_msg_pub.count_msg
250: LOOP
251: fnd_msg_pub.get (p_msg_index => -1,

Line 267: EXIT WHEN l_no_more_messages = fnd_api.g_true;

263: l_newline_count := l_line_tbl.COUNT;
264: fnd_file.put_line (fnd_file.LOG,
265: 'Lines to process = ' || l_newline_count
266: );
267: EXIT WHEN l_no_more_messages = fnd_api.g_true;
268:
269: IF l_newline_count <= 0
270: THEN --Order Line Record Found
271: fnd_file.put_line (fnd_file.LOG, 'No lines to insert');

Line 442: fnd_api.g_ret_sts_success

438: || l_return_status
439: );
440:
441: IF NOT (l_return_status =
442: fnd_api.g_ret_sts_success
443: )
444: THEN
445: FOR i IN 1 .. fnd_msg_pub.count_msg
446: LOOP

Line 480: l_return_status := fnd_api.g_ret_sts_success;

476: THEN
477: RAISE g_exception_halt_validation;
478: END IF;
479:
480: l_return_status := fnd_api.g_ret_sts_success;
481: END IF;
482: END IF;
483: END IF;
484: END IF;

Line 584: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

580: fnd_file.put_line (fnd_file.LOG,
581: 'Update Row : Return Status = ' || l_return_status
582: );
583:
584: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
585: THEN
586: FOR i IN 1 .. fnd_msg_pub.count_msg
587: LOOP
588: fnd_msg_pub.get (p_msg_index => -1,

Line 633: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;

629: p_option IN VARCHAR2,
630: p_source IN VARCHAR2
631: )
632: IS
633: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
634: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
635: l_return_status VARCHAR2 (1);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2 (2000);

Line 634: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;

630: p_source IN VARCHAR2
631: )
632: IS
633: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
634: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
635: l_return_status VARCHAR2 (1);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2 (2000);
638: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

Line 1030: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1026: 'OC INTERFACE :- get_contract_header_info status '
1027: || l_return_status
1028: );
1029:
1030: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1031: THEN
1032: IF l_order_error IS NULL
1033: THEN
1034: l_order_error := '#';

Line 1074: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1070: 'OC INTERFACE :- get_k_service_line status '
1071: || l_return_status
1072: );
1073:
1074: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1075: THEN
1076: IF l_order_error IS NULL
1077: THEN
1078: l_order_error := '#';

Line 1121: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1117: 'OC INTERFACE :- get_renew_rules status '
1118: || l_return_status
1119: );
1120:
1121: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1122: THEN
1123: FOR i IN 1 .. fnd_msg_pub.count_msg
1124: LOOP
1125: fnd_msg_pub.get (p_msg_index => -1,

Line 1149: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1145: 'OC INTERFACE :- get_K_order_details status '
1146: || l_return_status
1147: );
1148:
1149: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1150: THEN
1151: FOR i IN 1 .. fnd_msg_pub.count_msg
1152: LOOP
1153: fnd_msg_pub.get (p_msg_index => -1,

Line 1206: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1202: 'OC INTERFACE :- get_period_defaults l_period_type '
1203: || l_period_type
1204: );
1205:
1206: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1207: THEN
1208: FOR i IN 1 .. fnd_msg_pub.count_msg
1209: LOOP
1210: fnd_msg_pub.get (p_msg_index => -1,

Line 1425: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1421: 'OC INTERFACE :- SalesCredit at Header '
1422: || l_return_status
1423: );
1424:
1425: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1426: THEN
1427: FOR i IN 1 .. fnd_msg_pub.count_msg
1428: LOOP
1429: fnd_msg_pub.get (p_msg_index => -1,

Line 1569: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1565: 'OC INTERFACE :- Create K Hdr status '
1566: || l_return_status
1567: );
1568:
1569: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1570: THEN
1571: IF l_order_error IS NULL
1572: THEN
1573: l_order_error := '#';

Line 1638: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1634: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1635: || l_return_status
1636: );
1637:
1638: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1639: THEN
1640: FOR i IN 1 .. fnd_msg_pub.count_msg
1641: LOOP
1642: fnd_msg_pub.get (p_msg_index => -1,

Line 1665: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1661: fnd_file.put_line (fnd_file.LOG,
1662: 'OC INTERFACE :- SalesCredit ' || l_return_status
1663: );
1664:
1665: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1666: THEN
1667: FOR i IN 1 .. fnd_msg_pub.count_msg
1668: LOOP
1669: fnd_msg_pub.get (p_msg_index => -1,

Line 1697: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1693: 'OC INTERFACE :- SalesCredit at Header - defaulting for order line id = '||p_reproc_line_rec.order_id
1694: || l_return_status
1695: );
1696:
1697: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1698: THEN
1699: FOR i IN 1 .. fnd_msg_pub.count_msg
1700: LOOP
1701: fnd_msg_pub.get (p_msg_index => -1,

Line 1809: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1805: 'OC INTERFACE :- Create K Line status '
1806: || l_return_status
1807: );
1808:
1809: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1810: THEN
1811: IF l_order_error IS NULL
1812: THEN
1813: l_order_error := '#';

Line 1865: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1861: x_pricing_att => l_pricing_attributes_in,
1862: x_return_status => l_return_status
1863: );
1864:
1865: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1866: THEN
1867: FOR i IN 1 .. fnd_msg_pub.count_msg
1868: LOOP
1869: fnd_msg_pub.get (p_msg_index => -1,

Line 2063: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

2059: 'OC INTERFACE :- Create K Covd Line status '
2060: || l_return_status
2061: );
2062:
2063: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2064: THEN
2065: IF l_order_error IS NULL
2066: THEN
2067: l_order_error := '#';

Line 2261: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

2257: x_pricing_att => l_pricing_attributes_in,
2258: x_return_status => l_return_status
2259: );
2260:
2261: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2262: THEN
2263: FOR i IN 1 .. fnd_msg_pub.count_msg
2264: LOOP
2265: fnd_msg_pub.get (p_msg_index => -1,

Line 3609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3605: ,'After OKS_OMIB_INT_EXTNS_PUB.pre_integration Call: ' ||
3606: ' ,x_process_status = ' || l_process_status ||
3607: ' ,x_return_status = ' || x_return_status);
3608: END IF;
3609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3610: THEN
3611: RAISE G_EXCEPTION_HALT_VALIDATION;
3612: END IF;
3613: --Call out ends here

Line 3634: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

3630: fnd_file.put_line (fnd_file.LOG,
3631: 'l_return_status = ' || l_return_status
3632: );
3633:
3634: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3635: THEN
3636: RAISE g_exception_halt_validation;
3637: END IF;
3638:

Line 3694: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

3690: handle_order_error (x_return_status => l_return_status,
3691: p_upd_rec => l_upd_tbl (1)
3692: );
3693:
3694: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3695: THEN
3696: RAISE g_exception_halt_validation;
3697: END IF;
3698:

Line 3868: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

3864: handle_order_error (x_return_status => l_return_status,
3865: p_upd_rec => l_upd_tbl (1)
3866: );
3867:
3868: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3869: THEN
3870: RAISE g_exception_halt_validation;
3871: END IF;
3872: END IF;

Line 3914: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

3910: 'Create_Contract status ::'
3911: || l_return_status
3912: );
3913:
3914: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3915: THEN
3916: l_error_msg := '#';
3917:
3918: FOR i IN 1 .. fnd_msg_pub.count_msg

Line 3964: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

3960: p_upd_rec => l_upd_tbl
3961: (1)
3962: );
3963:
3964: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3965: THEN
3966: RAISE g_exception_halt_validation;
3967: END IF;
3968: ELSE

Line 4012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4008: ,G_MODULE_CURRENT||'.IB_INTERFACE'
4009: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||
4010: ' ,x_return_status = ' || x_return_status);
4011: END IF;
4012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4013: THEN
4014: RAISE G_EXCEPTION_HALT_VALIDATION;
4015: END IF;
4016:

Line 4042: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

4038: p_upd_rec => l_upd_tbl
4039: (1)
4040: );
4041:
4042: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
4043: THEN
4044: RAISE g_exception_halt_validation;
4045: END IF;
4046:

Line 4088: IF NOT (l_return_status = fnd_api.g_ret_sts_success

4084: 'L_return_status :'
4085: || l_return_status
4086: );
4087:
4088: IF NOT (l_return_status = fnd_api.g_ret_sts_success
4089: )
4090: THEN
4091: FOR i IN 1 .. fnd_msg_pub.count_msg
4092: LOOP

Line 4137: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

4133: handle_order_error (x_return_status => l_return_status,
4134: p_upd_rec => l_upd_tbl (1)
4135: );
4136:
4137: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
4138: THEN
4139: RAISE g_exception_halt_validation;
4140: END IF;
4141:

Line 4187: IF NOT (l_return_status = fnd_api.g_ret_sts_success

4183: 'L_return_status :'
4184: || l_return_status
4185: );
4186:
4187: IF NOT (l_return_status = fnd_api.g_ret_sts_success
4188: )
4189: THEN
4190: FOR i IN 1 .. fnd_msg_pub.count_msg
4191: LOOP

Line 4253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4249: ,G_MODULE_CURRENT||'.IB_INTERFACE'
4250: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||
4251: ' ,x_return_status = ' || x_return_status);
4252: END IF;
4253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4254: THEN
4255: RAISE G_EXCEPTION_HALT_VALIDATION;
4256: END IF;
4257: END IF; --IF of l_process status check

Line 4308: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;

4304: l_repv_tbl oks_rep_pvt.repv_tbl_type;
4305: l_index NUMBER;
4306: l_line_count NUMBER;
4307: l_api_version CONSTANT NUMBER := 1.0;
4308: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
4309:
4310: PROCEDURE get_order_lines (
4311: x_return_status OUT NOCOPY VARCHAR2,
4312: x_msg_count OUT NOCOPY NUMBER,

Line 4372: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

4368: 'Get Order Lines: l_return_status = '
4369: || l_return_status
4370: );
4371:
4372: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
4373: THEN
4374: FOR i IN 1 .. fnd_msg_pub.count_msg
4375: LOOP
4376: fnd_msg_pub.get (p_msg_index => -1,

Line 4435: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;

4431: errbuf OUT NOCOPY VARCHAR2,
4432: retcode OUT NOCOPY NUMBER
4433: )
4434: IS
4435: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
4436: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
4437: l_return_status VARCHAR2 (1);
4438: l_msg_count NUMBER;
4439: l_msg_data VARCHAR2 (2000);

Line 4436: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;

4432: retcode OUT NOCOPY NUMBER
4433: )
4434: IS
4435: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
4436: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
4437: l_return_status VARCHAR2 (1);
4438: l_msg_count NUMBER;
4439: l_msg_data VARCHAR2 (2000);
4440: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

Line 4582: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

4578: x_old_lot_serial_tbl => l_old_lot_serial_tbl,
4579: x_action_request_tbl => l_action_request_tbl
4580: );
4581:
4582: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
4583: THEN
4584: FOR i IN 1 .. fnd_msg_pub.count_msg
4585: LOOP
4586: fnd_msg_pub.get (p_msg_index => -1,

Line 4602: EXIT WHEN l_no_more_messages = fnd_api.g_true;

4598: l_newline_count := l_line_tbl.COUNT;
4599: fnd_file.put_line (fnd_file.LOG,
4600: 'Lines to process = ' || l_newline_count
4601: );
4602: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4603:
4604: IF l_newline_count <= 0
4605: THEN --Order Line Record Found
4606: fnd_file.put_line (fnd_file.LOG, 'No lines to insert');

Line 4771: fnd_api.g_ret_sts_success

4767: || l_return_status
4768: );
4769:
4770: IF NOT (l_return_status =
4771: fnd_api.g_ret_sts_success
4772: )
4773: THEN
4774: FOR i IN 1 .. fnd_msg_pub.count_msg
4775: LOOP

Line 4809: l_return_status := fnd_api.g_ret_sts_success;

4805: THEN
4806: RAISE g_exception_halt_validation;
4807: END IF;
4808:
4809: l_return_status := fnd_api.g_ret_sts_success;
4810: END IF;
4811: END IF;
4812: END IF;
4813: END IF;