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 944: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

940: 'OC INTERFACE :- get_contract_header_info status '
941: || l_return_status
942: );
943:
944: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
945: THEN
946: IF l_order_error IS NULL
947: THEN
948: l_order_error := '#';

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

984: 'OC INTERFACE :- get_k_service_line status '
985: || l_return_status
986: );
987:
988: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
989: THEN
990: IF l_order_error IS NULL
991: THEN
992: l_order_error := '#';

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

1031: 'OC INTERFACE :- get_renew_rules status '
1032: || l_return_status
1033: );
1034:
1035: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1036: THEN
1037: FOR i IN 1 .. fnd_msg_pub.count_msg
1038: LOOP
1039: fnd_msg_pub.get (p_msg_index => -1,

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

1059: 'OC INTERFACE :- get_K_order_details status '
1060: || l_return_status
1061: );
1062:
1063: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1064: THEN
1065: FOR i IN 1 .. fnd_msg_pub.count_msg
1066: LOOP
1067: fnd_msg_pub.get (p_msg_index => -1,

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

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

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

1255: 'OC INTERFACE :- SalesCredit at Header '
1256: || l_return_status
1257: );
1258:
1259: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1260: THEN
1261: FOR i IN 1 .. fnd_msg_pub.count_msg
1262: LOOP
1263: fnd_msg_pub.get (p_msg_index => -1,

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

1391: 'OC INTERFACE :- Create K Hdr status '
1392: || l_return_status
1393: );
1394:
1395: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1396: THEN
1397: IF l_order_error IS NULL
1398: THEN
1399: l_order_error := '#';

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

1460: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1461: || l_return_status
1462: );
1463:
1464: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1465: THEN
1466: FOR i IN 1 .. fnd_msg_pub.count_msg
1467: LOOP
1468: fnd_msg_pub.get (p_msg_index => -1,

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

1487: fnd_file.put_line (fnd_file.LOG,
1488: 'OC INTERFACE :- SalesCredit ' || l_return_status
1489: );
1490:
1491: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1492: THEN
1493: FOR i IN 1 .. fnd_msg_pub.count_msg
1494: LOOP
1495: fnd_msg_pub.get (p_msg_index => -1,

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

1519: 'OC INTERFACE :- SalesCredit at Header - defaulting for order line id = '||p_reproc_line_rec.order_id
1520: || l_return_status
1521: );
1522:
1523: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1524: THEN
1525: FOR i IN 1 .. fnd_msg_pub.count_msg
1526: LOOP
1527: fnd_msg_pub.get (p_msg_index => -1,

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

1618: 'OC INTERFACE :- Create K Line status '
1619: || l_return_status
1620: );
1621:
1622: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1623: THEN
1624: IF l_order_error IS NULL
1625: THEN
1626: l_order_error := '#';

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

1674: x_pricing_att => l_pricing_attributes_in,
1675: x_return_status => l_return_status
1676: );
1677:
1678: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1679: THEN
1680: FOR i IN 1 .. fnd_msg_pub.count_msg
1681: LOOP
1682: fnd_msg_pub.get (p_msg_index => -1,

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

1849: 'OC INTERFACE :- Create K Covd Line status '
1850: || l_return_status
1851: );
1852:
1853: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1854: THEN
1855: IF l_order_error IS NULL
1856: THEN
1857: l_order_error := '#';

Line 2965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2961: ,'After OKS_OMIB_INT_EXTNS_PUB.pre_integration Call: ' ||
2962: ' ,x_process_status = ' || l_process_status ||
2963: ' ,x_return_status = ' || x_return_status);
2964: END IF;
2965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2966: THEN
2967: RAISE G_EXCEPTION_HALT_VALIDATION;
2968: END IF;
2969: --Call out ends here

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

2986: fnd_file.put_line (fnd_file.LOG,
2987: 'l_return_status = ' || l_return_status
2988: );
2989:
2990: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2991: THEN
2992: RAISE g_exception_halt_validation;
2993: END IF;
2994:

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

3046: handle_order_error (x_return_status => l_return_status,
3047: p_upd_rec => l_upd_tbl (1)
3048: );
3049:
3050: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3051: THEN
3052: RAISE g_exception_halt_validation;
3053: END IF;
3054:

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

3220: handle_order_error (x_return_status => l_return_status,
3221: p_upd_rec => l_upd_tbl (1)
3222: );
3223:
3224: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3225: THEN
3226: RAISE g_exception_halt_validation;
3227: END IF;
3228: END IF;

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

3266: 'Create_Contract status ::'
3267: || l_return_status
3268: );
3269:
3270: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3271: THEN
3272: l_error_msg := '#';
3273:
3274: FOR i IN 1 .. fnd_msg_pub.count_msg

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

3316: p_upd_rec => l_upd_tbl
3317: (1)
3318: );
3319:
3320: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3321: THEN
3322: RAISE g_exception_halt_validation;
3323: END IF;
3324: ELSE

Line 3368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3364: ,G_MODULE_CURRENT||'.IB_INTERFACE'
3365: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||
3366: ' ,x_return_status = ' || x_return_status);
3367: END IF;
3368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3369: THEN
3370: RAISE G_EXCEPTION_HALT_VALIDATION;
3371: END IF;
3372:

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

3394: p_upd_rec => l_upd_tbl
3395: (1)
3396: );
3397:
3398: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3399: THEN
3400: RAISE g_exception_halt_validation;
3401: END IF;
3402:

Line 3444: IF NOT (l_return_status = fnd_api.g_ret_sts_success

3440: 'L_return_status :'
3441: || l_return_status
3442: );
3443:
3444: IF NOT (l_return_status = fnd_api.g_ret_sts_success
3445: )
3446: THEN
3447: FOR i IN 1 .. fnd_msg_pub.count_msg
3448: LOOP

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

3489: handle_order_error (x_return_status => l_return_status,
3490: p_upd_rec => l_upd_tbl (1)
3491: );
3492:
3493: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3494: THEN
3495: RAISE g_exception_halt_validation;
3496: END IF;
3497:

Line 3543: IF NOT (l_return_status = fnd_api.g_ret_sts_success

3539: 'L_return_status :'
3540: || l_return_status
3541: );
3542:
3543: IF NOT (l_return_status = fnd_api.g_ret_sts_success
3544: )
3545: THEN
3546: FOR i IN 1 .. fnd_msg_pub.count_msg
3547: LOOP

Line 3609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3605: ,G_MODULE_CURRENT||'.IB_INTERFACE'
3606: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||
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: END IF; --IF of l_process status check

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

3660: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3661: l_index NUMBER;
3662: l_line_count NUMBER;
3663: l_api_version CONSTANT NUMBER := 1.0;
3664: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
3665:
3666: PROCEDURE get_order_lines (
3667: x_return_status OUT NOCOPY VARCHAR2,
3668: x_msg_count OUT NOCOPY NUMBER,

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

3724: 'Get Order Lines: l_return_status = '
3725: || l_return_status
3726: );
3727:
3728: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3729: THEN
3730: FOR i IN 1 .. fnd_msg_pub.count_msg
3731: LOOP
3732: fnd_msg_pub.get (p_msg_index => -1,

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

3787: errbuf OUT NOCOPY VARCHAR2,
3788: retcode OUT NOCOPY NUMBER
3789: )
3790: IS
3791: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
3792: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
3793: l_return_status VARCHAR2 (1);
3794: l_msg_count NUMBER;
3795: l_msg_data VARCHAR2 (2000);

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

3788: retcode OUT NOCOPY NUMBER
3789: )
3790: IS
3791: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;
3792: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
3793: l_return_status VARCHAR2 (1);
3794: l_msg_count NUMBER;
3795: l_msg_data VARCHAR2 (2000);
3796: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

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

3934: x_old_lot_serial_tbl => l_old_lot_serial_tbl,
3935: x_action_request_tbl => l_action_request_tbl
3936: );
3937:
3938: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
3939: THEN
3940: FOR i IN 1 .. fnd_msg_pub.count_msg
3941: LOOP
3942: fnd_msg_pub.get (p_msg_index => -1,

Line 3958: EXIT WHEN l_no_more_messages = fnd_api.g_true;

3954: l_newline_count := l_line_tbl.COUNT;
3955: fnd_file.put_line (fnd_file.LOG,
3956: 'Lines to process = ' || l_newline_count
3957: );
3958: EXIT WHEN l_no_more_messages = fnd_api.g_true;
3959:
3960: IF l_newline_count <= 0
3961: THEN --Order Line Record Found
3962: fnd_file.put_line (fnd_file.LOG, 'No lines to insert');

Line 4127: fnd_api.g_ret_sts_success

4123: || l_return_status
4124: );
4125:
4126: IF NOT (l_return_status =
4127: fnd_api.g_ret_sts_success
4128: )
4129: THEN
4130: FOR i IN 1 .. fnd_msg_pub.count_msg
4131: LOOP

Line 4165: l_return_status := fnd_api.g_ret_sts_success;

4161: THEN
4162: RAISE g_exception_halt_validation;
4163: END IF;
4164:
4165: l_return_status := fnd_api.g_ret_sts_success;
4166: END IF;
4167: END IF;
4168: END IF;
4169: END IF;