eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CUST_PROF_CLASS_AMT_PKG dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 243: FND_MESSAGE.SET_TOKEN('FK', 'hz_cust_prof_class_amts');

239: FETCH curr INTO l_code;
240: IF curr%NOTFOUND THEN
241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
243: FND_MESSAGE.SET_TOKEN('FK', 'hz_cust_prof_class_amts');
244: FND_MESSAGE.SET_TOKEN('COLUMN', 'CURRENCY_CODE');
245: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');
246: FND_MSG_PUB.ADD;
247: x_return_status := FND_API.G_RET_STS_ERROR;

Line 415: SELECT hz_cust_prof_class_amts_s.nextval

411: x_msg_count OUT NOCOPY NUMBER,
412: x_msg_data OUT NOCOPY VARCHAR2)
413: IS
414: CURSOR cseq IS
415: SELECT hz_cust_prof_class_amts_s.nextval
416: from dual;
417: l_cust_prof_class_amt_id NUMBER;
418: BEGIN
419: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row +');

Line 457: arp_standard.debug(' Inserting into hz_cust_prof_class_amts+');

453: IF x_return_status <> fnd_api.g_ret_Sts_success THEN
454: RAISE fnd_api.G_EXC_ERROR;
455: END IF;
456:
457: arp_standard.debug(' Inserting into hz_cust_prof_class_amts+');
458:
459: IF P_PROFILE_CLASS_AMOUNT_ID IS NULL THEN
460: OPEN cseq;
461: FETCH cseq INTO l_cust_prof_class_amt_id;

Line 469: INSERT INTO hz_cust_prof_class_Amts

465: END IF;
466:
467: arp_standard.debug('P_TRX_CREDIT_LIMIT :'||P_TRX_CREDIT_LIMIT );
468:
469: INSERT INTO hz_cust_prof_class_Amts
470: (PROFILE_CLASS_AMOUNT_ID ,
471: PROFILE_CLASS_ID ,
472: CURRENCY_CODE ,
473: TRX_CREDIT_LIMIT ,

Line 642: arp_standard.debug(' Inserting into hz_cust_prof_class_amts-');

638: P_CREATED_BY ,
639: P_CREATION_DATE ,
640: P_LAST_UPDATE_LOGIN);
641:
642: arp_standard.debug(' Inserting into hz_cust_prof_class_amts-');
643:
644: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row -');
645: EXCEPTION
646: WHEN fnd_api.G_EXC_ERROR THEN

Line 666: (p_info_rec IN hz_cust_prof_class_Amts%ROWTYPE,

662:
663:
664:
665: PROCEDURE lock_row
666: (p_info_rec IN hz_cust_prof_class_Amts%ROWTYPE,
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,
669: x_msg_data OUT NOCOPY VARCHAR2)
670: IS

Line 757: FROM hz_cust_prof_class_amts

753: LAST_UPDATE_DATE ,
754: CREATED_BY ,
755: CREATION_DATE ,
756: LAST_UPDATE_LOGIN
757: FROM hz_cust_prof_class_amts
758: WHERE PROFILE_CLASS_AMOUNT_ID = p_info_rec.PROFILE_CLASS_AMOUNT_ID
759: FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;
760:
761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;

Line 759: FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;

755: CREATION_DATE ,
756: LAST_UPDATE_LOGIN
757: FROM hz_cust_prof_class_amts
758: WHERE PROFILE_CLASS_AMOUNT_ID = p_info_rec.PROFILE_CLASS_AMOUNT_ID
759: FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;
760:
761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;
762: BEGIN
763: arp_standard.debug('lock_row +');

Line 761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;

757: FROM hz_cust_prof_class_amts
758: WHERE PROFILE_CLASS_AMOUNT_ID = p_info_rec.PROFILE_CLASS_AMOUNT_ID
759: FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;
760:
761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;
762: BEGIN
763: arp_standard.debug('lock_row +');
764: arp_standard.debug(' PROFILE_CLASS_AMOUNT_ID:'||p_info_rec.PROFILE_CLASS_AMOUNT_ID);
765:

Line 948: fnd_message.set_token('TABLE', 'hz_cust_prof_class_amts');

944: THEN
945: RETURN;
946: ELSE
947: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
948: fnd_message.set_token('TABLE', 'hz_cust_prof_class_amts');
949: fnd_msg_pub.add;
950: RAISE fnd_api.g_exc_error;
951: END IF;
952:

Line 1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');

1100: IF x_return_status <> fnd_api.g_ret_Sts_success THEN
1101: RAISE fnd_api.G_EXC_ERROR;
1102: END IF;
1103:
1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');
1105: arp_standard.debug(' P_TRX_CREDIT_LIMIT:'||P_TRX_CREDIT_LIMIT);
1106:
1107: UPDATE hz_cust_prof_class_Amts
1108: SET

Line 1107: UPDATE hz_cust_prof_class_Amts

1103:
1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');
1105: arp_standard.debug(' P_TRX_CREDIT_LIMIT:'||P_TRX_CREDIT_LIMIT);
1106:
1107: UPDATE hz_cust_prof_class_Amts
1108: SET
1109: CURRENCY_CODE = P_CURRENCY_CODE,
1110: TRX_CREDIT_LIMIT = P_TRX_CREDIT_LIMIT,
1111: OVERALL_CREDIT_LIMIT = P_OVERALL_CREDIT_LIMIT,

Line 1192: arp_standard.debug(' updating hz_cust_prof_class_amts -');

1188: LAST_UPDATE_DATE = SYSDATE,
1189: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
1190: WHERE PROFILE_CLASS_AMOUNT_ID = P_PROFILE_CLASS_AMOUNT_ID;
1191:
1192: arp_standard.debug(' updating hz_cust_prof_class_amts -');
1193:
1194: arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row -');
1195: EXCEPTION
1196: WHEN FND_API.G_EXC_ERROR THEN

Line 1287: INSERT INTO HZ_CUST_PROF_CLASS_AMTS

1283: X_MIN_INTEREST_CHARGE NUMBER
1284: ) IS
1285:
1286: BEGIN
1287: INSERT INTO HZ_CUST_PROF_CLASS_AMTS
1288: (
1289: profile_class_id,
1290: created_by,
1291: creation_date,

Line 1570: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROF_CLASS_AMTS

1566: number_in_update number;
1567:
1568: BEGIN
1569:
1570: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROF_CLASS_AMTS
1571: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1572:
1573: SELECT count(*), min(profile_class_amount_id) - 1
1574: INTO number_in_update, X_Negative_Id

Line 1575: FROM HZ_CUST_PROF_CLASS_AMTS

1571: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1572:
1573: SELECT count(*), min(profile_class_amount_id) - 1
1574: INTO number_in_update, X_Negative_Id
1575: FROM HZ_CUST_PROF_CLASS_AMTS
1576: WHERE profile_class_amount_id BETWEEN
1577: (X_Cust_Prof_Class_Amount_Id) * (-100) - 99 AND
1578: (X_Cust_Prof_Class_Amount_Id) * (-100) - 2;
1579:

Line 1595: from hz_cust_prof_class_amts

1591: ) IS
1592:
1593: CURSOR C is
1594: select *
1595: from hz_cust_prof_class_amts
1596: where profile_class_amount_id = X_Cust_Prof_Class_Amount_Id
1597: FOR UPDATE of profile_class_amount_id NOWAIT;
1598: Amountinfo C%ROWTYPE;
1599: