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 1221: IF l_return_status <> FND_API.g_ret_sts_success THEN

1217: p_document_subtype => 'PURCHASE',
1218: x_return_contract => l_return_contract,
1219: x_return_status => l_return_status
1220: );
1221: IF l_return_status <> FND_API.g_ret_sts_success THEN
1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224: END IF;
1225:

Line 1222: RAISE FND_API.g_exc_unexpected_error;

1218: x_return_contract => l_return_contract,
1219: x_return_status => l_return_status
1220: );
1221: IF l_return_status <> FND_API.g_ret_sts_success THEN
1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224: END IF;
1225:
1226: IF g_debug_stmt THEN

Line 2025: p_init_msg_list => FND_API.G_TRUE,

2021: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
2022: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
2023:
2024: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
2025: p_init_msg_list => FND_API.G_TRUE,
2026: x_return_status => l_return_status,
2027: x_msg_count => l_msg_count,
2028: x_msg_data => l_msg_data,
2029: p_doc_style_id => null,

Line 2037: if l_return_status <> FND_API.g_ret_sts_success THEN

2033: p_destination_type => p_destination_type,
2034: p_source => 'REQUISITION'
2035: );
2036:
2037: if l_return_status <> FND_API.g_ret_sts_success THEN
2038: l_eligible_doc_flag := FALSE;
2039: IF g_debug_stmt THEN
2040: PO_DEBUG.debug_stmt(l_log_head,l_progress,'style validation failed');
2041: END IF;

Line 2104: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

2100: p_destination_doc_type => x_destination_doc_type, --
2101: p_multi_org => x_multi_org --
2102: );
2103:
2104: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
2105: l_progress := '070';
2106: IF g_debug_stmt THEN
2107: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document from ASL:');
2108: PO_DEBUG.debug_var(l_log_head,l_progress,'Total DOcuments looked at', L_GET_DOCS_ON_ASL_CSR%ROWCOUNT);

Line 2222: p_init_msg_list => FND_API.G_TRUE,

2218: END IF;
2219: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
2220: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
2221: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
2222: p_init_msg_list => FND_API.G_TRUE,
2223: x_return_status => l_return_status,
2224: x_msg_count => l_msg_count,
2225: x_msg_data => l_msg_data,
2226: p_doc_style_id => null,

Line 2234: if l_return_status <> FND_API.g_ret_sts_success THEN

2230: p_destination_type => p_destination_type,
2231: p_source => 'REQUISITION'
2232: );
2233:
2234: if l_return_status <> FND_API.g_ret_sts_success THEN
2235: l_eligible_doc_flag := FALSE;
2236: IF g_debug_stmt THEN
2237: PO_DEBUG.debug_stmt(l_log_head,l_progress,'style validation failed');
2238: END IF;

Line 2300: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

2296: p_destination_doc_type => x_destination_doc_type, --
2297: p_multi_org => x_multi_org --
2298: );
2299:
2300: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
2301: l_progress := '090';
2302: IF g_debug_stmt THEN
2303: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document from ASL with sysdate:');
2304: PO_DEBUG.debug_var(l_log_head,l_progress,'Total DOcuments looked at', L_GET_DOCS_ON_ASL_CSR%ROWCOUNT);

Line 3107: p_init_msg_list => FND_API.G_TRUE,

3103: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
3104: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
3105:
3106: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3107: p_init_msg_list => FND_API.G_TRUE,
3108: x_return_status => l_return_status,
3109: x_msg_count => l_msg_count,
3110: x_msg_data => l_msg_data,
3111: p_doc_style_id => null,

Line 3119: if l_return_status <> FND_API.g_ret_sts_success THEN

3115: p_destination_type => p_destination_type,
3116: p_source => 'REQUISITION'
3117: );
3118:
3119: if l_return_status <> FND_API.g_ret_sts_success THEN
3120: l_eligible_doc_flag := FALSE;
3121: end if;
3122: end if;
3123:

Line 3152: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

3148: p_destination_doc_type => x_destination_doc_type, --
3149: p_multi_org => x_multi_org --
3150: );
3151:
3152: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
3153: l_progress := '040';
3154: IF g_debug_stmt THEN
3155: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document:');
3156: PO_DEBUG.debug_var(l_log_head,l_progress,'Total Documents looked at', L_GET_LATEST_DOCS_CSR%ROWCOUNT);

Line 3273: p_init_msg_list => FND_API.G_TRUE,

3269:
3270: if x_destination_doc_type IN ('REQ','REQ_NONCATALOG') then
3271: if (x_document_type_code IN ('BLANKET', 'CONTRACT')) then
3272: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3273: p_init_msg_list => FND_API.G_TRUE,
3274: x_return_status => l_return_status,
3275: x_msg_count => l_msg_count,
3276: x_msg_data => l_msg_data,
3277: p_doc_style_id => null,

Line 3285: if l_return_status <> FND_API.g_ret_sts_success THEN

3281: p_destination_type => p_destination_type,
3282: p_source => 'REQUISITION'
3283: );
3284:
3285: if l_return_status <> FND_API.g_ret_sts_success THEN
3286: l_eligible_doc_flag := FALSE;
3287: end if;
3288:
3289: end if;

Line 3318: IF x_return_status = FND_API.G_RET_STS_SUCCESS then

3314: p_destination_doc_type => x_destination_doc_type, --
3315: p_multi_org => x_multi_org --
3316: );
3317:
3318: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
3319: l_progress := '080';
3320: IF g_debug_stmt THEN
3321: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Found a document with sysdate:');
3322: PO_DEBUG.debug_var(l_log_head,l_progress,'Total Documents looked at', L_GET_LATEST_DOCS_CSR%ROWCOUNT);

Line 3438: x_return_status := FND_API.G_RET_STS_SUCCESS;

3434: l_progress := '010';
3435: --
3436: --No need to do item validity checks for CTO call
3437: IF p_multi_org = 'Y' THEN
3438: x_return_status := FND_API.G_RET_STS_SUCCESS;
3439: RETURN;
3440: END IF;
3441: --
3442:

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

3482: x_item_revision => l_item_revision);
3483: END IF;
3484: --
3485:
3486: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3487: RETURN;
3488: END IF;
3489:
3490: IF l_is_org_valid and l_is_item_valid then

Line 3505: x_return_status := FND_API.G_RET_STS_SUCCESS;

3501: x_vendor_contact_name =>x_vendor_contact_name);
3502: END IF;
3503: END IF; --vendor_site_sourcing_flag check
3504:
3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506:
3507: ELSE
3508:
3509: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3509: x_return_status := FND_API.G_RET_STS_ERROR;

3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506:
3507: ELSE
3508:
3509: x_return_status := FND_API.G_RET_STS_ERROR;
3510: END IF; --l_valid_flag check
3511:
3512: ELSE
3513: l_progress := '040';

Line 3524: x_return_status := FND_API.G_RET_STS_SUCCESS;

3520: x_vendor_site_id =>x_vendor_site_id,
3521: x_vendor_contact_id =>x_vendor_contact_id,
3522: x_vendor_contact_name =>x_vendor_contact_name);
3523: END IF;
3524: x_return_status := FND_API.G_RET_STS_SUCCESS;
3525: END IF; --GA Check
3526: l_progress := '050';
3527:
3528: END GET_SITE_ID_IF_ITEM_ON_DOC_OK;

Line 5503: x_return_status := FND_API.G_RET_STS_SUCCESS;

5499: n number :=0;
5500: begin
5501: x_msg_data := 'No error';
5502: x_msg_count := 0;
5503: x_return_status := FND_API.G_RET_STS_SUCCESS;
5504: x_vendor_details.DELETE;
5505: open c;
5506: loop
5507: n := n+1;

Line 5513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5509: exit when c%notfound;
5510: end loop;
5511: exception
5512: when others then
5513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5514: FND_MSG_PUB.Count_And_Get
5515: (p_count => x_msg_count
5516: ,p_data => x_msg_data
5517: );

Line 5563: x_return_status := FND_API.G_RET_STS_SUCCESS;

5559: --
5560: begin
5561: x_msg_data :='No error';
5562: x_msg_count := 0;
5563: x_return_status := FND_API.G_RET_STS_SUCCESS;
5564: x_doc_return := 'Y';
5565: --
5566: l_local_asl_id := x_asl_id;
5567: --

Line 5611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5607:
5608: exception
5609: when others then
5610: x_doc_return := 'N'; -- no rows were obtained from document_sourcing
5611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5612: FND_MSG_PUB.Count_And_Get
5613: (p_count => x_msg_count
5614: ,p_data => x_msg_data
5615: );

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

5767: -- p_deliver_to_loc_id : Deliver to location to determine pricing
5768: -- p_destination_org_id : Destination organizations to determine pricing
5769: -- p_api_version : The value is 1.0
5770: -- p_init_msg_list : Standard API parameter: Initializes FND
5771: -- message list if set to FND_API.G_TRUE.
5772: --
5773: --IN OUT: : None
5774: --
5775: --

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

5787: -- Document Currency
5788: -- Price Override flag
5789: -- Flag to indicate if price differentials exist
5790: --
5791: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5792: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.

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

5788: -- Price Override flag
5789: -- Flag to indicate if price differentials exist
5790: --
5791: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5792: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case

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

5789: -- Flag to indicate if price differentials exist
5790: --
5791: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5792: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case
5797: -- x_return_status is returned as FND_API.G_RET_STS_ERROR

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

5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case
5797: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5798: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5799: --Notes : None
5800: --
5801: --Testing : None

Line 5798: -- or FND_API.G_RET_STS_UNEXP_ERROR.

5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case
5797: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5798: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5799: --Notes : None
5800: --
5801: --Testing : None
5802: --

Line 6127: x_return_status := FND_API.G_RET_STS_SUCCESS;

6123:
6124: l_progress := '010';
6125:
6126: -- Initialize the return status
6127: x_return_status := FND_API.G_RET_STS_SUCCESS;
6128: -- Bug# 3404477: Return msg count and data
6129: x_msg_count := 0;
6130: x_msg_data := NULL;
6131:

