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

Line 143: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

139: , 'Entry');
140: END IF;
141: END IF;
142:
143: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146:
147: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 147: IF NOT FND_API.Compatible_API_Call( l_api_version

143: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146:
147: IF NOT FND_API.Compatible_API_Call( l_api_version
148: , p_api_version
149: , l_api_name
150: , G_PKG_NAME
151: )

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: , l_api_name
150: , G_PKG_NAME
151: )
152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:

Line 156: x_return_status := FND_API.G_RET_STS_SUCCESS;

152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158:
159: -- First Validate the Encumbrance for the local ASL
160: -- get the encumbrance flags for the OU linked to the vendor site id

Line 334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

330: END IF;
331: END IF;
332: RETURN FALSE ;
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335:
336: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
337: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
338: , p_data => x_msg_data);

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

335:
336: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
337: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
338: , p_data => x_msg_data);
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: IF g_fnd_debug = 'Y' THEN
341: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
342: FND_LOG.String( FND_LOG.LEVEL_UNEXPECTED
343: , G_MODULE_PREFIX || l_api_name || '.unexpected_error'

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: WHEN OTHERS THEN
350: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
351: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
352: , p_data => x_msg_data);
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF g_fnd_debug = 'Y' THEN
355: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
357: , G_MODULE_PREFIX || l_api_name || '.others_exception'

Line 495: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

491: , 'Entry');
492: END IF;
493: END IF;
494:
495: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
496: FND_MSG_PUB.initialize;
497: END IF;
498:
499: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 499: IF NOT FND_API.Compatible_API_Call( l_api_version

495: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
496: FND_MSG_PUB.initialize;
497: END IF;
498:
499: IF NOT FND_API.Compatible_API_Call( l_api_version
500: , p_api_version
501: , l_api_name
502: , G_PKG_NAME
503: )

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501: , l_api_name
502: , G_PKG_NAME
503: )
504: THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: -- First Validate the Encumbrance for the GLobal ASL
511: -- get the encumbrance flags for the OU linked to the vendor site id
512: --

Line 683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

679: END IF;
680: END IF;
681: RETURN FALSE ;
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684:
685: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
687: , p_data => x_msg_data);

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684:
685: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
687: , p_data => x_msg_data);
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF g_fnd_debug = 'Y' THEN
690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
691: FND_LOG.String( FND_LOG.LEVEL_UNEXPECTED
692: , G_MODULE_PREFIX || l_api_name || '.unexpected_error'

Line 703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

699:
700: x_validation_error_name := 'PO_SUP_CONS_UNEXPECTED_ERROR';
701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
702: , p_data => x_msg_data);
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF g_fnd_debug = 'Y' THEN
705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
706: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
707: , G_MODULE_PREFIX || l_api_name || '.others_exception'

Line 832: p_init_msg_list => FND_API.G_TRUE,

828:
829: l_return_value_tmp :=
830: PON_VENDOR_PURGE_GRP.validate_vendor_purge
831: ( p_api_version => 1.0,
832: p_init_msg_list => FND_API.G_TRUE,
833: x_return_status => l_rtn_status,
834: x_msg_count => l_msg_count,
835: x_msg_data => l_msg_data,
836: p_vendor_id => p_vendor_id

Line 873: -- exist, x_can_merge will contain value FND_API.G_TRUE

869: --===========================================================================
870: -- API NAME : Validate_Supplier_Merge
871: -- TYPE : Public
872: -- Pre-condition : Supplier site exists. If the supplier site does not
873: -- exist, x_can_merge will contain value FND_API.G_TRUE
874: -- DESCRIPTION : Checks whether a supplier site cannot be
875: -- merged according to Consigned/VMI criteria.
876: -- A merge should fail if for the FROM supplier site:
877: -- - on hand quantity exists in consigned or VMI stock

Line 891: -- x_can_merge FND_API.G_FALSE if the supplier

887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id
891: -- x_can_merge FND_API.G_FALSE if the supplier
892: -- site cannot be merged;
893: -- FND_API.G_TRUE otherwise.
894: -- x_validation_error Name of validation error.
895: -- 'PO_SUP_CONS_FAIL_MERGE_TPS' if

Line 893: -- FND_API.G_TRUE otherwise.

889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id
891: -- x_can_merge FND_API.G_FALSE if the supplier
892: -- site cannot be merged;
893: -- FND_API.G_TRUE otherwise.
894: -- x_validation_error Name of validation error.
895: -- 'PO_SUP_CONS_FAIL_MERGE_TPS' if
896: -- merge should fail because on hand
897: -- consigned/VMI stock exists;

Line 943: IF FND_API.to_boolean(p_init_msg_list) THEN

939: END IF;
940: END IF;
941:
942: -- Start API initialization
943: IF FND_API.to_boolean(p_init_msg_list) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946:
947: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 947: IF NOT FND_API.Compatible_API_Call( l_api_version

943: IF FND_API.to_boolean(p_init_msg_list) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946:
947: IF NOT FND_API.Compatible_API_Call( l_api_version
948: , p_api_version
949: , l_api_name
950: , G_PKG_NAME)
951: THEN

Line 952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

948: , p_api_version
949: , l_api_name
950: , G_PKG_NAME)
951: THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954:
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956: -- End API Initialization

Line 955: x_return_status := FND_API.G_RET_STS_SUCCESS;

951: THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954:
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956: -- End API Initialization
957:
958: x_can_merge := FND_API.G_TRUE;
959:

Line 958: x_can_merge := FND_API.G_TRUE;

954:
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956: -- End API Initialization
957:
958: x_can_merge := FND_API.G_TRUE;
959:
960: IF FND_PROFILE.value('PO_SUPPLIER_CONSIGNED_ENABLED') = 'Y' AND
961: FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_ENABLED') = 'Y'
962: THEN

Line 966: x_can_merge := FND_API.G_FALSE;

962: THEN
963:
964: -- Check for on hand Consigned and VMI stock
965: IF PO_INV_THIRD_PARTY_STOCK_MDTR.Sup_Site_Owns_Tps(p_vendor_site_id) THEN
966: x_can_merge := FND_API.G_FALSE;
967: x_validation_error := 'PO_SUP_CONS_FAIL_MERGE_TPS';
968:
969: ELSE
970:

Line 1019: x_can_merge := FND_API.G_FALSE;

1015: AND nvl(pol.closed_code, 'a') <> 'FINALLY CLOSED'
1016: AND nvl(pol.cancel_flag, 'N') = 'N');
1017:
1018: IF l_open = 1 THEN
1019: x_can_merge := FND_API.G_FALSE;
1020: x_validation_error := 'PO_SUP_CONS_FAIL_MERGE_DOC';
1021: END IF;
1022:
1023: END IF;

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: END IF;
1036:
1037: EXCEPTION
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF g_fnd_debug = 'Y' THEN

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF g_fnd_debug = 'Y' THEN
1044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1045: FND_LOG.String( FND_LOG.LEVEL_UNEXPECTED
1046: , G_MODULE_PREFIX || l_api_name || '.unexpected_error'

Line 1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1050:
1051: WHEN OTHERS THEN
1052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1053: p_data => x_msg_data);
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1055: IF g_fnd_debug = 'Y' THEN
1056: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1057: FND_LOG.String( FND_LOG.LEVEL_UNEXPECTED
1058: , G_MODULE_PREFIX || l_api_name || '.others_exception'

Line 1077: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the

1073: -- the passed in item/supplier/supplier site/organization
1074: -- combination, as OUT parameters.
1075: -- PARAMETERS :
1076: -- p_api_version REQUIRED. API version
1077: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the
1078: -- message list.
1079: -- NULL value is regarded as
1080: -- FND_API.G_FALSE.
1081: -- x_return_status REQUIRED. Value can be

Line 1080: -- FND_API.G_FALSE.

1076: -- p_api_version REQUIRED. API version
1077: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the
1078: -- message list.
1079: -- NULL value is regarded as
1080: -- FND_API.G_FALSE.
1081: -- x_return_status REQUIRED. Value can be
1082: -- FND_API.G_RET_STS_SUCCESS
1083: -- FND_API.G_RET_STS_ERROR
1084: -- FND_API.G_RET_STS_UNEXP_ERROR

Line 1082: -- FND_API.G_RET_STS_SUCCESS

1078: -- message list.
1079: -- NULL value is regarded as
1080: -- FND_API.G_FALSE.
1081: -- x_return_status REQUIRED. Value can be
1082: -- FND_API.G_RET_STS_SUCCESS
1083: -- FND_API.G_RET_STS_ERROR
1084: -- FND_API.G_RET_STS_UNEXP_ERROR
1085: -- x_msg_count REQUIRED. Number of messages on the message
1086: -- list

Line 1083: -- FND_API.G_RET_STS_ERROR

1079: -- NULL value is regarded as
1080: -- FND_API.G_FALSE.
1081: -- x_return_status REQUIRED. Value can be
1082: -- FND_API.G_RET_STS_SUCCESS
1083: -- FND_API.G_RET_STS_ERROR
1084: -- FND_API.G_RET_STS_UNEXP_ERROR
1085: -- x_msg_count REQUIRED. Number of messages on the message
1086: -- list
1087: -- x_msg_data REQUIRED. Return message data if message

Line 1084: -- FND_API.G_RET_STS_UNEXP_ERROR

1080: -- FND_API.G_FALSE.
1081: -- x_return_status REQUIRED. Value can be
1082: -- FND_API.G_RET_STS_SUCCESS
1083: -- FND_API.G_RET_STS_ERROR
1084: -- FND_API.G_RET_STS_UNEXP_ERROR
1085: -- x_msg_count REQUIRED. Number of messages on the message
1086: -- list
1087: -- x_msg_data REQUIRED. Return message data if message
1088: -- count is 1

Line 1152: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

1148: END IF;
1149: END IF;
1150:
1151: -- Start API initialization
1152: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1153: FND_MSG_PUB.initialize;
1154: END IF;
1155:
1156: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 1156: IF NOT FND_API.Compatible_API_Call( l_api_version

1152: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1153: FND_MSG_PUB.initialize;
1154: END IF;
1155:
1156: IF NOT FND_API.Compatible_API_Call( l_api_version
1157: , p_api_version
1158: , l_api_name
1159: , G_PKG_NAME
1160: )

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: , l_api_name
1159: , G_PKG_NAME
1160: )
1161: THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: END IF;
1164:
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166: -- End API initialization

Line 1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

1161: THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: END IF;
1164:
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166: -- End API initialization
1167:
1168: x_enable_vmi_flag := null;
1169: x_consigned_from_supplier_flag := null;

Line 1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1207: END IF;
1208: END IF;
1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: FND_MSG_PUB.Count_And_Get
1213: ( p_count => x_msg_count
1214: , p_data => x_msg_data
1215: );

Line 1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1213: ( p_count => x_msg_count
1214: , p_data => x_msg_data
1215: );
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: IF (g_fnd_debug = 'Y')
1219: THEN
1220: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1221: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1229: ( p_count => x_msg_count
1230: , p_data => x_msg_data
1231: );
1232:
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: IF (g_fnd_debug = 'Y')
1235: THEN
1236: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1255: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message

1251: -- procedure is typically for determining whether an item is
1252: -- expense or not.
1253: -- PARAMETERS :
1254: -- p_api_version REQUIRED. API version
1255: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message
1256: -- list.
1257: -- NULL value is regarded as
1258: -- FND_API.G_FALSE.
1259: -- x_return_status REQUIRED. Value can be

Line 1258: -- FND_API.G_FALSE.

1254: -- p_api_version REQUIRED. API version
1255: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message
1256: -- list.
1257: -- NULL value is regarded as
1258: -- FND_API.G_FALSE.
1259: -- x_return_status REQUIRED. Value can be
1260: -- FND_API.G_RET_STS_SUCCESS
1261: -- FND_API.G_RET_STS_ERROR
1262: -- FND_API.G_RET_STS_UNEXP_ERROR

Line 1260: -- FND_API.G_RET_STS_SUCCESS

1256: -- list.
1257: -- NULL value is regarded as
1258: -- FND_API.G_FALSE.
1259: -- x_return_status REQUIRED. Value can be
1260: -- FND_API.G_RET_STS_SUCCESS
1261: -- FND_API.G_RET_STS_ERROR
1262: -- FND_API.G_RET_STS_UNEXP_ERROR
1263: -- x_msg_count REQUIRED. Number of messages on the message list
1264: -- x_msg_data REQUIRED. Return message data if message count

Line 1261: -- FND_API.G_RET_STS_ERROR

1257: -- NULL value is regarded as
1258: -- FND_API.G_FALSE.
1259: -- x_return_status REQUIRED. Value can be
1260: -- FND_API.G_RET_STS_SUCCESS
1261: -- FND_API.G_RET_STS_ERROR
1262: -- FND_API.G_RET_STS_UNEXP_ERROR
1263: -- x_msg_count REQUIRED. Number of messages on the message list
1264: -- x_msg_data REQUIRED. Return message data if message count
1265: -- is 1

Line 1262: -- FND_API.G_RET_STS_UNEXP_ERROR

1258: -- FND_API.G_FALSE.
1259: -- x_return_status REQUIRED. Value can be
1260: -- FND_API.G_RET_STS_SUCCESS
1261: -- FND_API.G_RET_STS_ERROR
1262: -- FND_API.G_RET_STS_UNEXP_ERROR
1263: -- x_msg_count REQUIRED. Number of messages on the message list
1264: -- x_msg_data REQUIRED. Return message data if message count
1265: -- is 1
1266: -- p_organization_id REQUIRED. Identifier of the organization to

Line 1300: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

1296: END IF;
1297: END IF;
1298:
1299: -- Start API initialization
1300: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1301: FND_MSG_PUB.initialize;
1302: END IF;
1303:
1304: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 1304: IF NOT FND_API.Compatible_API_Call( l_api_version

1300: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1301: FND_MSG_PUB.initialize;
1302: END IF;
1303:
1304: IF NOT FND_API.Compatible_API_Call( l_api_version
1305: , p_api_version
1306: , l_api_name
1307: , G_PKG_NAME
1308: )

Line 1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1306: , l_api_name
1307: , G_PKG_NAME
1308: )
1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312:
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314: -- End API initialization

Line 1313: x_return_status := FND_API.G_RET_STS_SUCCESS;

1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312:
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314: -- End API initialization
1315:
1316: SELECT NVL(inventory_asset_flag, 'N')
1317: INTO x_inventory_asset_flag

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: FND_MSG_PUB.Count_And_Get
1339: ( p_count => x_msg_count
1340: , p_data => x_msg_data
1341: );
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: IF (g_fnd_debug = 'Y')
1344: THEN
1345: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1346: FND_LOG.string(FND_LOG.LEVEL_ERROR

Line 1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1347: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1348: , 'Exception');
1349: END IF;
1350: END IF;
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: FND_MSG_PUB.Count_And_Get
1353: ( p_count => x_msg_count
1354: , p_data => x_msg_data
1355: );

Line 1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1353: ( p_count => x_msg_count
1354: , p_data => x_msg_data
1355: );
1356:
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358: IF (g_fnd_debug = 'Y')
1359: THEN
1360: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1361: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1368: ( p_count => x_msg_count
1369: , p_data => x_msg_data
1370: );
1371:
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: IF (g_fnd_debug = 'Y')
1374: THEN
1375: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1376: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1394: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the

1390: -- of the the consigned status on any child shipments that
1391: -- belong to the PO specified by the passed in PO_HEADER_ID
1392: -- PARAMETERS :
1393: -- p_api_version REQUIRED. API version
1394: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the
1395: -- message list.
1396: -- NULL value is regarded as
1397: -- FND_API.G_FALSE.
1398: -- x_return_status REQUIRED. Value can be

Line 1397: -- FND_API.G_FALSE.

1393: -- p_api_version REQUIRED. API version
1394: -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the
1395: -- message list.
1396: -- NULL value is regarded as
1397: -- FND_API.G_FALSE.
1398: -- x_return_status REQUIRED. Value can be
1399: -- FND_API.G_RET_STS_SUCCESS
1400: -- FND_API.G_RET_STS_ERROR
1401: -- FND_API.G_RET_STS_UNEXP_ERROR

Line 1399: -- FND_API.G_RET_STS_SUCCESS

1395: -- message list.
1396: -- NULL value is regarded as
1397: -- FND_API.G_FALSE.
1398: -- x_return_status REQUIRED. Value can be
1399: -- FND_API.G_RET_STS_SUCCESS
1400: -- FND_API.G_RET_STS_ERROR
1401: -- FND_API.G_RET_STS_UNEXP_ERROR
1402: -- x_msg_count REQUIRED. Number of messages on the message
1403: -- list

Line 1400: -- FND_API.G_RET_STS_ERROR

1396: -- NULL value is regarded as
1397: -- FND_API.G_FALSE.
1398: -- x_return_status REQUIRED. Value can be
1399: -- FND_API.G_RET_STS_SUCCESS
1400: -- FND_API.G_RET_STS_ERROR
1401: -- FND_API.G_RET_STS_UNEXP_ERROR
1402: -- x_msg_count REQUIRED. Number of messages on the message
1403: -- list
1404: -- x_msg_data REQUIRED. Return message data if message

Line 1401: -- FND_API.G_RET_STS_UNEXP_ERROR

1397: -- FND_API.G_FALSE.
1398: -- x_return_status REQUIRED. Value can be
1399: -- FND_API.G_RET_STS_SUCCESS
1400: -- FND_API.G_RET_STS_ERROR
1401: -- FND_API.G_RET_STS_UNEXP_ERROR
1402: -- x_msg_count REQUIRED. Number of messages on the message
1403: -- list
1404: -- x_msg_data REQUIRED. Return message data if message
1405: -- count is 1

Line 1467: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

1463: END IF;
1464: END IF;
1465:
1466: -- Start API initialization
1467: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1468: FND_MSG_PUB.initialize;
1469: END IF;
1470:
1471: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 1471: IF NOT FND_API.Compatible_API_Call( l_api_version

1467: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1468: FND_MSG_PUB.initialize;
1469: END IF;
1470:
1471: IF NOT FND_API.Compatible_API_Call( l_api_version
1472: , p_api_version
1473: , l_api_name
1474: , G_PKG_NAME
1475: )

Line 1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1473: , l_api_name
1474: , G_PKG_NAME
1475: )
1476: THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481: -- End API initialization

Line 1480: x_return_status := FND_API.G_RET_STS_SUCCESS;

1476: THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481: -- End API initialization
1482:
1483: x_consigned_status_affected := NULL;
1484:

Line 1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1531: END IF;
1532: END IF;
1533:
1534: EXCEPTION
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: FND_MSG_PUB.Count_And_Get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data
1539: );

Line 1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data
1539: );
1540:
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542: IF (g_fnd_debug = 'Y')
1543: THEN
1544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1545: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1552: ( p_count => x_msg_count
1553: , p_data => x_msg_data
1554: );
1555:
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF (g_fnd_debug = 'Y')
1558: THEN
1559: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1691: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1687: END IF;
1688:
1689: d_position := 20;
1690:
1691: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1692: THEN
1693: RAISE e_invalid_asset_flag;
1694: END IF;
1695:

Line 1739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1735: IF PO_LOG.d_stmt THEN
1736: PO_LOG.stmt(d_mod,d_position,'consigned flag after call to get_asl_attributes is: ' || l_consigned_flag || ' and l_return_status is: ' || l_return_status);
1737: END IF;
1738:
1739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1740: THEN
1741: RAISE e_invalid_consigned_flag;
1742: END IF;
1743: