252: OPEN C;
253: FETCH C INTO Recinfo;
254: IF ( C%NOTFOUND ) THEN
255: CLOSE C;
256: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
257: APP_EXCEPTION.RAISE_EXCEPTION;
258: END IF;
259: CLOSE C;
260:
369: AND ( X_APPLICATION_ID IS NULL ) ) )
370: ) THEN
371: RETURN;
372: ELSE
373: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
374: APP_EXCEPTION.RAISE_EXCEPTION;
375: END IF;
376:
377: END Lock_Row;
524: X_ORG_ID, -- Bug 3456489
525: X_CUST_ACCT_RELATE_ID;
526:
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;
525: X_CUST_ACCT_RELATE_ID;
526:
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;
526:
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:
568: X_ORG_ID, -- Bug 3456489
569: X_CUST_ACCT_RELATE_ID;
570:
571: IF c_sel_cust_acct_relate%NOTFOUND THEN
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;
569: X_CUST_ACCT_RELATE_ID;
570:
571: IF c_sel_cust_acct_relate%NOTFOUND THEN
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;
570:
571: IF c_sel_cust_acct_relate%NOTFOUND THEN
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;
679: X_APPLICATION_ID,
680: X_ORG_ID, -- Bug 3456489
681: X_CUST_ACCT_RELATE_ID;
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;
680: X_ORG_ID, -- Bug 3456489
681: X_CUST_ACCT_RELATE_ID;
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;
681: X_CUST_ACCT_RELATE_ID;
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: