DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on STANDARD

Line 1711: ** standard receipt or inspection required

1707: transaction_ok := 0;
1708:
1709: /*
1710: ** You can only do express receipt if routing is set to
1711: ** standard receipt or inspection required
1712: */
1713: ELSIF (X_transaction_type = 'RECEIVE' AND
1714: X_auto_transact_code = 'RECEIVE' AND
1715: (X_routing_header_id IN (1, 2, 0))) THEN

Line 1717: ** standard receipt is allowed

1713: ELSIF (X_transaction_type = 'RECEIVE' AND
1714: X_auto_transact_code = 'RECEIVE' AND
1715: (X_routing_header_id IN (1, 2, 0))) THEN
1716: /*
1717: ** standard receipt is allowed
1718: */
1719: transaction_ok := 0;
1720:
1721: ELSE

Line 3177: -- Standard check of p_commit.

3173: l_progress := '060';
3174:
3175:
3176: --Commit the transaction
3177: -- Standard check of p_commit.
3178: IF FND_API.To_Boolean( p_commit ) THEN
3179: l_progress := '070';
3180: COMMIT;
3181: END IF;

Line 3201: -- API Name : update_attachment_to_standard

3197: ROLLBACK;
3198:
3199: END create_info_template;
3200:
3201: -- API Name : update_attachment_to_standard
3202: -- Type : Public
3203: -- Pre-reqs : None
3204: -- Function : Updates the attachments associated with the requisition to standard attachment
3205: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id

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

3200:
3201: -- API Name : update_attachment_to_standard
3202: -- Type : Public
3203: -- Pre-reqs : None
3204: -- Function : Updates the attachments associated with the requisition to standard attachment
3205: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3206:
3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3208: l_progress VARCHAR2(4) := '000';

Line 3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS

3203: -- Pre-reqs : None
3204: -- Function : Updates the attachments associated with the requisition to standard attachment
3205: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3206:
3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3208: l_progress VARCHAR2(4) := '000';
3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3210: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3211:

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

3206:
3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3208: l_progress VARCHAR2(4) := '000';
3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3210: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3211:
3212: BEGIN
3213: l_progress := '010';
3214: -- update the usage_type flag in fnd_documents;

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

3225:
3226: EXCEPTION
3227: WHEN OTHERS THEN
3228: RAISE_APPLICATION_ERROR(-20000,
3229: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'
3230: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);
3231:
3232: END update_attachment_to_standard;
3233:

Line 3232: END update_attachment_to_standard;

3228: RAISE_APPLICATION_ERROR(-20000,
3229: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'
3230: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);
3231:
3232: END update_attachment_to_standard;
3233:
3234: END POR_UTIL_PKG;