DBA Data[Home] [Help]

APPS.OKS_UTIL_PUB dependencies on FND_API

Line 479: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN

475: l_retval BOOLEAN;
476: BEGIN
477:
478:
479: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN
480:
481: l_retval := fnd_installation.get(l_application_id,l_application_id,
482: l_status,l_industry);
483:

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949: IF ( to_number(to_char(l_CC_Expiry_Date,'YYYYMM')) <
950: to_number(to_char(SYSDATE,'YYYYMM'))
951: ) then
952: x_entity_id := NULL;
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954: ELSE
955:
956: l_Authoring_Org_ID := okc_context.get_okc_org_id;
957: l_Cust_Account_Site_ID := P_Bill_To_Site_Use_ID;

Line 1019: ,p_commit => FND_API.G_FALSE

1015: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1016: (
1017: p_api_version => P_api_version
1018: ,p_init_msg_list => p_init_msg_list
1019: ,p_commit => FND_API.G_FALSE
1020: ,x_return_status => x_return_status
1021: ,x_msg_count => x_msg_count
1022: ,x_msg_data => x_msg_data
1023: ,p_payer => l_PayerContext_Rec

Line 1037: ,p_commit => FND_API.G_FALSE

1033: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
1034: (
1035: p_api_version => p_api_version
1036: ,p_init_msg_list => p_init_msg_list
1037: ,p_commit => FND_API.G_FALSE
1038: ,x_return_status => x_return_status
1039: ,x_msg_count => x_msg_count
1040: ,x_msg_data => x_msg_data
1041: ,p_payer => l_PayerContext_Rec

Line 1052: IF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

1048: ****/
1049:
1050:
1051:
1052: IF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1053: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
1054: fnd_message.set_token
1055: ('IBY_API_NAME',
1056: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : '||l_response.result_code);

Line 1059: RAISE fnd_api.g_exc_unexpected_error;

1055: ('IBY_API_NAME',
1056: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : '||l_response.result_code);
1057: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
1058: fnd_msg_pub.ADD;
1059: RAISE fnd_api.g_exc_unexpected_error;
1060: ELSIF (x_return_status = FND_API.g_ret_sts_error) THEN
1061: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
1062: fnd_message.set_token
1063: ('IBY_API_NAME',

Line 1060: ELSIF (x_return_status = FND_API.g_ret_sts_error) THEN

1056: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : '||l_response.result_code);
1057: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
1058: fnd_msg_pub.ADD;
1059: RAISE fnd_api.g_exc_unexpected_error;
1060: ELSIF (x_return_status = FND_API.g_ret_sts_error) THEN
1061: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
1062: fnd_message.set_token
1063: ('IBY_API_NAME',
1064: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension :'||l_response.result_code);

Line 1067: RAISE fnd_api.g_exc_error;

1063: ('IBY_API_NAME',
1064: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension :'||l_response.result_code);
1065: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
1066: fnd_msg_pub.ADD;
1067: RAISE fnd_api.g_exc_error;
1068: END IF;
1069:
1070:
1071:

Line 1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1090: ,'Exception in call to IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension, x_return_status ='||x_return_status
1091: ||'SQLERRM ='||SQLERRM
1092: );
1093: END IF;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension', substr(SQLERRM,1,240));
1096: RAISE;
1097:
1098: End;

Line 1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1116: ,'General Exception in Create_Transaction_Exception, x_return_status ='||x_return_status
1117: ||'SQLERRM ='||SQLERRM
1118: );
1119: END IF;
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: IF GetInstrAssgnID%ISOPEN then
1122: CLOSE GetInstrAssgnID;
1123: END IF;
1124: IF GetAcctInfo%ISOPEN then