Line 6133: IF FND_API.to_boolean(p_init_msg_list) THEN

6129: x_msg_count := 0;
6130: x_msg_data := NULL;
6131:
6132: -- Bug# 3404477: Follow the API standards
6133: IF FND_API.to_boolean(p_init_msg_list) THEN
6134: -- initialize message list
6135: FND_MSG_PUB.initialize;
6136: END IF;
6137:

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

6135: FND_MSG_PUB.initialize;
6136: END IF;
6137:
6138: -- Check for the API version
6139: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
6140: l_progress := '020';
6141: -- As part of bug# 3404477: No need to proceed if the API is not
6142: -- compatible. Hence, raise exception.
6143: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6139: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
6140: l_progress := '020';
6141: -- As part of bug# 3404477: No need to proceed if the API is not
6142: -- compatible. Hence, raise exception.
6143: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END IF;
6146:
6147: -- Sql What: Gets the org id and default inv org from FSP

Line 6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6140: l_progress := '020';
6141: -- As part of bug# 3404477: No need to proceed if the API is not
6142: -- compatible. Hence, raise exception.
6143: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END IF;
6146:
6147: -- Sql What: Gets the org id and default inv org from FSP
6148: -- Sql Why : To determine the current OU and the default FSP org

Line 6183: IF x_return_status <> FND_API.g_ret_sts_success THEN

6179: p_document_type_code => 'REQUISITION',
6180: p_document_subtype => 'PURCHASE',
6181: x_return_contract => l_use_contract,
6182: x_return_status => x_return_status);
6183: IF x_return_status <> FND_API.g_ret_sts_success THEN
6184: RAISE FND_API.g_exc_unexpected_error;
6185: END IF;
6186: --
6187:

Line 6184: RAISE FND_API.g_exc_unexpected_error;

6180: p_document_subtype => 'PURCHASE',
6181: x_return_contract => l_use_contract,
6182: x_return_status => x_return_status);
6183: IF x_return_status <> FND_API.g_ret_sts_success THEN
6184: RAISE FND_API.g_exc_unexpected_error;
6185: END IF;
6186: --
6187:
6188: -- Retrive all the ASL's for the category that is passed in

Line 6546: WHEN FND_API.G_EXC_ERROR THEN

6542: PO_DEBUG.debug_var(l_log_head,l_progress,'x_rate',x_rate);
6543: END IF;
6544: EXCEPTION
6545: -- Bug# 3404477: Return msg count and data
6546: WHEN FND_API.G_EXC_ERROR THEN
6547: x_return_status := FND_API.G_RET_STS_ERROR;
6548: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6549: , p_data => x_msg_data);
6550: WHEN OTHERS THEN

Line 6547: x_return_status := FND_API.G_RET_STS_ERROR;

6543: END IF;
6544: EXCEPTION
6545: -- Bug# 3404477: Return msg count and data
6546: WHEN FND_API.G_EXC_ERROR THEN
6547: x_return_status := FND_API.G_RET_STS_ERROR;
6548: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6549: , p_data => x_msg_data);
6550: WHEN OTHERS THEN
6551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6547: x_return_status := FND_API.G_RET_STS_ERROR;
6548: FND_MSG_PUB.count_and_get(p_count => x_msg_count
6549: , p_data => x_msg_data);
6550: WHEN OTHERS THEN
6551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6552:
6553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6554: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name
6555: , p_procedure_name => l_api_name

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

6831: -- x_return_contract:
6832: -- If 'Y', contracts can be returned as source documents; otherwise,
6833: -- do not source to contracts
6834: -- x_return_status:
6835: -- FND_API.g_ret_sts_success: if the procedure completed successfully
6836: -- FND_API.g_ret_sts_unexp_error: if unexpected error occurrred
6837: -- Notes:
6838: -- None
6839: -- Testing:

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

6832: -- If 'Y', contracts can be returned as source documents; otherwise,
6833: -- do not source to contracts
6834: -- x_return_status:
6835: -- FND_API.g_ret_sts_success: if the procedure completed successfully
6836: -- FND_API.g_ret_sts_unexp_error: if unexpected error occurrred
6837: -- Notes:
6838: -- None
6839: -- Testing:
6840: -- None

Line 6865: x_return_status := FND_API.g_ret_sts_success;

6861: x_return_contract := 'N';
6862: return;
6863: END IF;
6864:
6865: x_return_status := FND_API.g_ret_sts_success;
6866: x_return_contract := 'N';
6867:
6868: IF g_debug_stmt THEN
6869: PO_DEBUG.debug_stmt (p_log_head => l_log_head,

Line 6909: x_return_status := FND_API.g_ret_sts_unexp_error;

6905: END IF;
6906:
6907: EXCEPTION
6908: WHEN OTHERS THEN
6909: x_return_status := FND_API.g_ret_sts_unexp_error;
6910: FND_MSG_PUB.add_exc_msg (p_pkg_name => g_pkg_name,
6911: p_procedure_name => 'should_return_contract',
6912: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
6913: IF g_debug_unexp THEN