DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on FND_MESSAGE

Line 770: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

766: ELSE
767: RETURN trunc(sysdate);
768: END IF;
769: ELSE
770: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
771: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
772: FND_MSG_PUB.Add;
773: app_exception.raise_exception;
774: END IF;

Line 771: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);

767: RETURN trunc(sysdate);
768: END IF;
769: ELSE
770: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
771: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
772: FND_MSG_PUB.Add;
773: app_exception.raise_exception;
774: END IF;
775: IF PG_DEBUG in ('Y', 'C') THEN

Line 1459: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTFOUND');

1455:
1456: EXCEPTION
1457: WHEN EventNotFound THEN
1458:
1459: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTFOUND');
1460: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
1461: FND_MSG_PUB.Add;
1462: app_exception.raise_exception;
1463:

Line 1460: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );

1456: EXCEPTION
1457: WHEN EventNotFound THEN
1458:
1459: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTFOUND');
1460: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
1461: FND_MSG_PUB.Add;
1462: app_exception.raise_exception;
1463:
1464: WHEN EventNotARCC THEN

Line 1465: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTAR');

1461: FND_MSG_PUB.Add;
1462: app_exception.raise_exception;
1463:
1464: WHEN EventNotARCC THEN
1465: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTAR');
1466: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
1467: FND_MSG_PUB.Add;
1468: app_exception.raise_exception;
1469:

Line 1466: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );

1462: app_exception.raise_exception;
1463:
1464: WHEN EventNotARCC THEN
1465: FND_MESSAGE.SET_NAME( 'AR', 'AR_EVENTNOTAR');
1466: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
1467: FND_MSG_PUB.Add;
1468: app_exception.raise_exception;
1469:
1470: WHEN NO_DATA_FOUND THEN

Line 1472: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );

1468: app_exception.raise_exception;
1469:
1470: WHEN NO_DATA_FOUND THEN
1471: ROLLBACK TO ar_cccorrection_raise_event;
1472: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1473: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1474: FND_MSG_PUB.Add;
1475: app_exception.raise_exception;
1476:

Line 1473: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

1469:
1470: WHEN NO_DATA_FOUND THEN
1471: ROLLBACK TO ar_cccorrection_raise_event;
1472: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1473: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1474: FND_MSG_PUB.Add;
1475: app_exception.raise_exception;
1476:
1477: WHEN OTHERS THEN

Line 1479: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );

1475: app_exception.raise_exception;
1476:
1477: WHEN OTHERS THEN
1478: ROLLBACK TO ar_cccorrection_raise_event;
1479: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1480: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1481: FND_MSG_PUB.Add;
1482: app_exception.raise_exception;
1483: END raise_event;

Line 1480: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

1476:
1477: WHEN OTHERS THEN
1478: ROLLBACK TO ar_cccorrection_raise_event;
1479: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1480: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1481: FND_MSG_PUB.Add;
1482: app_exception.raise_exception;
1483: END raise_event;
1484:

Line 1605: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_CHANGED');

1601: END IF;
1602: EXCEPTION
1603: WHEN NO_DATA_FOUND THEN
1604: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1605: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_CHANGED');
1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1607: FND_MSG_PUB.Add;
1608: ELSE
1609: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_CHANGED');

Line 1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

1602: EXCEPTION
1603: WHEN NO_DATA_FOUND THEN
1604: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1605: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_CHANGED');
1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1607: FND_MSG_PUB.Add;
1608: ELSE
1609: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_CHANGED');
1610: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

Line 1609: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_CHANGED');

1605: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_CHANGED');
1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1607: FND_MSG_PUB.Add;
1608: ELSE
1609: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_CHANGED');
1610: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1611: FND_MSG_PUB.Add;
1612: END IF;
1613: IF PG_DEBUG in ('Y', 'C') THEN

Line 1610: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1607: FND_MSG_PUB.Add;
1608: ELSE
1609: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_CHANGED');
1610: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1611: FND_MSG_PUB.Add;
1612: END IF;
1613: IF PG_DEBUG in ('Y', 'C') THEN
1614: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');

Line 1619: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_LOCKED');

1615: END IF;
1616: app_exception.raise_exception;
1617: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1618: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1619: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_LOCKED');
1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1621: FND_MSG_PUB.Add;
1622: ELSE
1623: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_LOCKED');

Line 1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

1616: app_exception.raise_exception;
1617: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1618: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1619: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_LOCKED');
1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1621: FND_MSG_PUB.Add;
1622: ELSE
1623: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_LOCKED');
1624: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

Line 1623: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_LOCKED');

1619: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_LOCKED');
1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1621: FND_MSG_PUB.Add;
1622: ELSE
1623: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_LOCKED');
1624: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1625: FND_MSG_PUB.Add;
1626: END IF;
1627: IF PG_DEBUG in ('Y', 'C') THEN

Line 1624: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);

1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1621: FND_MSG_PUB.Add;
1622: ELSE
1623: FND_MESSAGE.SET_NAME('AR','AR_TRANSACTION_RECORD_LOCKED');
1624: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1625: FND_MSG_PUB.Add;
1626: END IF;
1627: IF PG_DEBUG in ('Y', 'C') THEN
1628: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');

Line 2558: errbuf := fnd_message.get||' X '||SQLERRM;

2554: END IF;
2555: IF lock_trx%ISOPEN THEN
2556: CLOSE lock_trx;
2557: END IF;
2558: errbuf := fnd_message.get||' X '||SQLERRM;
2559: retcode := 2;
2560: END cc_auto_correct;
2561:
2562: