APPS.AR_INVOICE_UTILS dependencies on GL_PUBLIC_SECTOR

Line 2105: l_message_name := gl_public_sector.get_message_name (

2101: -- ORASHID
2102: -- 21-AUG-2003 (END)
2103:
2104:
2105: l_message_name := gl_public_sector.get_message_name (
2106: p_message_name => 'AR_INVALID_PRIMARY_SALESREP',
2107: p_app_short_name => 'AR');
2108:
2109: INSERT INTO ar_trx_errors_gt (

Line 2126: l_message_name := gl_public_sector.get_message_name (

2122: AND gt.trx_date
2123: BETWEEN rs.start_date_active
2124: AND NVL(rs.end_date_active, sysdate)));
2125:
2126: l_message_name := gl_public_sector.get_message_name (
2127: p_message_name => 'AR_INAPI_SALESREP_REQUIRED',
2128: p_app_short_name => 'AR');
2129:
2130: INSERT INTO ar_trx_errors_gt (

Line 7298: l_message_name := gl_public_sector.get_message_name (

7294: END IF;
7295:
7296: x_return_status := FND_API.G_RET_STS_SUCCESS;
7297:
7298: l_message_name := gl_public_sector.get_message_name (
7299: p_message_name => 'AR_INAPI_INVALID_SALESREP_ID',
7300: p_app_short_name => 'AR');
7301:
7302: -- validate salesrep_id

Line 7321: l_message_name := gl_public_sector.get_message_name (

7317: (SELECT 'X'
7318: FROM RA_SALESREPS REP
7319: WHERE REP.SALESREP_ID = SC.SALESREP_ID);
7320:
7321: l_message_name := gl_public_sector.get_message_name (
7322: p_message_name => 'AR_INAPI_NVALID_SALESREP_NUM',
7323: p_app_short_name => 'AR');
7324:
7325: -- validate salesrep number

Line 7350: l_message_name := gl_public_sector.get_message_name (

7346: FROM RA_SALESREPS REP
7347: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7348: WHERE salesrep_id IS NULL;
7349:
7350: l_message_name := gl_public_sector.get_message_name (
7351: p_message_name => 'AR_INAPI_INVALID_SCR_TYPE_ID',
7352: p_app_short_name => 'AR');
7353:
7354: -- validate sales credit type ID

Line 7373: l_message_name := gl_public_sector.get_message_name (

7369: (SELECT 'X'
7370: FROM SO_SALES_CREDIT_TYPES CR
7371: WHERE CR.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID);
7372:
7373: l_message_name := gl_public_sector.get_message_name (
7374: p_message_name => 'AR_INAPI_INVLD_SCR_TYPE_NAME',
7375: p_app_short_name => 'AR');
7376:
7377: -- validate sales credit type name

Line 7404: l_message_name := gl_public_sector.get_message_name (

7400: FROM SO_SALES_CREDIT_TYPES CR
7401: WHERE CR.NAME = SC.SALES_CREDIT_TYPE_NAME)
7402: WHERE SALES_CREDIT_TYPE_ID IS NULL;
7403:
7404: l_message_name := gl_public_sector.get_message_name (
7405: p_message_name => 'AR_INAPI_SCR_AMT_PERCENT_REQ',
7406: p_app_short_name => 'AR');
7407:
7408: -- validate either amount or percent has been passed by user

Line 7423: l_message_name := gl_public_sector.get_message_name (

7419: WHERE revenue_amount_split IS NULL
7420: AND revenue_percent_split IS NULL;
7421:
7422:
7423: l_message_name := gl_public_sector.get_message_name (
7424: p_message_name => 'AR_INAPI_INVALID_SCR',
7425: p_app_short_name => 'AR');
7426:
7427: /*--------------------------------------------------------------+

Line 7592: l_message_name := gl_public_sector.get_message_name (

7588: /*------------------------------------------------------------+
7589: | Identify null or invalid sales credit percent split |
7590: +------------------------------------------------------------*/
7591:
7592: l_message_name := gl_public_sector.get_message_name (
7593: p_message_name => 'AR_INAPI_INVALID_PERCENT_SPLIT',
7594: p_app_short_name => 'AR');
7595:
7596: INSERT INTO ar_trx_errors_gt

Line 7640: l_message_name := gl_public_sector.get_message_name (

7636: 'N', 0,
7637: NULL, 0
7638: ) ) <> 100;
7639:
7640: l_message_name := gl_public_sector.get_message_name (
7641: p_message_name => 'AR_INAPI_SUM_NOT_EQUAL_LINE',
7642: p_app_short_name => 'AR');
7643:
7644: -- identify un-foot sales credit for amount

Line 7683: l_message_name := gl_public_sector.get_message_name (

7679: --
7680:
7681: IF (p_trx_system_param_rec.salesrep_required_flag = 'Y') THEN
7682:
7683: l_message_name := gl_public_sector.get_message_name (
7684: p_message_name => 'AR_INAPI_ONE_SALESCREDIT_ROW',
7685: p_app_short_name => 'AR');
7686:
7687: INSERT INTO ar_trx_errors_gt