DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on OKL_API

Line 562: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

558: x_return_status => l_return_status,
559: x_msg_count => lx_msg_count,
560: x_msg_data => lx_msg_data);
561:
562: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
563: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
565: RAISE okl_api.G_EXCEPTION_ERROR;
566: END IF;

Line 563: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

559: x_msg_count => lx_msg_count,
560: x_msg_data => lx_msg_data);
561:
562: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
563: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
565: RAISE okl_api.G_EXCEPTION_ERROR;
566: END IF;
567: END LOOP;

Line 564: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

560: x_msg_data => lx_msg_data);
561:
562: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
563: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
565: RAISE okl_api.G_EXCEPTION_ERROR;
566: END IF;
567: END LOOP;
568: resultout := 'COMPLETE:';

Line 565: RAISE okl_api.G_EXCEPTION_ERROR;

561:
562: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
563: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
565: RAISE okl_api.G_EXCEPTION_ERROR;
566: END IF;
567: END LOOP;
568: resultout := 'COMPLETE:';
569: RETURN ;

Line 676: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

672: x_return_status => l_return_status,
673: x_msg_count => lx_msg_count,
674: x_msg_data => lx_msg_data);
675:
676: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;

Line 677: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

673: x_msg_count => lx_msg_count,
674: x_msg_data => lx_msg_data);
675:
676: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;
681: END LOOP;

Line 678: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

674: x_msg_data => lx_msg_data);
675:
676: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;
681: END LOOP;
682: resultout := 'COMPLETE:';

Line 679: RAISE okl_api.G_EXCEPTION_ERROR;

675:
676: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;
681: END LOOP;
682: resultout := 'COMPLETE:';
683: RETURN ;

Line 773: p_init_msg_list => okl_api.G_TRUE,

769:
770: --call fulfillment
771: OKL_FULFILLMENT_PUB.create_fulfillment (
772: p_api_version => l_api_version,
773: p_init_msg_list => okl_api.G_TRUE,
774: p_agent_id => l_agent_id,
775: p_content_id => l_content_id,
776: p_from => l_from,
777: p_subject => l_subject,

Line 782: p_commit => okl_api.G_FALSE,

778: p_email => l_email,
779: p_bind_var => l_bind_var,
780: p_bind_val => l_bind_val,
781: p_bind_var_type => l_bind_var_type,
782: p_commit => okl_api.G_FALSE,
783: x_request_id => l_request_id,
784: x_return_status => l_return_status,
785: x_msg_count => lx_msg_count,
786: x_msg_data => lx_msg_data);

Line 788: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

784: x_return_status => l_return_status,
785: x_msg_count => lx_msg_count,
786: x_msg_data => lx_msg_data);
787:
788: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
789: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
791: RAISE okl_api.G_EXCEPTION_ERROR;
792: END IF;

Line 789: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

785: x_msg_count => lx_msg_count,
786: x_msg_data => lx_msg_data);
787:
788: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
789: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
791: RAISE okl_api.G_EXCEPTION_ERROR;
792: END IF;
793:

Line 790: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

786: x_msg_data => lx_msg_data);
787:
788: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
789: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
791: RAISE okl_api.G_EXCEPTION_ERROR;
792: END IF;
793:
794: resultout := 'COMPLETE:';

Line 791: RAISE okl_api.G_EXCEPTION_ERROR;

787:
788: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
789: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
791: RAISE okl_api.G_EXCEPTION_ERROR;
792: END IF;
793:
794: resultout := 'COMPLETE:';
795: RETURN ;

Line 869: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

865: x_return_status => l_return_status,
866: x_msg_count => lx_msg_count,
867: x_msg_data => lx_msg_data);
868:
869: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
870: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
871: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
872: RAISE okl_api.G_EXCEPTION_ERROR;
873: END IF;

Line 870: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

866: x_msg_count => lx_msg_count,
867: x_msg_data => lx_msg_data);
868:
869: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
870: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
871: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
872: RAISE okl_api.G_EXCEPTION_ERROR;
873: END IF;
874: END LOOP;

Line 871: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

867: x_msg_data => lx_msg_data);
868:
869: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
870: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
871: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
872: RAISE okl_api.G_EXCEPTION_ERROR;
873: END IF;
874: END LOOP;
875: resultout := 'COMPLETE:';

