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_AUTOSOURCE_SV dependencies on FND_API

Line 1225: IF l_return_status <> FND_API.g_ret_sts_success THEN

1221: p_document_subtype => 'PURCHASE',
1222: x_return_contract => l_return_contract,
1223: x_return_status => l_return_status
1224: );
1225: IF l_return_status <> FND_API.g_ret_sts_success THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;
1228: END IF;
1229:

Line 1226: RAISE FND_API.g_exc_unexpected_error;

1222: x_return_contract => l_return_contract,
1223: x_return_status => l_return_status
1224: );
1225: IF l_return_status <> FND_API.g_ret_sts_success THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;
1228: END IF;
1229:
1230: IF g_debug_stmt THEN

Line 2038: p_init_msg_list => FND_API.G_TRUE,

2034: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
2035: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
2036:
2037: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
2038: p_init_msg_list => FND_API.G_TRUE,
2039: x_return_status => l_return_status,
2040: x_msg_count => l_msg_count,
2041: x_msg_data => l_msg_data,
2042: p_doc_style_id => null,

Line 2050: if l_return_status <> FND_API.g_ret_sts_success THEN

2046: p_destination_type => p_destination_type,
2047: p_source => 'REQUISITION'
2048: );
2049:
2050: if l_return_status <> FND_API.g_ret_sts_success THEN
2051: l_eligible_doc_flag := FALSE;
2052: IF g_debug_stmt THEN
2053: PO_DEBUG.debug_stmt(l_log_head,l_progress,'style validation failed');
2054: END IF;

Line 2117: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

2113: p_destination_doc_type => x_destination_doc_type, --
2114: p_multi_org => x_multi_org --
2115: );
2116:
2117: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
2118: l_progress := '070';
2119: IF g_debug_stmt THEN
2120: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document from ASL:');
2121: PO_DEBUG.debug_var(l_log_head,l_progress,'Total DOcuments looked at', L_GET_DOCS_ON_ASL_CSR%ROWCOUNT);

Line 2235: p_init_msg_list => FND_API.G_TRUE,

2231: END IF;
2232: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
2233: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
2234: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
2235: p_init_msg_list => FND_API.G_TRUE,
2236: x_return_status => l_return_status,
2237: x_msg_count => l_msg_count,
2238: x_msg_data => l_msg_data,
2239: p_doc_style_id => null,

Line 2247: if l_return_status <> FND_API.g_ret_sts_success THEN

2243: p_destination_type => p_destination_type,
2244: p_source => 'REQUISITION'
2245: );
2246:
2247: if l_return_status <> FND_API.g_ret_sts_success THEN
2248: l_eligible_doc_flag := FALSE;
2249: IF g_debug_stmt THEN
2250: PO_DEBUG.debug_stmt(l_log_head,l_progress,'style validation failed');
2251: END IF;

Line 2313: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

2309: p_destination_doc_type => x_destination_doc_type, --
2310: p_multi_org => x_multi_org --
2311: );
2312:
2313: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
2314: l_progress := '090';
2315: IF g_debug_stmt THEN
2316: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document from ASL with sysdate:');
2317: PO_DEBUG.debug_var(l_log_head,l_progress,'Total DOcuments looked at', L_GET_DOCS_ON_ASL_CSR%ROWCOUNT);

Line 3131: p_init_msg_list => FND_API.G_TRUE,

3127: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
3128: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
3129:
3130: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3131: p_init_msg_list => FND_API.G_TRUE,
3132: x_return_status => l_return_status,
3133: x_msg_count => l_msg_count,
3134: x_msg_data => l_msg_data,
3135: p_doc_style_id => null,

Line 3143: if l_return_status <> FND_API.g_ret_sts_success THEN

3139: p_destination_type => p_destination_type,
3140: p_source => 'REQUISITION'
3141: );
3142:
3143: if l_return_status <> FND_API.g_ret_sts_success THEN
3144: l_eligible_doc_flag := FALSE;
3145: end if;
3146: end if;
3147:

Line 3176: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

3172: p_destination_doc_type => x_destination_doc_type, --
3173: p_multi_org => x_multi_org --
3174: );
3175:
3176: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
3177: l_progress := '040';
3178: IF g_debug_stmt THEN
3179: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document:');
3180: PO_DEBUG.debug_var(l_log_head,l_progress,'Total Documents looked at', L_GET_LATEST_DOCS_CSR%ROWCOUNT);

Line 3298: p_init_msg_list => FND_API.G_TRUE,

3294:
3295: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
3296: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
3297: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3298: p_init_msg_list => FND_API.G_TRUE,
3299: x_return_status => l_return_status,
3300: x_msg_count => l_msg_count,
3301: x_msg_data => l_msg_data,
3302: p_doc_style_id => null,

Line 3310: if l_return_status <> FND_API.g_ret_sts_success THEN

3306: p_destination_type => p_destination_type,
3307: p_source => 'REQUISITION'
3308: );
3309:
3310: if l_return_status <> FND_API.g_ret_sts_success THEN
3311: l_eligible_doc_flag := FALSE;
3312: end if;
3313:
3314: end if;

Line 3343: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

3339: p_destination_doc_type => x_destination_doc_type, --
3340: p_multi_org => x_multi_org --
3341: );
3342:
3343: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
3344: l_progress := '080';
3345: IF g_debug_stmt THEN
3346: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document with sysdate:');
3347: PO_DEBUG.debug_var(l_log_head,l_progress,'Total Documents looked at', L_GET_LATEST_DOCS_CSR%ROWCOUNT);

Line 3464: x_return_status := FND_API.G_RET_STS_SUCCESS;

3460: l_progress := '010';
3461: --
3462: --No need to do item validity checks for CTO call
3463: IF p_multi_org = 'Y' THEN
3464: x_return_status := FND_API.G_RET_STS_SUCCESS;
3465: RETURN;
3466: END IF;
3467: --
3468:

Line 3512: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3508: x_item_revision => l_item_revision);
3509: END IF;
3510: --
3511:
3512: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3513: RETURN;
3514: END IF;
3515:
3516: IF l_is_org_valid and l_is_item_valid then

Line 3531: x_return_status := FND_API.G_RET_STS_SUCCESS;

3527: x_vendor_contact_name =>l_vendor_contact_name);
3528: END IF;
3529: END IF; --vendor_site_sourcing_flag check
3530:
3531: x_return_status := FND_API.G_RET_STS_SUCCESS;
3532:
3533: ELSE
3534:
3535: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3535: x_return_status := FND_API.G_RET_STS_ERROR;

3531: x_return_status := FND_API.G_RET_STS_SUCCESS;
3532:
3533: ELSE
3534:
3535: x_return_status := FND_API.G_RET_STS_ERROR;
3536: END IF; --l_valid_flag check
3537:
3538: ELSE
3539: l_progress := '040';

Line 3550: x_return_status := FND_API.G_RET_STS_SUCCESS;

3546: x_vendor_site_id =>x_vendor_site_id,
3547: x_vendor_contact_id =>x_vendor_contact_id,
3548: x_vendor_contact_name =>l_vendor_contact_name);
3549: END IF;
3550: x_return_status := FND_API.G_RET_STS_SUCCESS;
3551: END IF; --GA Check
3552: l_progress := '050';
3553:
3554: END GET_SITE_ID_IF_ITEM_ON_DOC_OK;

Line 5580: x_return_status := FND_API.G_RET_STS_SUCCESS;

5576: n number :=0;
5577: begin
5578: x_msg_data := 'No error';
5579: x_msg_count := 0;
5580: x_return_status := FND_API.G_RET_STS_SUCCESS;
5581: x_vendor_details.DELETE;
5582: open c;
5583: loop
5584: n := n+1;

Line 5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5586: exit when c%notfound;
5587: end loop;
5588: exception
5589: when others then
5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5591: FND_MSG_PUB.Count_And_Get
5592: (p_count => x_msg_count
5593: ,p_data => x_msg_data
5594: );

Line 5640: x_return_status := FND_API.G_RET_STS_SUCCESS;

5636: --
5637: begin
5638: x_msg_data :='No error';
5639: x_msg_count := 0;
5640: x_return_status := FND_API.G_RET_STS_SUCCESS;
5641: x_doc_return := 'Y';
5642: --
5643: l_local_asl_id := x_asl_id;
5644: --

Line 5688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5684:
5685: exception
5686: when others then
5687: x_doc_return := 'N'; -- no rows were obtained from document_sourcing
5688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5689: FND_MSG_PUB.Count_And_Get
5690: (p_count => x_msg_count
5691: ,p_data => x_msg_data
5692: );

Line 5848: -- message list if set to FND_API.G_TRUE.

5844: -- p_deliver_to_loc_id : Deliver to location to determine pricing
5845: -- p_destination_org_id : Destination organizations to determine pricing
5846: -- p_api_version : The value is 1.0
5847: -- p_init_msg_list : Standard API parameter: Initializes FND
5848: -- message list if set to FND_API.G_TRUE.
5849: --
5850: --IN OUT: : None
5851: --
5852: --

Line 5868: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful

5864: -- Document Currency
5865: -- Price Override flag
5866: -- Flag to indicate if price differentials exist
5867: --
5868: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.

Line 5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation

5865: -- Price Override flag
5866: -- Flag to indicate if price differentials exist
5867: --
5868: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case

Line 5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

5866: -- Flag to indicate if price differentials exist
5867: --
5868: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case
5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR

Line 5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR

5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case
5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5875: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5876: --Notes : None
5877: --
5878: --Testing : None

Line 5875: -- or FND_API.G_RET_STS_UNEXP_ERROR.

5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case
5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5875: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5876: --Notes : None
5877: --
5878: --Testing : None
5879: --

Line 6204: x_return_status := FND_API.G_RET_STS_SUCCESS;

6200:
6201: l_progress := '010';
6202:
6203: -- Initialize the return status
6204: x_return_status := FND_API.G_RET_STS_SUCCESS;
6205: -- Bug# 3404477: Return msg count and data
6206: x_msg_count := 0;
6207: x_msg_data := NULL;
6208:

Line 6210: IF FND_API.to_boolean(p_init_msg_list) THEN

