527: IF c_sel_cust_acct_relate_pk%NOTFOUND THEN
528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
529: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
530: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_RELATE_ID ));
531: FND_MSG_PUB.ADD;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535: CLOSE c_sel_cust_acct_relate_pk;
572: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
573: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
574: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_ID ) ||
575: ',' || TO_CHAR( X_RELATED_CUST_ACCOUNT_ID ) );
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: CLOSE c_sel_cust_acct_relate;
682: IF c_sel_cust_acct_relate%NOTFOUND THEN
683: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
684: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
685: FND_MESSAGE.SET_TOKEN( 'VALUE', X_ROWID );
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_ERROR;
688: END IF;
689:
690: CLOSE c_sel_cust_acct_relate;