APPS.AR_INVOICE_UTILS dependencies on GL_PUBLIC_SECTOR

Line 2182: l_message_name := gl_public_sector.get_message_name (

2178: -- ORASHID
2179: -- 21-AUG-2003 (END)
2180:
2181:
2182: l_message_name := gl_public_sector.get_message_name (
2183: p_message_name => 'AR_INVALID_PRIMARY_SALESREP',
2184: p_app_short_name => 'AR');
2185:
2186: INSERT INTO ar_trx_errors_gt (

Line 2203: l_message_name := gl_public_sector.get_message_name (

2199: AND gt.trx_date
2200: BETWEEN rs.start_date_active
2201: AND NVL(rs.end_date_active, gt.trx_date)));
2202:
2203: l_message_name := gl_public_sector.get_message_name (
2204: p_message_name => 'AR_INAPI_SALESREP_REQUIRED',
2205: p_app_short_name => 'AR');
2206:
2207: INSERT INTO ar_trx_errors_gt (

Line 7637: l_message_name := gl_public_sector.get_message_name (

7633: END IF;
7634:
7635: x_return_status := FND_API.G_RET_STS_SUCCESS;
7636:
7637: l_message_name := gl_public_sector.get_message_name (
7638: p_message_name => 'AR_INAPI_INVALID_SALESREP_ID',
7639: p_app_short_name => 'AR');
7640:
7641: -- validate salesrep_id

Line 7660: l_message_name := gl_public_sector.get_message_name (

7656: (SELECT 'X'
7657: FROM RA_SALESREPS REP
7658: WHERE REP.SALESREP_ID = SC.SALESREP_ID);
7659:
7660: l_message_name := gl_public_sector.get_message_name (
7661: p_message_name => 'AR_INAPI_NVALID_SALESREP_NUM',
7662: p_app_short_name => 'AR');
7663:
7664: -- validate salesrep number

Line 7689: l_message_name := gl_public_sector.get_message_name (

7685: FROM RA_SALESREPS REP
7686: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7687: WHERE salesrep_id IS NULL;
7688:
7689: l_message_name := gl_public_sector.get_message_name (
7690: p_message_name => 'AR_INAPI_INVALID_SCR_TYPE_ID',
7691: p_app_short_name => 'AR');
7692:
7693: -- validate sales credit type ID

Line 7712: l_message_name := gl_public_sector.get_message_name (

7708: (SELECT 'X'
7709: FROM SO_SALES_CREDIT_TYPES CR
7710: WHERE CR.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID);
7711:
7712: l_message_name := gl_public_sector.get_message_name (
7713: p_message_name => 'AR_INAPI_INVLD_SCR_TYPE_NAME',
7714: p_app_short_name => 'AR');
7715:
7716: -- validate sales credit type name

Line 7743: l_message_name := gl_public_sector.get_message_name (

7739: FROM SO_SALES_CREDIT_TYPES CR
7740: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME)
7741: WHERE SALES_CREDIT_TYPE_ID IS NULL;
7742:
7743: l_message_name := gl_public_sector.get_message_name (
7744: p_message_name => 'AR_INAPI_SCR_AMT_PERCENT_REQ',
7745: p_app_short_name => 'AR');
7746:
7747: -- validate either amount or percent has been passed by user

Line 7765: l_message_name := gl_public_sector.get_message_name (

7761: AND revenue_percent_split IS NULL
7762: AND cr.quota_flag = 'Y'; --Bug8202014
7763:
7764:
7765: l_message_name := gl_public_sector.get_message_name (
7766: p_message_name => 'AR_INAPI_INVALID_SCR',
7767: p_app_short_name => 'AR');
7768:
7769: /*--------------------------------------------------------------+

Line 8032: l_message_name := gl_public_sector.get_message_name (

8028: /*------------------------------------------------------------+
8029: | Identify null or invalid sales credit percent split |
8030: +------------------------------------------------------------*/
8031:
8032: l_message_name := gl_public_sector.get_message_name (
8033: p_message_name => 'AR_INAPI_INVALID_PERCENT_SPLIT',
8034: p_app_short_name => 'AR');
8035:
8036: INSERT INTO ar_trx_errors_gt

Line 8082: l_message_name := gl_public_sector.get_message_name (

8078: 'N', 0,
8079: NULL, 0
8080: ) ) <> 100;
8081:
8082: l_message_name := gl_public_sector.get_message_name (
8083: p_message_name => 'AR_INAPI_SUM_NOT_EQUAL_LINE',
8084: p_app_short_name => 'AR');
8085:
8086: -- identify un-foot sales credit for amount

Line 8125: l_message_name := gl_public_sector.get_message_name (

8121: --
8122:
8123: IF (p_trx_system_param_rec.salesrep_required_flag = 'Y') THEN
8124:
8125: l_message_name := gl_public_sector.get_message_name (
8126: p_message_name => 'AR_INAPI_ONE_SALESCREDIT_ROW',
8127: p_app_short_name => 'AR');
8128:
8129: INSERT INTO ar_trx_errors_gt