6206: x_msg_count := 0;
6207: x_msg_data := NULL;
6208:
6209: -- Bug# 3404477: Follow the API standards
6210: IF FND_API.to_boolean(p_init_msg_list) THEN
6211: -- initialize message list
6212: FND_MSG_PUB.initialize;
6213: END IF;
6214:

Line 6216: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

6212: FND_MSG_PUB.initialize;
6213: END IF;
6214:
6215: -- Check for the API version
6216: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
6217: l_progress := '020';
6218: -- As part of bug# 3404477: No need to proceed if the API is not
6219: -- compatible. Hence, raise exception.
6220: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6220: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6216: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
6217: l_progress := '020';
6218: -- As part of bug# 3404477: No need to proceed if the API is not
6219: -- compatible. Hence, raise exception.
6220: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6222: END IF;
6223:
6224: -- Sql What: Gets the org id and default inv org from FSP

Line 6221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6217: l_progress := '020';
6218: -- As part of bug# 3404477: No need to proceed if the API is not
6219: -- compatible. Hence, raise exception.
6220: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6222: END IF;
6223:
6224: -- Sql What: Gets the org id and default inv org from FSP
6225: -- Sql Why : To determine the current OU and the default FSP org

Line 6260: IF x_return_status <> FND_API.g_ret_sts_success THEN

6256: p_document_type_code => 'REQUISITION',
6257: p_document_subtype => 'PURCHASE',
6258: x_return_contract => l_use_contract,
6259: x_return_status => x_return_status);
6260: IF x_return_status <> FND_API.g_ret_sts_success THEN
6261: RAISE FND_API.g_exc_unexpected_error;
6262: END IF;
6263: --
6264:

Line 6261: RAISE FND_API.g_exc_unexpected_error;

6257: p_document_subtype => 'PURCHASE',
6258: x_return_contract => l_use_contract,
6259: x_return_status => x_return_status);
6260: IF x_return_status <> FND_API.g_ret_sts_success THEN
6261: RAISE FND_API.g_exc_unexpected_error;
6262: END IF;
6263: --
6264:
6265: -- Retrive all the ASL's for the category that is passed in

Line 6623: WHEN FND_API.G_EXC_ERROR THEN

6619: PO_DEBUG.debug_var(l_log_head,l_progress,'x_rate',x_rate);
6620: END IF;
6621: EXCEPTION
6622: -- Bug# 3404477: Return msg count and data
6623: WHEN FND_API.G_EXC_ERROR THEN
6624: x_return_status := FND_API.G_RET_STS_ERROR;
6625: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6626: , p_data => x_msg_data);
6627: WHEN OTHERS THEN

Line 6624: x_return_status := FND_API.G_RET_STS_ERROR;

6620: END IF;
6621: EXCEPTION
6622: -- Bug# 3404477: Return msg count and data
6623: WHEN FND_API.G_EXC_ERROR THEN
6624: x_return_status := FND_API.G_RET_STS_ERROR;
6625: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6626: , p_data => x_msg_data);
6627: WHEN OTHERS THEN
6628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6624: x_return_status := FND_API.G_RET_STS_ERROR;
6625: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6626: , p_data => x_msg_data);
6627: WHEN OTHERS THEN
6628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6629:
6630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6631: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name
6632: , p_procedure_name => l_api_name

Line 6912: -- FND_API.g_ret_sts_success: if the procedure completed successfully

6908: -- x_return_contract:
6909: -- If 'Y', contracts can be returned as source documents; otherwise,
6910: -- do not source to contracts
6911: -- x_return_status:
6912: -- FND_API.g_ret_sts_success: if the procedure completed successfully
6913: -- FND_API.g_ret_sts_unexp_error: if unexpected error occurrred
6914: -- Notes:
6915: -- None
6916: -- Testing:

Line 6913: -- FND_API.g_ret_sts_unexp_error: if unexpected error occurrred

6909: -- If 'Y', contracts can be returned as source documents; otherwise,
6910: -- do not source to contracts
6911: -- x_return_status:
6912: -- FND_API.g_ret_sts_success: if the procedure completed successfully
6913: -- FND_API.g_ret_sts_unexp_error: if unexpected error occurrred
6914: -- Notes:
6915: -- None
6916: -- Testing:
6917: -- None

Line 6942: x_return_status := FND_API.g_ret_sts_success;

6938: x_return_contract := 'N';
6939: return;
6940: END IF;
6941:
6942: x_return_status := FND_API.g_ret_sts_success;
6943: x_return_contract := 'N';
6944:
6945: IF g_debug_stmt THEN
6946: PO_DEBUG.debug_stmt (p_log_head => l_log_head,

Line 6994: x_return_status := FND_API.g_ret_sts_unexp_error;

6990: END IF;
6991:
6992: EXCEPTION
6993: WHEN OTHERS THEN
6994: x_return_status := FND_API.g_ret_sts_unexp_error;
6995: FND_MSG_PUB.add_exc_msg (p_pkg_name => g_pkg_name,
6996: p_procedure_name => 'should_return_contract',
6997: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
6998: IF g_debug_unexp THEN