Line 872: RAISE okl_api.G_EXCEPTION_ERROR;

868:
869: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
870: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
871: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
872: RAISE okl_api.G_EXCEPTION_ERROR;
873: END IF;
874: END LOOP;
875: resultout := 'COMPLETE:';
876: RETURN ;

Line 978: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

974: x_return_status => l_return_status,
975: x_msg_count => lx_msg_count,
976: x_msg_data => lx_msg_data);
977:
978: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
981: RAISE okl_api.G_EXCEPTION_ERROR;
982: END IF;

Line 979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

975: x_msg_count => lx_msg_count,
976: x_msg_data => lx_msg_data);
977:
978: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
981: RAISE okl_api.G_EXCEPTION_ERROR;
982: END IF;
983: END LOOP;

Line 980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

976: x_msg_data => lx_msg_data);
977:
978: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
981: RAISE okl_api.G_EXCEPTION_ERROR;
982: END IF;
983: END LOOP;
984: resultout := 'COMPLETE:';

Line 981: RAISE okl_api.G_EXCEPTION_ERROR;

977:
978: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
981: RAISE okl_api.G_EXCEPTION_ERROR;
982: END IF;
983: END LOOP;
984: resultout := 'COMPLETE:';
985: RETURN ;

Line 1075: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

1071: ,x_return_status => l_return_status
1072: ,x_msg_count => lx_msg_count
1073: ,x_msg_data => lx_msg_data);
1074:
1075: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1078: RAISE okl_api.G_EXCEPTION_ERROR;
1079: END IF;

Line 1076: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

1072: ,x_msg_count => lx_msg_count
1073: ,x_msg_data => lx_msg_data);
1074:
1075: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1078: RAISE okl_api.G_EXCEPTION_ERROR;
1079: END IF;
1080: END LOOP;

Line 1077: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

1073: ,x_msg_data => lx_msg_data);
1074:
1075: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1078: RAISE okl_api.G_EXCEPTION_ERROR;
1079: END IF;
1080: END LOOP;
1081: resultout := 'COMPLETE:';

Line 1078: RAISE okl_api.G_EXCEPTION_ERROR;

1074:
1075: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1078: RAISE okl_api.G_EXCEPTION_ERROR;
1079: END IF;
1080: END LOOP;
1081: resultout := 'COMPLETE:';
1082: RETURN ;

Line 1170: p_init_msg_list => okl_api.G_TRUE,

1166:
1167: --call fulfillment
1168: OKL_FULFILLMENT_PUB.create_fulfillment (
1169: p_api_version => l_api_version,
1170: p_init_msg_list => okl_api.G_TRUE,
1171: p_agent_id => l_agent_id,
1172: p_content_id => l_content_id,
1173: p_from => l_from,
1174: p_subject => l_subject,

Line 1179: p_commit => okl_api.G_FALSE,

1175: p_email => l_email,
1176: p_bind_var => l_bind_var,
1177: p_bind_val => l_bind_val,
1178: p_bind_var_type => l_bind_var_type,
1179: p_commit => okl_api.G_FALSE,
1180: x_request_id => l_request_id,
1181: x_return_status => l_return_status,
1182: x_msg_count => lx_msg_count,
1183: x_msg_data => lx_msg_data);

Line 1185: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

1181: x_return_status => l_return_status,
1182: x_msg_count => lx_msg_count,
1183: x_msg_data => lx_msg_data);
1184:
1185: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1188: RAISE okl_api.G_EXCEPTION_ERROR;
1189: END IF;

Line 1186: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

1182: x_msg_count => lx_msg_count,
1183: x_msg_data => lx_msg_data);
1184:
1185: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1188: RAISE okl_api.G_EXCEPTION_ERROR;
1189: END IF;
1190:

Line 1187: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

1183: x_msg_data => lx_msg_data);
1184:
1185: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1188: RAISE okl_api.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: resultout := 'COMPLETE:';

Line 1188: RAISE okl_api.G_EXCEPTION_ERROR;

1184:
1185: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1188: RAISE okl_api.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: resultout := 'COMPLETE:';
1192: RETURN ;

Line 1574: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

1570: --Code for raising an event ends here
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
1575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1576: FND_MSG_PUB.ADD;
1577: ROLLBACK TO raise_report_cb_event;
1578: END raise_report_cb_event;