DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_MESSAGE_S

Line 1892: po_message_s.sql_error('val_receiving_controls', x_progress, sqlcode);

1888:
1889:
1890: EXCEPTION
1891: WHEN OTHERS THEN
1892: po_message_s.sql_error('val_receiving_controls', x_progress, sqlcode);
1893: RAISE;
1894:
1895: END val_rcv_controls_for_date;
1896:

Line 2067: po_message_s.sql_error('validate_ccid', 1, sqlcode);

2063: return result;
2064:
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: po_message_s.sql_error('validate_ccid', 1, sqlcode);
2068: RAISE;
2069:
2070: END validate_ccid;
2071:

Line 2113: po_message_s.sql_error('validate_segs', 1, sqlcode);

2109: return result;
2110:
2111: Exception
2112: WHEN OTHERS THEN
2113: po_message_s.sql_error('validate_segs', 1, sqlcode);
2114: RAISE;
2115: END validate_segs;
2116:
2117:

Line 2312: po_message_s.sql_error('get_item_cost', 1, sqlcode);

2308: return round(x_unit_price,10);
2309:
2310: Exception
2311: WHEN OTHERS THEN
2312: po_message_s.sql_error('get_item_cost', 1, sqlcode);
2313: RAISE;
2314:
2315: end get_item_cost;
2316:

Line 2377: po_message_s.sql_error('validate_open_period', 1, sqlcode);

2373: return result;
2374:
2375: Exception
2376: WHEN OTHERS THEN
2377: po_message_s.sql_error('validate_open_period', 1, sqlcode);
2378: RAISE;
2379: END validate_open_period;
2380:
2381: PROCEDURE withdraw_req (p_headerId IN NUMBER) IS

Line 3650: po_message_s.sql_error('is_req_encumbered', 1, sqlcode);

3646: end if;
3647:
3648: EXCEPTION
3649: WHEN OTHERS THEN
3650: po_message_s.sql_error('is_req_encumbered', 1, sqlcode);
3651: RAISE;
3652:
3653: END is_req_encumbered;
3654:

Line 4391: po_message_s.sql_error('VALIDATE_JOB_RELEASED_DATE', 1, sqlcode);

4387: return result;
4388:
4389: Exception
4390: WHEN OTHERS THEN
4391: po_message_s.sql_error('VALIDATE_JOB_RELEASED_DATE', 1, sqlcode);
4392: RAISE;
4393: END VALIDATE_JOB_RELEASED_DATE;
4394:
4395: -- 13896563 changes ends

Line 4439: po_message_s.sql_error('get_job_released_date', 1, sqlcode);

4435: return X_JOB_RELEASED_DATE;
4436:
4437: Exception
4438: WHEN OTHERS THEN
4439: po_message_s.sql_error('get_job_released_date', 1, sqlcode);
4440: RAISE;
4441: END GET_JOB_RELEASED_DATE;
4442: -- 14191762 changes ends
4443:

Line 4497: po_message_s.sql_error('val_po_dist_pjt', 1, sqlcode);

4493: return result;
4494:
4495: Exception
4496: WHEN OTHERS THEN
4497: po_message_s.sql_error('val_po_dist_pjt', 1, sqlcode);
4498: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4499: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);
4500: END IF;
4501: RAISE;

Line 4551: po_message_s.sql_error('get_po_dist_project', 1, sqlcode);

4547: return x_pjt_name;
4548:
4549: Exception
4550: WHEN OTHERS THEN
4551: po_message_s.sql_error('get_po_dist_project', 1, sqlcode);
4552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4553: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4554: END IF;
4555: RAISE;

Line 4603: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);

4599: WHERE project_id =x_pjt_id_dummy);
4600: EXCEPTION
4601: WHEN OTHERS THEN
4602: x_progress := '001';
4603: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4605: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4606: END IF;
4607: RAISE;

Line 4622: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);

4618: return result;
4619:
4620: Exception
4621: WHEN OTHERS THEN
4622: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4623: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4624: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4625: END IF;
4626: RAISE;

Line 4703: po_message_s.sql_error('get_req_line_invalid_pjts', 1, sqlcode);

4699:
4700: EXCEPTION
4701:
4702: WHEN OTHERS THEN
4703: po_message_s.sql_error('get_req_line_invalid_pjts', 1, sqlcode);
4704: --Close the cursor
4705: IF (C_Proj%ISOPEN) THEN
4706: CLOSE C_Proj;
4707: END IF;

Line 5836: po_message_s.sql_error('VALIDATE_CLM_REQ_ACRN', 1, sqlcode);

5832: return 1;
5833:
5834: EXCEPTION
5835: WHEN OTHERS THEN
5836: po_message_s.sql_error('VALIDATE_CLM_REQ_ACRN', 1, sqlcode);
5837: RAISE;
5838:
5839: END validate_clm_req_acrn;
5840: