DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on STANDARD

Line 1859: ** standard receipt or inspection required

1855: transaction_ok := 0;
1856:
1857: /*
1858: ** You can only do express receipt if routing is set to
1859: ** standard receipt or inspection required
1860: */
1861: ELSIF (X_transaction_type = 'RECEIVE' AND
1862: X_auto_transact_code = 'RECEIVE' AND
1863: (X_routing_header_id IN (1, 2, 0))) THEN

Line 1865: ** standard receipt is allowed

1861: ELSIF (X_transaction_type = 'RECEIVE' AND
1862: X_auto_transact_code = 'RECEIVE' AND
1863: (X_routing_header_id IN (1, 2, 0))) THEN
1864: /*
1865: ** standard receipt is allowed
1866: */
1867: transaction_ok := 0;
1868:
1869: ELSE

Line 3546: -- Standard check of p_commit.

3542: l_progress := '060';
3543:
3544:
3545: --Commit the transaction
3546: -- Standard check of p_commit.
3547: IF FND_API.To_Boolean( p_commit ) THEN
3548: l_progress := '070';
3549: COMMIT;
3550: END IF;

Line 3570: -- API Name : update_attachment_to_standard

3566: ROLLBACK;
3567:
3568: END create_info_template;
3569:
3570: -- API Name : update_attachment_to_standard
3571: -- Type : Public
3572: -- Pre-reqs : None
3573: -- Function : Updates the attachments associated with the requisition to standard attachment
3574: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id

Line 3573: -- Function : Updates the attachments associated with the requisition to standard attachment

3569:
3570: -- API Name : update_attachment_to_standard
3571: -- Type : Public
3572: -- Pre-reqs : None
3573: -- Function : Updates the attachments associated with the requisition to standard attachment
3574: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3575:
3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';

Line 3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS

3572: -- Pre-reqs : None
3573: -- Function : Updates the attachments associated with the requisition to standard attachment
3574: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3575:
3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';

Line 3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';

3575:
3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';
3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;
3583: CURSOR l_fnd_document_id_csr IS

Line 3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';

3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';
3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;
3583: CURSOR l_fnd_document_id_csr IS
3584: SELECT document_id

Line 3620: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'

3616: l_log_msg := 'Exception raised. l_progress => '||l_progress;
3617: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3618: END IF;
3619: RAISE_APPLICATION_ERROR(-20000,
3620: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'
3621: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);
3622: END update_attachment_to_standard;
3623:
3624:

Line 3622: END update_attachment_to_standard;

3618: END IF;
3619: RAISE_APPLICATION_ERROR(-20000,
3620: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'
3621: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);
3622: END update_attachment_to_standard;
3623:
3624:
3625:
3626: