DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_MESSAGE

Line 314: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');

310: OPEN WORKORDER_CUR(p_x_ahl_mtltxn_rec.WORKORDER_NAME);
311: FETCH WORKORDER_CUR INTO L_WORKDET_REC;
312: IF WORKORDER_CUR%NOTFOUND
313: THEN
314: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');
315: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_name);
316: FND_MSG_PUB.ADD;
317: x_return_status := Fnd_Api.G_RET_STS_ERROR;
318: -- fix for re-open issue in bug# 6773241

Line 315: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_name);

311: FETCH WORKORDER_CUR INTO L_WORKDET_REC;
312: IF WORKORDER_CUR%NOTFOUND
313: THEN
314: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');
315: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_name);
316: FND_MSG_PUB.ADD;
317: x_return_status := Fnd_Api.G_RET_STS_ERROR;
318: -- fix for re-open issue in bug# 6773241
319: ELSIF L_WORKDET_REC.JOB_STATUS_CODE<>'3' AND

Line 324: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');

320: --L_WORKDET_REC.JOB_STATUS_CODE<>'19' AND
321: L_WORKDET_REC.JOB_STATUS_CODE<>'20' AND
322: --L_WORKDET_REC.JOB_STATUS_CODE<>'6' AND
323: L_WORKDET_REC.JOB_STATUS_CODE<>'4' THEN
324: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
325: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_REC.job_status_meaning);
326: FND_MSG_PUB.ADD;
327: x_return_status := Fnd_Api.G_RET_STS_ERROR;
328: ELSE

Line 325: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_REC.job_status_meaning);

321: L_WORKDET_REC.JOB_STATUS_CODE<>'20' AND
322: --L_WORKDET_REC.JOB_STATUS_CODE<>'6' AND
323: L_WORKDET_REC.JOB_STATUS_CODE<>'4' THEN
324: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
325: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_REC.job_status_meaning);
326: FND_MSG_PUB.ADD;
327: x_return_status := Fnd_Api.G_RET_STS_ERROR;
328: ELSE
329: p_x_ahl_mtltxn_rec.Workorder_Id :=L_WORKDET_REC.WORKORDER_ID;

Line 337: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_WORKORDER_ID');

333: p_x_ahl_mtltxn_rec.Wip_Entity_Id :=L_WORKDET_REC.WIP_ENTITY_ID;
334: END IF; -- WORKORDER_CUR%NOTFOUND
335: CLOSE WORKORDER_CUR;
336: ELSE -- both Workorder_Id and WORKORDER_NAME are NULLs
337: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_WORKORDER_ID');
338: FND_MSG_PUB.ADD;
339: x_return_status := Fnd_Api.G_RET_STS_ERROR;
340: END IF; -- p_x_ahl_mtltxn_rec.WORKORDER_NAME
341: ELSE -- workorderId is not null.

Line 346: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');

342: OPEN WORKORDER_ID_CUR(p_x_ahl_mtltxn_rec.Workorder_Id);
343: FETCH WORKORDER_ID_CUR INTO L_WORKDET_ID_REC;
344: IF WORKORDER_ID_CUR%NOTFOUND
345: THEN
346: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');
347: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
348: FND_MSG_PUB.ADD;
349: x_return_status := Fnd_Api.G_RET_STS_ERROR;
350: -- fix for re-open issue in bug# 6773241

Line 347: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);

343: FETCH WORKORDER_ID_CUR INTO L_WORKDET_ID_REC;
344: IF WORKORDER_ID_CUR%NOTFOUND
345: THEN
346: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER');
347: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
348: FND_MSG_PUB.ADD;
349: x_return_status := Fnd_Api.G_RET_STS_ERROR;
350: -- fix for re-open issue in bug# 6773241
351: ELSIF L_WORKDET_ID_REC.JOB_STATUS_CODE<>'3' AND -- Released

Line 357: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');

353: L_WORKDET_ID_REC.JOB_STATUS_CODE<>'20' AND -- pending deferral
354: --L_WORKDET_ID_REC.JOB_STATUS_CODE<>'6' AND -- on hold
355: L_WORKDET_ID_REC.JOB_STATUS_CODE<>'4' -- complete
356: THEN
357: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
358: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_ID_REC.job_status_meaning);
359: FND_MSG_PUB.ADD;
360: x_return_status := Fnd_Api.G_RET_STS_ERROR;
361: ELSE

Line 358: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_ID_REC.job_status_meaning);

354: --L_WORKDET_ID_REC.JOB_STATUS_CODE<>'6' AND -- on hold
355: L_WORKDET_ID_REC.JOB_STATUS_CODE<>'4' -- complete
356: THEN
357: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
358: FND_MESSAGE.Set_Token('STATUS',L_WORKDET_ID_REC.job_status_meaning);
359: FND_MSG_PUB.ADD;
360: x_return_status := Fnd_Api.G_RET_STS_ERROR;
361: ELSE
362: p_x_ahl_mtltxn_rec.Workorder_Id := L_WORKDET_ID_REC.WORKORDER_ID;

Line 374: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_OPER_SEQ');

370:
371: -- Check for operation sequence number.
372: IF ( p_x_ahl_mtltxn_rec.Operation_Seq_num IS NULL
373: OR p_x_ahl_mtltxn_rec.Operation_Seq_num = FND_API.G_MISS_NUM) THEN
374: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_OPER_SEQ');
375: FND_MSG_PUB.ADD;
376: x_return_status := Fnd_Api.G_RET_STS_ERROR;
377: END IF;
378:

Line 393: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY_WO');

389: END IF;
390: OPEN WIP_JOB_ID_CUR(p_x_ahl_mtltxn_rec.Workorder_Id);
391: FETCH WIP_JOB_ID_CUR INTO p_x_ahl_mtltxn_rec.Wip_Entity_Id,p_x_ahl_mtltxn_rec.Organization_Id ;
392: IF(WIP_JOB_ID_CUR%NOTFOUND) THEN
393: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY_WO');
394: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
395: FND_MSG_PUB.ADD;
396: x_return_status := Fnd_Api.G_RET_STS_ERROR;
397: END IF;

Line 394: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);

390: OPEN WIP_JOB_ID_CUR(p_x_ahl_mtltxn_rec.Workorder_Id);
391: FETCH WIP_JOB_ID_CUR INTO p_x_ahl_mtltxn_rec.Wip_Entity_Id,p_x_ahl_mtltxn_rec.Organization_Id ;
392: IF(WIP_JOB_ID_CUR%NOTFOUND) THEN
393: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY_WO');
394: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
395: FND_MSG_PUB.ADD;
396: x_return_status := Fnd_Api.G_RET_STS_ERROR;
397: END IF;
398: CLOSE WIP_JOB_ID_CUR;

Line 419: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');

415: OPEN WO_OP_CUR(p_x_ahl_mtltxn_rec.Workorder_Id,
416: p_x_ahl_mtltxn_rec.Operation_Seq_num);
417: FETCH WO_OP_CUR INTO p_x_ahl_mtltxn_rec.Workorder_Operation_Id ;
418: IF(WO_OP_CUR%NOTFOUND) THEN
419: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');
420: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
421: FND_MESSAGE.Set_Token('OP_SEQUENCE',p_x_ahl_mtltxn_rec.Operation_Seq_num);
422: FND_MSG_PUB.ADD;
423: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 420: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);

416: p_x_ahl_mtltxn_rec.Operation_Seq_num);
417: FETCH WO_OP_CUR INTO p_x_ahl_mtltxn_rec.Workorder_Operation_Id ;
418: IF(WO_OP_CUR%NOTFOUND) THEN
419: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');
420: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
421: FND_MESSAGE.Set_Token('OP_SEQUENCE',p_x_ahl_mtltxn_rec.Operation_Seq_num);
422: FND_MSG_PUB.ADD;
423: x_return_status := Fnd_Api.G_RET_STS_ERROR;
424: END IF;

Line 421: FND_MESSAGE.Set_Token('OP_SEQUENCE',p_x_ahl_mtltxn_rec.Operation_Seq_num);

417: FETCH WO_OP_CUR INTO p_x_ahl_mtltxn_rec.Workorder_Operation_Id ;
418: IF(WO_OP_CUR%NOTFOUND) THEN
419: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');
420: FND_MESSAGE.Set_Token('WORKORDER',p_x_ahl_mtltxn_rec.Workorder_Id);
421: FND_MESSAGE.Set_Token('OP_SEQUENCE',p_x_ahl_mtltxn_rec.Operation_Seq_num);
422: FND_MSG_PUB.ADD;
423: x_return_status := Fnd_Api.G_RET_STS_ERROR;
424: END IF;
425: CLOSE WO_OP_CUR;

Line 439: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_TXN_TYPE');

435: AHL_DEBUG_PUB.debug('Converting Txn type name['||p_x_ahl_mtltxn_rec.Transaction_Type_Name||']');
436: END IF;
437: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Name IS NULL
438: OR p_x_ahl_mtltxn_rec.Transaction_Type_Name = FND_API.G_MISS_CHAR) THEN
439: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_TXN_TYPE');
440: FND_MSG_PUB.ADD;
441: x_return_status := Fnd_Api.G_RET_STS_ERROR;
442: ELSE
443: OPEN Transaction_Type_Cur(p_x_ahl_mtltxn_rec.Transaction_Type_Name);

Line 446: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_TYPE');

442: ELSE
443: OPEN Transaction_Type_Cur(p_x_ahl_mtltxn_rec.Transaction_Type_Name);
444: FETCH Transaction_Type_Cur INTO p_x_ahl_mtltxn_rec.Transaction_Type_Id ;
445: IF(Transaction_Type_Cur%NOTFOUND) THEN
446: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_TYPE');
447: FND_MESSAGE.Set_Token('TXN_TYPE',p_x_ahl_mtltxn_rec.Transaction_Type_Name);
448: FND_MSG_PUB.ADD;
449: x_return_status := Fnd_Api.G_RET_STS_ERROR;
450: END IF;

Line 447: FND_MESSAGE.Set_Token('TXN_TYPE',p_x_ahl_mtltxn_rec.Transaction_Type_Name);

443: OPEN Transaction_Type_Cur(p_x_ahl_mtltxn_rec.Transaction_Type_Name);
444: FETCH Transaction_Type_Cur INTO p_x_ahl_mtltxn_rec.Transaction_Type_Id ;
445: IF(Transaction_Type_Cur%NOTFOUND) THEN
446: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_TYPE');
447: FND_MESSAGE.Set_Token('TXN_TYPE',p_x_ahl_mtltxn_rec.Transaction_Type_Name);
448: FND_MSG_PUB.ADD;
449: x_return_status := Fnd_Api.G_RET_STS_ERROR;
450: END IF;
451: CLOSE Transaction_Type_Cur;

Line 466: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_ITEM');

462: END IF;
463:
464: IF (p_x_ahl_mtltxn_rec.Inventory_Item_Segments IS NULL
465: OR p_x_ahl_mtltxn_rec.Inventory_Item_Segments = FND_API.G_MISS_CHAR) THEN
466: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_ITEM');
467: FND_MSG_PUB.ADD;
468: RAISE FND_API.G_EXC_ERROR;
469: ELSE
470: OPEN Item_Cur(p_x_ahl_mtltxn_rec.Organization_Id,

Line 474: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');

470: OPEN Item_Cur(p_x_ahl_mtltxn_rec.Organization_Id,
471: p_x_ahl_mtltxn_rec.Inventory_Item_Segments);
472: FETCH Item_Cur INTO p_x_ahl_mtltxn_rec.Inventory_Item_Id ;
473: IF(Item_Cur%NOTFOUND) THEN
474: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
475: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Segments);
476: FND_MSG_PUB.ADD;
477: x_return_status := Fnd_Api.G_RET_STS_ERROR;
478: END IF;

Line 475: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Segments);

471: p_x_ahl_mtltxn_rec.Inventory_Item_Segments);
472: FETCH Item_Cur INTO p_x_ahl_mtltxn_rec.Inventory_Item_Id ;
473: IF(Item_Cur%NOTFOUND) THEN
474: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
475: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Segments);
476: FND_MSG_PUB.ADD;
477: x_return_status := Fnd_Api.G_RET_STS_ERROR;
478: END IF;
479: CLOSE Item_Cur;

Line 503: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATION');

499: -- ER 5854712 (if locator not found, it will be created.)
500: /*
501: IF(Location_Cur%NOTFOUND)
502: THEN
503: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATION');
504: FND_MESSAGE.Set_Token('LOCATOR',p_x_ahl_mtltxn_rec.Locator_Segments);
505: FND_MSG_PUB.ADD;
506: x_return_status := Fnd_Api.G_RET_STS_ERROR;
507: ELSE

Line 504: FND_MESSAGE.Set_Token('LOCATOR',p_x_ahl_mtltxn_rec.Locator_Segments);

500: /*
501: IF(Location_Cur%NOTFOUND)
502: THEN
503: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATION');
504: FND_MESSAGE.Set_Token('LOCATOR',p_x_ahl_mtltxn_rec.Locator_Segments);
505: FND_MSG_PUB.ADD;
506: x_return_status := Fnd_Api.G_RET_STS_ERROR;
507: ELSE
508: */

Line 535: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REASON');

531: END IF;
532: OPEN Reason_Cur(p_x_ahl_mtltxn_rec.Reason_Name);
533: FETCH Reason_Cur INTO p_x_ahl_mtltxn_rec.Reason_Id ;
534: IF(Reason_Cur%NOTFOUND) THEN
535: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REASON');
536: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Reason_Name);
537: FND_MSG_PUB.ADD;
538: x_return_status := Fnd_Api.G_RET_STS_ERROR;
539: END IF;

Line 536: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Reason_Name);

532: OPEN Reason_Cur(p_x_ahl_mtltxn_rec.Reason_Name);
533: FETCH Reason_Cur INTO p_x_ahl_mtltxn_rec.Reason_Id ;
534: IF(Reason_Cur%NOTFOUND) THEN
535: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REASON');
536: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Reason_Name);
537: FND_MSG_PUB.ADD;
538: x_return_status := Fnd_Api.G_RET_STS_ERROR;
539: END IF;
540: CLOSE Reason_Cur;

Line 564: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');

560: END IF;
561: OPEN Fnd_Lookups_Cur(p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
562: FETCH Fnd_Lookups_Cur INTO p_x_ahl_mtltxn_rec.Problem_Code ;
563: IF(Fnd_Lookups_Cur%NOTFOUND) THEN
564: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
565: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
566: FND_MSG_PUB.ADD;
567: x_return_status := Fnd_Api.G_RET_STS_ERROR;
568: END IF;

Line 565: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code_Meaning);

561: OPEN Fnd_Lookups_Cur(p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
562: FETCH Fnd_Lookups_Cur INTO p_x_ahl_mtltxn_rec.Problem_Code ;
563: IF(Fnd_Lookups_Cur%NOTFOUND) THEN
564: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
565: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
566: FND_MSG_PUB.ADD;
567: x_return_status := Fnd_Api.G_RET_STS_ERROR;
568: END IF;
569: CLOSE Fnd_Lookups_Cur;

Line 585: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');

581: OPEN CONDITION_CUR(p_x_ahl_mtltxn_rec.Condition_Desc);
582: FETCH CONDITION_CUR INTO p_x_ahl_mtltxn_rec.Condition;
583:
584: IF(CONDITION_CUR%NOTFOUND) THEN
585: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');
586: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition_Desc);
587: FND_MSG_PUB.ADD;
588: x_return_status := Fnd_Api.G_RET_STS_ERROR;
589: END IF;

Line 586: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition_Desc);

582: FETCH CONDITION_CUR INTO p_x_ahl_mtltxn_rec.Condition;
583:
584: IF(CONDITION_CUR%NOTFOUND) THEN
585: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');
586: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition_Desc);
587: FND_MSG_PUB.ADD;
588: x_return_status := Fnd_Api.G_RET_STS_ERROR;
589: END IF;
590:

Line 614: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');

610: IF(RECEPIENT_CUR%NOTFOUND)
611: THEN
612: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
613: THEN
614: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
615: ELSE
616: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
617: END IF;
618: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

Line 616: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

612: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
613: THEN
614: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
615: ELSE
616: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
617: END IF;
618: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
619: FND_MSG_PUB.ADD;
620: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 618: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

614: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
615: ELSE
616: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
617: END IF;
618: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
619: FND_MSG_PUB.ADD;
620: x_return_status := Fnd_Api.G_RET_STS_ERROR;
621: END IF;
622: CLOSE RECEPIENT_CUR;

Line 636: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');

632: IF(RECEPIENT_CUR%NOTFOUND)
633: THEN
634: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
635: THEN
636: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
637: ELSE
638: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
639: END IF;
640: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

Line 638: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

634: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
635: THEN
636: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
637: ELSE
638: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
639: END IF;
640: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
641: FND_MSG_PUB.ADD;
642: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 640: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

636: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
637: ELSE
638: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
639: END IF;
640: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
641: FND_MSG_PUB.ADD;
642: x_return_status := Fnd_Api.G_RET_STS_ERROR;
643: ELSE
644: -- if id is available then see if this id is the same as the one retrived from the name.

Line 651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');

647: IF(l_recepient_id <> p_x_ahl_mtltxn_rec.RECEPIENT_ID)
648: THEN
649: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
650: THEN
651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
652: ELSE
653: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
654: END IF;
655: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

Line 653: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

649: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
650: THEN
651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
652: ELSE
653: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
654: END IF;
655: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
656: FND_MSG_PUB.ADD;
657: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 655: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
652: ELSE
653: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
654: END IF;
655: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
656: FND_MSG_PUB.ADD;
657: x_return_status := Fnd_Api.G_RET_STS_ERROR;
658: END IF;
659: ELSE

Line 674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');

670: IF(NVL(FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT'),'N')='Y')
671: THEN
672: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
673: THEN
674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
675: ELSE
676: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY');
677: END IF;
678: FND_MSG_PUB.ADD;

Line 676: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY');

672: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
673: THEN
674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
675: ELSE
676: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY');
677: END IF;
678: FND_MSG_PUB.ADD;
679: x_return_status := Fnd_Api.G_RET_STS_ERROR;
680: ELSE

Line 687: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');

683: IF DEFAULT_USER_CUR%NOTFOUND
684: THEN
685: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
686: THEN
687: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
688: ELSE
689: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
690: END IF;
691: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

Line 689: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

685: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
686: THEN
687: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
688: ELSE
689: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
690: END IF;
691: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
692: FND_MSG_PUB.ADD;
693: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 691: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);

687: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
688: ELSE
689: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');
690: END IF;
691: FND_MESSAGE.Set_Token('RECEPIENT',p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
692: FND_MSG_PUB.ADD;
693: x_return_status := Fnd_Api.G_RET_STS_ERROR;
694: END IF;
695: CLOSE DEFAULT_USER_CUR;

Line 708: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_UOM');

704:
705: END IF;
706: IF (p_x_ahl_mtltxn_rec.Uom_Desc IS NULL
707: OR p_x_ahl_mtltxn_rec.Uom_Desc = FND_API.G_MISS_CHAR) THEN
708: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_UOM');
709: FND_MSG_PUB.ADD;
710: x_return_status := Fnd_Api.G_RET_STS_ERROR;
711: ELSE
712: OPEN Uom_Cur(p_x_ahl_mtltxn_rec.Uom_Desc);

Line 715: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_UOM');

711: ELSE
712: OPEN Uom_Cur(p_x_ahl_mtltxn_rec.Uom_Desc);
713: FETCH Uom_Cur INTO p_x_ahl_mtltxn_rec.Uom ;
714: IF(Uom_Cur%NOTFOUND) THEN
715: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_UOM');
716: FND_MESSAGE.Set_Token('UOM',p_x_ahl_mtltxn_rec.Uom_Desc);
717: FND_MSG_PUB.ADD;
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: END IF;

Line 716: FND_MESSAGE.Set_Token('UOM',p_x_ahl_mtltxn_rec.Uom_Desc);

712: OPEN Uom_Cur(p_x_ahl_mtltxn_rec.Uom_Desc);
713: FETCH Uom_Cur INTO p_x_ahl_mtltxn_rec.Uom ;
714: IF(Uom_Cur%NOTFOUND) THEN
715: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_UOM');
716: FND_MESSAGE.Set_Token('UOM',p_x_ahl_mtltxn_rec.Uom_Desc);
717: FND_MSG_PUB.ADD;
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: END IF;
720: CLOSE Uom_Cur;

Line 997: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_WORKORDER_ID');

993: /*Public api changes: Moved to Convert_Name_To_Id api
994: --Check the context fields
995: IF ( (p_x_ahl_mtltxn_tbl(i).Workorder_Id IS NULL
996: OR p_x_ahl_mtltxn_tbl(i).Workorder_Id = FND_API.G_MISS_NUM)) THEN
997: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_WORKORDER_ID');
998: FND_MSG_PUB.ADD;
999: l_error := true;
1000: ELSIF ( p_x_ahl_mtltxn_tbl(i).Operation_Seq_num IS NULL
1001: OR p_x_ahl_mtltxn_tbl(i).Operation_Seq_num = FND_API.G_MISS_NUM) THEN

Line 1002: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_OPER_SEQ');

998: FND_MSG_PUB.ADD;
999: l_error := true;
1000: ELSIF ( p_x_ahl_mtltxn_tbl(i).Operation_Seq_num IS NULL
1001: OR p_x_ahl_mtltxn_tbl(i).Operation_Seq_num = FND_API.G_MISS_NUM) THEN
1002: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_OPER_SEQ');
1003: FND_MSG_PUB.ADD;
1004: l_error := true;
1005: ELSE
1006: */

Line 1118: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');

1114:
1115: IF (x_return_status = FND_API.G_RET_STS_ERROR
1116: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1117: CLOSE Sch_Mtl_Exists_Cur;
1118: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');
1119: FND_MESSAGE.Set_Token('MSG',x_msg_data);
1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;

Line 1119: FND_MESSAGE.Set_Token('MSG',x_msg_data);

1115: IF (x_return_status = FND_API.G_RET_STS_ERROR
1116: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1117: CLOSE Sch_Mtl_Exists_Cur;
1118: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');
1119: FND_MESSAGE.Set_Token('MSG',x_msg_data);
1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123: --END IF; -- fix for bug# 5499575

Line 1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

1208: IF G_DEBUG='Y' THEN
1209: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1210: END IF;
1211:
1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1214: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1215: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1216: FND_MSG_PUB.ADD;

Line 1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);

1209: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1210: END IF;
1211:
1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1214: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1215: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1216: FND_MSG_PUB.ADD;
1217: l_error := true;

Line 1214: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

1210: END IF;
1211:
1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1214: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1215: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1216: FND_MSG_PUB.ADD;
1217: l_error := true;
1218: END IF;

Line 1215: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);

1211:
1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1214: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1215: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1216: FND_MSG_PUB.ADD;
1217: l_error := true;
1218: END IF;
1219: CLOSE m_Txn_Error_cur;

Line 1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

1230: IF G_DEBUG='Y' THEN
1231: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1232: END IF;
1233:
1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1236: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1237: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1238: FND_MSG_PUB.ADD;

Line 1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);

1231: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1232: END IF;
1233:
1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1236: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1237: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1238: FND_MSG_PUB.ADD;
1239: l_error := true;

Line 1236: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

1232: END IF;
1233:
1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1236: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1237: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1238: FND_MSG_PUB.ADD;
1239: l_error := true;
1240: END IF;

Line 1237: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);

1233:
1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);
1236: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
1237: FND_MESSAGE.Set_Token('WO_NAME',l_workorder_name);
1238: FND_MSG_PUB.ADD;
1239: l_error := true;
1240: END IF;
1241: CLOSE Txn_Error_cur;

Line 1287: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UOMCONVERT_ERROR');

1283: );
1284:
1285: IF (l_quantity < 0)
1286: THEN
1287: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UOMCONVERT_ERROR');
1288: FND_MESSAGE.Set_Token('UOM_FROM', p_x_ahl_mtltxn_tbl(i).uom);
1289: FND_MESSAGE.Set_Token('UOM_TO', l_uom_code);
1290: FND_MSG_PUB.ADD;
1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1288: FND_MESSAGE.Set_Token('UOM_FROM', p_x_ahl_mtltxn_tbl(i).uom);

1284:
1285: IF (l_quantity < 0)
1286: THEN
1287: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UOMCONVERT_ERROR');
1288: FND_MESSAGE.Set_Token('UOM_FROM', p_x_ahl_mtltxn_tbl(i).uom);
1289: FND_MESSAGE.Set_Token('UOM_TO', l_uom_code);
1290: FND_MSG_PUB.ADD;
1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1292: END IF;

Line 1289: FND_MESSAGE.Set_Token('UOM_TO', l_uom_code);

1285: IF (l_quantity < 0)
1286: THEN
1287: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UOMCONVERT_ERROR');
1288: FND_MESSAGE.Set_Token('UOM_FROM', p_x_ahl_mtltxn_tbl(i).uom);
1289: FND_MESSAGE.Set_Token('UOM_TO', l_uom_code);
1290: FND_MSG_PUB.ADD;
1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1292: END IF;
1293: END IF;

Line 1302: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTL_NOTFOUND');

1298: p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
1299: FETCH Sch_Mtl_Cur INTO l_completed_quantity, l_uom_code, l_object_version_number;
1300:
1301: If(Sch_Mtl_Cur%NOTFOUND) THEN
1302: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTL_NOTFOUND');
1303: FND_MESSAGE.Set_Token('WO_OP',p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
1304: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
1305: FND_MSG_PUB.ADD;
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1303: FND_MESSAGE.Set_Token('WO_OP',p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);

1299: FETCH Sch_Mtl_Cur INTO l_completed_quantity, l_uom_code, l_object_version_number;
1300:
1301: If(Sch_Mtl_Cur%NOTFOUND) THEN
1302: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTL_NOTFOUND');
1303: FND_MESSAGE.Set_Token('WO_OP',p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
1304: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
1305: FND_MSG_PUB.ADD;
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSE

Line 1304: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);

1300:
1301: If(Sch_Mtl_Cur%NOTFOUND) THEN
1302: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTL_NOTFOUND');
1303: FND_MESSAGE.Set_Token('WO_OP',p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
1304: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
1305: FND_MSG_PUB.ADD;
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSE
1308:

Line 1406: FND_MESSAGE.Set_Name('AHL','AHL_PRD_AHLMTLTXN_ERROR');

1402:
1403:
1404: IF (x_return_status = FND_API.G_RET_STS_ERROR
1405: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_PRD_AHLMTLTXN_ERROR');
1407: FND_MESSAGE.Set_Token('MSG',x_msg_data);
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;

Line 1407: FND_MESSAGE.Set_Token('MSG',x_msg_data);

1403:
1404: IF (x_return_status = FND_API.G_RET_STS_ERROR
1405: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_PRD_AHLMTLTXN_ERROR');
1407: FND_MESSAGE.Set_Token('MSG',x_msg_data);
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:

Line 1721: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );

1717: );
1718:
1719: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1720: IF ( x_msg_data IS NULL ) THEN
1721: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
1722: FND_MSG_PUB.add;
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

Line 1922: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DUPLICATE_ITEM');

1918: );
1919: FETCH GET_WO_MTL_TXNS INTO L_COUNTER;
1920: IF L_COUNTER >0
1921: THEN
1922: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DUPLICATE_ITEM');
1923: FND_MESSAGE.Set_Token('INV_ITEM',p_ahl_mtltxn_rec.INVENTORY_ITEM_SEGMENTS);
1924: FND_MSG_PUB.ADD;
1925: END IF;
1926: CLOSE GET_WO_MTL_TXNS;

Line 1923: FND_MESSAGE.Set_Token('INV_ITEM',p_ahl_mtltxn_rec.INVENTORY_ITEM_SEGMENTS);

1919: FETCH GET_WO_MTL_TXNS INTO L_COUNTER;
1920: IF L_COUNTER >0
1921: THEN
1922: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DUPLICATE_ITEM');
1923: FND_MESSAGE.Set_Token('INV_ITEM',p_ahl_mtltxn_rec.INVENTORY_ITEM_SEGMENTS);
1924: FND_MSG_PUB.ADD;
1925: END IF;
1926: CLOSE GET_WO_MTL_TXNS;
1927: END;

Line 2300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');

2296:
2297: -- Validate transaction type id(should be one of wip conponent issue or return
2298: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND
2299: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN
2300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
2301: FND_MSG_PUB.ADD;
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: END IF;
2304: -- transaction quantity should be +ve always. Negative quantities are not

Line 2311: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

2307: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtltxn_rec.Quantity)||']');
2308: END IF;
2309:
2310: IF(nvl(p_x_ahl_mtltxn_rec.Quantity,0) <= 0) THEN
2311: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
2312: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtltxn_rec.Quantity);
2313: FND_MSG_PUB.ADD;
2314: x_return_status := FND_API.G_RET_STS_ERROR;
2315: END IF;

Line 2312: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtltxn_rec.Quantity);

2308: END IF;
2309:
2310: IF(nvl(p_x_ahl_mtltxn_rec.Quantity,0) <= 0) THEN
2311: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
2312: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtltxn_rec.Quantity);
2313: FND_MSG_PUB.ADD;
2314: x_return_status := FND_API.G_RET_STS_ERROR;
2315: END IF;
2316:

Line 2334: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');

2330: IF(AHL_WIPJOB_CUR%NOTFOUND) THEN
2331: IF G_DEBUG='Y' THEN
2332: AHL_DEBUG_PUB.debug('JOB validation failed');
2333: END IF;
2334: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
2335: if(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
2336: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;
2337: END IF;
2338: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);

Line 2338: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);

2334: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
2335: if(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
2336: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;
2337: END IF;
2338: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);
2339: FND_MSG_PUB.ADD;
2340: x_return_status := FND_API.G_RET_STS_ERROR;
2341: CLOSE AHL_WIPJOB_CUR;
2342: RETURN;

Line 2362: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');

2358: AND l_job_status <> C_JOB_PENDING_QA
2359: AND l_job_status <> C_JOB_COMPLETE
2360: --AND l_job_status <> C_JOB_PARTS_HOLD
2361: ) THEN
2362: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2363: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2364: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2365: FND_MSG_PUB.ADD;
2366: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2363: --FND_MESSAGE.Set_Token('STATUS',l_job_status);

2359: AND l_job_status <> C_JOB_COMPLETE
2360: --AND l_job_status <> C_JOB_PARTS_HOLD
2361: ) THEN
2362: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2363: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2364: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2365: FND_MSG_PUB.ADD;
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: END IF;

Line 2364: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);

2360: --AND l_job_status <> C_JOB_PARTS_HOLD
2361: ) THEN
2362: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2363: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2364: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2365: FND_MSG_PUB.ADD;
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: END IF;
2368: ELSE

Line 2375: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');

2371: --AND l_job_status <> C_JOB_PENDING_QA
2372: AND l_job_status <> C_JOB_COMPLETE
2373: --AND l_job_status <> C_JOB_PARTS_HOLD
2374: ) THEN
2375: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2376: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2377: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2378: FND_MSG_PUB.ADD;
2379: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2376: --FND_MESSAGE.Set_Token('STATUS',l_job_status);

2372: AND l_job_status <> C_JOB_COMPLETE
2373: --AND l_job_status <> C_JOB_PARTS_HOLD
2374: ) THEN
2375: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2376: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2377: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2378: FND_MSG_PUB.ADD;
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: END IF;

Line 2377: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);

2373: --AND l_job_status <> C_JOB_PARTS_HOLD
2374: ) THEN
2375: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_JOB_STATUS');
2376: --FND_MESSAGE.Set_Token('STATUS',l_job_status);
2377: FND_MESSAGE.Set_Token('STATUS', p_x_ahl_mtltxn_rec.Workorder_Status);
2378: FND_MSG_PUB.ADD;
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: END IF;
2381: END IF;

Line 2397: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER_OP');

2393: p_x_ahl_mtltxn_rec.Operation_Seq_Num,
2394: p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2395: FETCH AHL_WORKORDER_OPER_CUR INTO l_Count;
2396: IF(AHL_WORKORDER_OPER_CUR%NOTFOUND) THEN
2397: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER_OP');
2398: FND_MESSAGE.Set_Token('WO',p_x_ahl_mtltxn_rec.Workorder_Id);
2399: FND_MESSAGE.Set_Token('SEQ',p_x_ahl_mtltxn_rec.Operation_Seq_Num);
2400: FND_MESSAGE.Set_Token('OP',p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2401: FND_MSG_PUB.ADD;

Line 2398: FND_MESSAGE.Set_Token('WO',p_x_ahl_mtltxn_rec.Workorder_Id);

2394: p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2395: FETCH AHL_WORKORDER_OPER_CUR INTO l_Count;
2396: IF(AHL_WORKORDER_OPER_CUR%NOTFOUND) THEN
2397: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER_OP');
2398: FND_MESSAGE.Set_Token('WO',p_x_ahl_mtltxn_rec.Workorder_Id);
2399: FND_MESSAGE.Set_Token('SEQ',p_x_ahl_mtltxn_rec.Operation_Seq_Num);
2400: FND_MESSAGE.Set_Token('OP',p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2401: FND_MSG_PUB.ADD;
2402: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2399: FND_MESSAGE.Set_Token('SEQ',p_x_ahl_mtltxn_rec.Operation_Seq_Num);

2395: FETCH AHL_WORKORDER_OPER_CUR INTO l_Count;
2396: IF(AHL_WORKORDER_OPER_CUR%NOTFOUND) THEN
2397: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER_OP');
2398: FND_MESSAGE.Set_Token('WO',p_x_ahl_mtltxn_rec.Workorder_Id);
2399: FND_MESSAGE.Set_Token('SEQ',p_x_ahl_mtltxn_rec.Operation_Seq_Num);
2400: FND_MESSAGE.Set_Token('OP',p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2401: FND_MSG_PUB.ADD;
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403: END IF;

Line 2400: FND_MESSAGE.Set_Token('OP',p_x_ahl_mtltxn_rec.Workorder_Operation_Id);

2396: IF(AHL_WORKORDER_OPER_CUR%NOTFOUND) THEN
2397: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WORKORDER_OP');
2398: FND_MESSAGE.Set_Token('WO',p_x_ahl_mtltxn_rec.Workorder_Id);
2399: FND_MESSAGE.Set_Token('SEQ',p_x_ahl_mtltxn_rec.Operation_Seq_Num);
2400: FND_MESSAGE.Set_Token('OP',p_x_ahl_mtltxn_rec.Workorder_Operation_Id);
2401: FND_MSG_PUB.ADD;
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403: END IF;
2404: CLOSE AHL_WORKORDER_OPER_CUR;

Line 2433: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_TRANSACTION_DATE');

2429: IF TRANSACTION_DATE_CUR%FOUND
2430: THEN
2431: IF L_SCHED_START_DATE > p_x_ahl_mtltxn_rec.TRANSACTION_DATE
2432: THEN
2433: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_TRANSACTION_DATE');
2434: --FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);
2435: FND_MSG_PUB.ADD;
2436:
2437: END IF;

Line 2434: --FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);

2430: THEN
2431: IF L_SCHED_START_DATE > p_x_ahl_mtltxn_rec.TRANSACTION_DATE
2432: THEN
2433: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_TRANSACTION_DATE');
2434: --FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);
2435: FND_MSG_PUB.ADD;
2436:
2437: END IF;
2438: END IF;

Line 2450: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');

2446: FETCH AHL_ITEM_ID_CUR INTO l_serial_Control, l_lot_control, l_revision_control, l_location_control,
2447: x_eam_item_type_id, l_primary_uom_code,
2448: l_concatenated_segments;
2449: IF(AHL_ITEM_ID_CUR%NOTFOUND) THEN
2450: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
2451: if(p_x_ahl_mtltxn_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) THEN
2452: p_x_ahl_mtltxn_rec.Inventory_Item_Id := NULL;
2453: END IF;
2454: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);

Line 2454: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);

2450: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
2451: if(p_x_ahl_mtltxn_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) THEN
2452: p_x_ahl_mtltxn_rec.Inventory_Item_Id := NULL;
2453: END IF;
2454: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtltxn_rec.Inventory_Item_Id);
2455: FND_MSG_PUB.ADD;
2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: CLOSE AHL_ITEM_ID_CUR;
2458: -- Skip the rest of the validations.

Line 2479: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');

2475: p_project_id => l_project_id,
2476: p_task_id => l_project_task_id,
2477: p_project_locator_id => l_project_locator_id);
2478: IF (l_project_locator_id IS NULL) THEN
2479: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2480: FND_MESSAGE.Set_Token('LOC',l_inv_locator_id);
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSE

Line 2480: FND_MESSAGE.Set_Token('LOC',l_inv_locator_id);

2476: p_task_id => l_project_task_id,
2477: p_project_locator_id => l_project_locator_id);
2478: IF (l_project_locator_id IS NULL) THEN
2479: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2480: FND_MESSAGE.Set_Token('LOC',l_inv_locator_id);
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSE
2484: p_x_ahl_mtltxn_rec.locator_id := l_project_locator_id;

Line 2489: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MOVEPRJ_FLAG_INVALID');

2485: p_x_ahl_mtltxn_rec.subinventory_name := l_subinventory_code;
2486: END IF;
2487: ELSE
2488: -- move_to_project_flag error.
2489: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MOVEPRJ_FLAG_INVALID');
2490: FND_MSG_PUB.ADD;
2491: END IF;
2492:
2493: END IF; -- p_x_ahl_mtltxn_rec.Locator_Id.move_to_project_flag = 'Y'

Line 2534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');

2530: -- If the item is of serial controlled check if the serial numebr is null
2531: IF((p_x_ahl_mtltxn_rec.Serial_Number IS NULL
2532: OR p_x_ahl_mtltxn_rec.Serial_Number = FND_API.G_MISS_CHAR)
2533: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
2534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
2535: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2536: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2537: FND_MSG_PUB.ADD;
2538: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2535: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);

2531: IF((p_x_ahl_mtltxn_rec.Serial_Number IS NULL
2532: OR p_x_ahl_mtltxn_rec.Serial_Number = FND_API.G_MISS_CHAR)
2533: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
2534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
2535: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2536: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2537: FND_MSG_PUB.ADD;
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: END IF;

Line 2536: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2532: OR p_x_ahl_mtltxn_rec.Serial_Number = FND_API.G_MISS_CHAR)
2533: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
2534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
2535: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2536: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2537: FND_MSG_PUB.ADD;
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: END IF;
2540:

Line 2544: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');

2540:
2541: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL AND
2542: p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR AND
2543: nvl(l_serial_Control,1) = 1) THEN
2544: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
2545: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2546: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2547: FND_MSG_PUB.ADD;
2548: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2545: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);

2541: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL AND
2542: p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR AND
2543: nvl(l_serial_Control,1) = 1) THEN
2544: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
2545: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2546: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2547: FND_MSG_PUB.ADD;
2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549: END IF;

Line 2546: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2542: p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR AND
2543: nvl(l_serial_Control,1) = 1) THEN
2544: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
2545: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
2546: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2547: FND_MSG_PUB.ADD;
2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549: END IF;
2550:

Line 2571: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INV_LOOKUP');

2567: -- validate lookup code.
2568: OPEN create_wo_cur(p_x_ahl_mtltxn_rec.create_wo_option, 'AHL_SR_WO_CREATE_OPTIONS');
2569: FETCH create_wo_cur INTO l_fnd_meaning;
2570: IF (create_wo_cur%NOTFOUND) THEN
2571: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INV_LOOKUP');
2572: FND_MESSAGE.Set_Token('LCODE',p_x_ahl_mtltxn_rec.create_wo_option);
2573: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2574: FND_MSG_PUB.ADD;
2575: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2572: FND_MESSAGE.Set_Token('LCODE',p_x_ahl_mtltxn_rec.create_wo_option);

2568: OPEN create_wo_cur(p_x_ahl_mtltxn_rec.create_wo_option, 'AHL_SR_WO_CREATE_OPTIONS');
2569: FETCH create_wo_cur INTO l_fnd_meaning;
2570: IF (create_wo_cur%NOTFOUND) THEN
2571: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INV_LOOKUP');
2572: FND_MESSAGE.Set_Token('LCODE',p_x_ahl_mtltxn_rec.create_wo_option);
2573: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2574: FND_MSG_PUB.ADD;
2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576: END IF;

Line 2573: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2569: FETCH create_wo_cur INTO l_fnd_meaning;
2570: IF (create_wo_cur%NOTFOUND) THEN
2571: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INV_LOOKUP');
2572: FND_MESSAGE.Set_Token('LCODE',p_x_ahl_mtltxn_rec.create_wo_option);
2573: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2574: FND_MSG_PUB.ADD;
2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576: END IF;
2577: CLOSE create_wo_cur;

Line 2588: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NONSRL_WO_OPT');

2584: -- Check if create_wo_option is valid based on l_serial_Control.
2585: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL ) THEN
2586: -- non-serial.
2587: IF (p_x_ahl_mtltxn_rec.create_wo_option = 'CREATE_WO_NO') THEN
2588: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NONSRL_WO_OPT');
2589: FND_MESSAGE.Set_Token('WO_OPT',l_fnd_meaning);
2590: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2591: FND_MSG_PUB.ADD;
2592: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2589: FND_MESSAGE.Set_Token('WO_OPT',l_fnd_meaning);

2585: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL ) THEN
2586: -- non-serial.
2587: IF (p_x_ahl_mtltxn_rec.create_wo_option = 'CREATE_WO_NO') THEN
2588: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NONSRL_WO_OPT');
2589: FND_MESSAGE.Set_Token('WO_OPT',l_fnd_meaning);
2590: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2591: FND_MSG_PUB.ADD;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: END IF;

Line 2590: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2586: -- non-serial.
2587: IF (p_x_ahl_mtltxn_rec.create_wo_option = 'CREATE_WO_NO') THEN
2588: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NONSRL_WO_OPT');
2589: FND_MESSAGE.Set_Token('WO_OPT',l_fnd_meaning);
2590: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2591: FND_MSG_PUB.ADD;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: END IF;
2594: END IF;

Line 2603: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERVICE_TYPE_INVALID');

2599: IF (p_x_ahl_mtltxn_rec.service_type IS NOT NULL AND p_x_ahl_mtltxn_rec.service_type <> FND_API.G_MISS_CHAR) THEN
2600: OPEN service_type_code_cur( p_x_ahl_mtltxn_rec.service_type);
2601: FETCH service_type_code_cur INTO p_x_ahl_mtltxn_rec.service_type_code;
2602: IF(service_type_code_cur%NOTFOUND) THEN
2603: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERVICE_TYPE_INVALID');
2604: FND_MSG_PUB.ADD;
2605: END IF;
2606: CLOSE service_type_code_cur;
2607: ELSIF(p_x_ahl_mtltxn_rec.service_type = FND_API.G_MISS_CHAR) THEN

Line 2619: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');

2615: -- If the item is of lot controlled check if the lot number is null
2616: IF((p_x_ahl_mtltxn_rec.Lot_Number IS NULL
2617: OR p_x_ahl_mtltxn_rec.Lot_Number = FND_API.G_MISS_CHAR)
2618: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
2619: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2620: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2621: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2622: FND_MSG_PUB.ADD;
2623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2620: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);

2616: IF((p_x_ahl_mtltxn_rec.Lot_Number IS NULL
2617: OR p_x_ahl_mtltxn_rec.Lot_Number = FND_API.G_MISS_CHAR)
2618: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
2619: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2620: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2621: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2622: FND_MSG_PUB.ADD;
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;

Line 2621: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2617: OR p_x_ahl_mtltxn_rec.Lot_Number = FND_API.G_MISS_CHAR)
2618: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
2619: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2620: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2621: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2622: FND_MSG_PUB.ADD;
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;
2625: -- validate lot number.

Line 2634: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');

2630: p_x_ahl_mtltxn_rec.inventory_item_id,
2631: p_x_ahl_mtltxn_rec.Lot_Number);
2632: FETCH mtl_lot_num_csr INTO l_junk;
2633: IF (mtl_lot_num_csr%NOTFOUND) THEN
2634: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2635: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2636: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2637: FND_MSG_PUB.ADD;
2638: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2635: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);

2631: p_x_ahl_mtltxn_rec.Lot_Number);
2632: FETCH mtl_lot_num_csr INTO l_junk;
2633: IF (mtl_lot_num_csr%NOTFOUND) THEN
2634: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2635: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2636: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2637: FND_MSG_PUB.ADD;
2638: x_return_status := FND_API.G_RET_STS_ERROR;
2639: END IF;

Line 2636: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2632: FETCH mtl_lot_num_csr INTO l_junk;
2633: IF (mtl_lot_num_csr%NOTFOUND) THEN
2634: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
2635: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtltxn_rec.Lot_Number);
2636: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2637: FND_MSG_PUB.ADD;
2638: x_return_status := FND_API.G_RET_STS_ERROR;
2639: END IF;
2640: CLOSE mtl_lot_num_csr;

Line 2647: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');

2643: -- raise error if item is not lot controlled.
2644: IF ((p_x_ahl_mtltxn_rec.Lot_Number IS NOT NULL AND
2645: p_x_ahl_mtltxn_rec.Lot_Number <> FND_API.G_MISS_CHAR)
2646: AND (l_lot_Control = C_NO_LOT_CONTROL) ) THEN
2647: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');
2648: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2649: FND_MSG_PUB.ADD;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651: END IF;

Line 2648: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2644: IF ((p_x_ahl_mtltxn_rec.Lot_Number IS NOT NULL AND
2645: p_x_ahl_mtltxn_rec.Lot_Number <> FND_API.G_MISS_CHAR)
2646: AND (l_lot_Control = C_NO_LOT_CONTROL) ) THEN
2647: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');
2648: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2649: FND_MSG_PUB.ADD;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651: END IF;
2652:

Line 2666: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');

2662:
2663: IF(p_x_ahl_mtltxn_rec.Locator_Id IS NULL
2664: OR p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
2665: IF (l_location_Control <> C_NO_LOCATOR_CONTROL) THEN
2666: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2667: if(p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
2668: p_x_ahl_mtltxn_rec.Locator_Id := NULL;
2669: END IF;
2670: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);

Line 2670: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);

2666: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2667: if(p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
2668: p_x_ahl_mtltxn_rec.Locator_Id := NULL;
2669: END IF;
2670: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);
2671: FND_MSG_PUB.ADD;
2672: x_return_status := FND_API.G_RET_STS_ERROR;
2673: END IF;
2674: ELSE

Line 2683: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');

2679: p_x_ahl_mtltxn_rec.Locator_Id,
2680: p_x_ahl_mtltxn_rec.Subinventory_Name);
2681: FETCH AHL_LOCATOR_CUR INTO l_Count;
2682: IF(AHL_LOCATOR_CUR%NOTFOUND) THEN
2683: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2684: if(p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
2685: p_x_ahl_mtltxn_rec.Locator_Id := NULL;
2686: END IF;
2687: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);

Line 2687: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);

2683: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOCATOR');
2684: if(p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
2685: p_x_ahl_mtltxn_rec.Locator_Id := NULL;
2686: END IF;
2687: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtltxn_rec.Locator_Id);
2688: FND_MSG_PUB.ADD;
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: END IF;
2691: CLOSE AHL_LOCATOR_CUR;

Line 2705: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');

2701: IF (nvl(l_revision_control, -1) = 2)
2702: THEN
2703: IF (p_x_ahl_mtltxn_rec.Revision IS NULL OR p_x_ahl_mtltxn_rec.Revision = FND_API.G_MISS_CHAR)
2704: THEN
2705: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2706: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2707: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2708: FND_MSG_PUB.ADD;
2709: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2706: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);

2702: THEN
2703: IF (p_x_ahl_mtltxn_rec.Revision IS NULL OR p_x_ahl_mtltxn_rec.Revision = FND_API.G_MISS_CHAR)
2704: THEN
2705: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2706: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2707: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2708: FND_MSG_PUB.ADD;
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: ELSE

Line 2707: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2703: IF (p_x_ahl_mtltxn_rec.Revision IS NULL OR p_x_ahl_mtltxn_rec.Revision = FND_API.G_MISS_CHAR)
2704: THEN
2705: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2706: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2707: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2708: FND_MSG_PUB.ADD;
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: ELSE
2711: OPEN AHL_REVISION_CUR

Line 2720: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');

2716: );
2717: FETCH AHL_REVISION_CUR INTO l_Count;
2718: IF (AHL_REVISION_CUR%NOTFOUND)
2719: THEN
2720: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2721: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2722: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2723: FND_MSG_PUB.ADD;
2724: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2721: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);

2717: FETCH AHL_REVISION_CUR INTO l_Count;
2718: IF (AHL_REVISION_CUR%NOTFOUND)
2719: THEN
2720: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2721: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2722: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2723: FND_MSG_PUB.ADD;
2724: x_return_status := FND_API.G_RET_STS_ERROR;
2725: END IF;

Line 2722: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2718: IF (AHL_REVISION_CUR%NOTFOUND)
2719: THEN
2720: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
2721: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtltxn_rec.Revision);
2722: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2723: FND_MSG_PUB.ADD;
2724: x_return_status := FND_API.G_RET_STS_ERROR;
2725: END IF;
2726: CLOSE AHL_REVISION_CUR;

Line 2731: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');

2727: END IF;
2728: ELSE
2729: IF (p_x_ahl_mtltxn_rec.Revision IS NOT NULL AND p_x_ahl_mtltxn_rec.Revision <> FND_API.G_MISS_CHAR)
2730: THEN
2731: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
2732: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtltxn_rec.Revision);
2733: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2734: FND_MSG_PUB.ADD;
2735: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2732: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtltxn_rec.Revision);

2728: ELSE
2729: IF (p_x_ahl_mtltxn_rec.Revision IS NOT NULL AND p_x_ahl_mtltxn_rec.Revision <> FND_API.G_MISS_CHAR)
2730: THEN
2731: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
2732: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtltxn_rec.Revision);
2733: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2734: FND_MSG_PUB.ADD;
2735: x_return_status := FND_API.G_RET_STS_ERROR;
2736: END IF;

Line 2733: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

2729: IF (p_x_ahl_mtltxn_rec.Revision IS NOT NULL AND p_x_ahl_mtltxn_rec.Revision <> FND_API.G_MISS_CHAR)
2730: THEN
2731: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
2732: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtltxn_rec.Revision);
2733: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
2734: FND_MSG_PUB.ADD;
2735: x_return_status := FND_API.G_RET_STS_ERROR;
2736: END IF;
2737: END IF;

Line 2746: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVLD_REASON');

2742: p_x_ahl_mtltxn_rec.Reason_Id <> FND_API.G_MISS_NUM) THEN
2743: OPEN AHL_REASON_CUR(p_x_ahl_mtltxn_rec.Reason_Id);
2744: FETCH AHL_REASON_CUR INTO l_Count;
2745: IF(AHL_REASON_CUR%NOTFOUND) THEN
2746: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVLD_REASON');
2747: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Revision);
2748: FND_MSG_PUB.ADD;
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: END IF;

Line 2747: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Revision);

2743: OPEN AHL_REASON_CUR(p_x_ahl_mtltxn_rec.Reason_Id);
2744: FETCH AHL_REASON_CUR INTO l_Count;
2745: IF(AHL_REASON_CUR%NOTFOUND) THEN
2746: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVLD_REASON');
2747: FND_MESSAGE.Set_Token('REASON',p_x_ahl_mtltxn_rec.Revision);
2748: FND_MSG_PUB.ADD;
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: END IF;
2751: CLOSE AHL_REASON_CUR;

Line 2759: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');

2755: --Condition Validation
2756: OPEN Condition_Cur(p_x_ahl_mtltxn_rec.Condition);
2757: FETCH Condition_Cur INTO l_Count;
2758: IF(Condition_Cur%NOTFOUND) THEN
2759: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');
2760: if(p_x_ahl_mtltxn_rec.Condition = FND_API.G_MISS_NUM) THEN
2761: p_x_ahl_mtltxn_rec.Condition := NULL;
2762: END IF;
2763: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition);

Line 2763: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition);

2759: FND_MESSAGE.Set_Name('AHL','AHL_PRD_COND_INVALID');
2760: if(p_x_ahl_mtltxn_rec.Condition = FND_API.G_MISS_NUM) THEN
2761: p_x_ahl_mtltxn_rec.Condition := NULL;
2762: END IF;
2763: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Condition);
2764: FND_MSG_PUB.ADD;
2765: x_return_status := FND_API.G_RET_STS_ERROR;
2766: END IF;
2767: CLOSE Condition_Cur;

Line 2821: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CSI_INSTALL_ERROR');

2817: /*
2818: OPEN CSI_LOCATION_CUR(p_x_ahl_mtltxn_rec.Organization_Id);
2819: FETCH CSI_LOCATION_CUR INTO l_wip_location;
2820: IF(CSI_LOCATION_CUR%NOTFOUND) THEN
2821: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CSI_INSTALL_ERROR');
2822: FND_MSG_PUB.ADD;
2823: x_return_status := FND_API.G_RET_STS_ERROR;
2824: END IF;
2825: CLOSE CSI_LOCATION_CUR;

Line 2920: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');

2916: --, p_x_ahl_mtltxn_rec.Subinventory_Name;
2917: END IF;
2918: EXCEPTION
2919: WHEN NO_DATA_FOUND THEN
2920: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');
2921: FND_MSG_PUB.ADD;
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: END;
2924: p_x_ahl_mtltxn_rec.Item_Instance_ID := x_Item_Instance_Id;

Line 2969: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');

2965: p_x_ahl_mtltxn_rec.Serial_Number);
2966: --l_wip_location);
2967: FETCH CSI_SER_ITEM_CUR INTO x_Item_Instance_Id;
2968: IF(CSI_SER_ITEM_CUR%NOTFOUND) THEN
2969: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');
2970: FND_MSG_PUB.ADD;
2971: x_return_status := FND_API.G_RET_STS_ERROR;
2972: END IF;
2973: CLOSE CSI_SER_ITEM_CUR;

Line 3013: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NO_QA_RESULTS');

3009: p_x_ahl_mtltxn_rec.Qa_Collection_Id IS NULL)) THEN
3010: OPEN is_qa_coll_reqd(l_plan_id);
3011: FETCH is_qa_coll_reqd INTO l_junk;
3012: IF(is_qa_coll_reqd%FOUND) THEN
3013: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NO_QA_RESULTS');
3014: FND_MSG_PUB.ADD;
3015: x_return_status := FND_API.G_RET_STS_ERROR;
3016: END IF;
3017: CLOSE is_qa_coll_reqd;

Line 3031: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');

3027:
3028: OPEN PROBLEM_CODE_LKUP_CUR(p_x_ahl_mtltxn_rec.Problem_Code) ;
3029: FETCH PROBLEM_CODE_LKUP_CUR INTO l_count;
3030: IF(PROBLEM_CODE_LKUP_CUR%NOTFOUND) THEN
3031: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
3032: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code);
3033: FND_MSG_PUB.ADD;
3034: x_return_status := FND_API.G_RET_STS_ERROR;
3035: END IF;

Line 3032: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code);

3028: OPEN PROBLEM_CODE_LKUP_CUR(p_x_ahl_mtltxn_rec.Problem_Code) ;
3029: FETCH PROBLEM_CODE_LKUP_CUR INTO l_count;
3030: IF(PROBLEM_CODE_LKUP_CUR%NOTFOUND) THEN
3031: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
3032: FND_MESSAGE.Set_Token('CODE',p_x_ahl_mtltxn_rec.Problem_Code);
3033: FND_MSG_PUB.ADD;
3034: x_return_status := FND_API.G_RET_STS_ERROR;
3035: END IF;
3036: CLOSE PROBLEM_CODE_LKUP_CUR;

Line 3057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOT_INV');

3053: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.validate_txn_rec',
3054: 'Serial Number resides in inventory:' || p_x_ahl_mtltxn_rec.Serial_Number
3055: );
3056: END IF;
3057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOT_INV');
3058: FND_MESSAGE.Set_Token('SERIAL',p_x_ahl_mtltxn_rec.Serial_Number);
3059: FND_MSG_PUB.ADD;
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: END IF;

Line 3058: FND_MESSAGE.Set_Token('SERIAL',p_x_ahl_mtltxn_rec.Serial_Number);

3054: 'Serial Number resides in inventory:' || p_x_ahl_mtltxn_rec.Serial_Number
3055: );
3056: END IF;
3057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOT_INV');
3058: FND_MESSAGE.Set_Token('SERIAL',p_x_ahl_mtltxn_rec.Serial_Number);
3059: FND_MSG_PUB.ADD;
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: END IF;
3062: CLOSE mtl_serial_csr;

Line 3104: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');

3100: END IF;
3101: END LOOP;
3102: END IF;
3103: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3104: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3105: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3106: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3107: FND_MSG_PUB.ADD;
3108: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3105: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);

3101: END LOOP;
3102: END IF;
3103: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3104: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3105: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3106: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3107: FND_MSG_PUB.ADD;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: END IF;

Line 3106: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);

3102: END IF;
3103: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3104: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3105: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3106: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3107: FND_MSG_PUB.ADD;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: END IF;
3110: IF (k = -1) THEN

Line 3172: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');

3168: END IF;
3169: END IF;
3170:
3171: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3172: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3173: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3174: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3175: FND_MSG_PUB.ADD;
3176: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3173: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);

3169: END IF;
3170:
3171: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3172: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3173: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3174: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3175: FND_MSG_PUB.ADD;
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177: END IF;

Line 3174: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);

3170:
3171: IF (nvl(p_x_ahl_mtltxn_rec.quantity,0) + nvl(l_pend_qty,0) > nvl(l_instance_qty,0)) THEN
3172: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TXN_QTY_INVALID');
3173: FND_MESSAGE.Set_Token('QTY',p_x_ahl_mtltxn_rec.quantity);
3174: FND_MESSAGE.Set_Token('II_QTY', l_instance_qty-l_pend_qty);
3175: FND_MSG_PUB.ADD;
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177: END IF;
3178: IF (k = -1) THEN

Line 3211: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');

3207: p_x_ahl_mtltxn_rec.Inventory_Item_Id)) THEN
3208: OPEN CSI_ISSUE_SER_ITEM_CUR( p_x_ahl_mtltxn_rec.Inventory_Item_Id,p_x_ahl_mtltxn_rec.Serial_Number );
3209: FETCH CSI_ISSUE_SER_ITEM_CUR INTO p_x_ahl_mtltxn_rec.Item_Instance_ID;
3210: IF(CSI_ISSUE_SER_ITEM_CUR%NOTFOUND) THEN
3211: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_NOT_ALLOWED');
3212: FND_MSG_PUB.ADD;
3213: x_return_status := FND_API.G_RET_STS_ERROR;
3214: END IF;
3215: CLOSE CSI_ISSUE_SER_ITEM_CUR;

Line 3243: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');

3239: from_name => NULL,
3240: to_name => NULL );
3241:
3242: IF (l_quantity <> 1) THEN
3243: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3244: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3245: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3246: FND_MSG_PUB.ADD;
3247: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3244: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);

3240: to_name => NULL );
3241:
3242: IF (l_quantity <> 1) THEN
3243: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3244: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3245: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3246: FND_MSG_PUB.ADD;
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248: END IF;

Line 3245: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

3241:
3242: IF (l_quantity <> 1) THEN
3243: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3244: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3245: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3246: FND_MSG_PUB.ADD;
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248: END IF;
3249: ELSE

Line 3252: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');

3248: END IF;
3249: ELSE
3250: -- qty in primary uom.
3251: IF (p_x_ahl_mtltxn_rec.Quantity <> 1) THEN
3252: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3253: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3254: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3255: FND_MSG_PUB.ADD;
3256: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3253: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);

3249: ELSE
3250: -- qty in primary uom.
3251: IF (p_x_ahl_mtltxn_rec.Quantity <> 1) THEN
3252: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3253: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3254: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3255: FND_MSG_PUB.ADD;
3256: x_return_status := FND_API.G_RET_STS_ERROR;
3257: END IF;

Line 3254: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

3250: -- qty in primary uom.
3251: IF (p_x_ahl_mtltxn_rec.Quantity <> 1) THEN
3252: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
3253: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
3254: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3255: FND_MSG_PUB.ADD;
3256: x_return_status := FND_API.G_RET_STS_ERROR;
3257: END IF;
3258: END IF; -- uom code.

Line 3284: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');

3280:
3281: IF (p_x_ahl_mtltxn_rec.subinventory_Name IS NOT NULL AND
3282: p_x_ahl_mtltxn_rec.subinventory_Name <> FND_API.G_MISS_CHAR AND
3283: p_x_ahl_mtltxn_rec.subinventory_Name <> l_curr_subinventory_code) THEN
3284: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
3285: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
3286: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3287: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3288: FND_MSG_PUB.ADD;

Line 3285: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);

3281: IF (p_x_ahl_mtltxn_rec.subinventory_Name IS NOT NULL AND
3282: p_x_ahl_mtltxn_rec.subinventory_Name <> FND_API.G_MISS_CHAR AND
3283: p_x_ahl_mtltxn_rec.subinventory_Name <> l_curr_subinventory_code) THEN
3284: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
3285: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
3286: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3287: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3288: FND_MSG_PUB.ADD;
3289: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3286: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

3282: p_x_ahl_mtltxn_rec.subinventory_Name <> FND_API.G_MISS_CHAR AND
3283: p_x_ahl_mtltxn_rec.subinventory_Name <> l_curr_subinventory_code) THEN
3284: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
3285: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
3286: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3287: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3288: FND_MSG_PUB.ADD;
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: END IF;

Line 3287: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);

3283: p_x_ahl_mtltxn_rec.subinventory_Name <> l_curr_subinventory_code) THEN
3284: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
3285: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
3286: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3287: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3288: FND_MSG_PUB.ADD;
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: END IF;
3291:

Line 3300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');

3296: IF (p_x_ahl_mtltxn_rec.locator_id IS NOT NULL AND
3297: p_x_ahl_mtltxn_rec.locator_id <> FND_API.G_MISS_NUM AND
3298: l_curr_locator_id IS NOT NULL AND
3299: p_x_ahl_mtltxn_rec.locator_id <> l_curr_locator_id) THEN
3300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
3301: --FND_MESSAGE.Set_Token('CODE',l_curr_locator_id);
3302: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3303: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3304: FND_MSG_PUB.ADD;

Line 3301: --FND_MESSAGE.Set_Token('CODE',l_curr_locator_id);

3297: p_x_ahl_mtltxn_rec.locator_id <> FND_API.G_MISS_NUM AND
3298: l_curr_locator_id IS NOT NULL AND
3299: p_x_ahl_mtltxn_rec.locator_id <> l_curr_locator_id) THEN
3300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
3301: --FND_MESSAGE.Set_Token('CODE',l_curr_locator_id);
3302: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3303: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3304: FND_MSG_PUB.ADD;
3305: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3302: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

3298: l_curr_locator_id IS NOT NULL AND
3299: p_x_ahl_mtltxn_rec.locator_id <> l_curr_locator_id) THEN
3300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
3301: --FND_MESSAGE.Set_Token('CODE',l_curr_locator_id);
3302: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3303: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3304: FND_MSG_PUB.ADD;
3305: x_return_status := FND_API.G_RET_STS_ERROR;
3306: END IF;

Line 3303: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);

3299: p_x_ahl_mtltxn_rec.locator_id <> l_curr_locator_id) THEN
3300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
3301: --FND_MESSAGE.Set_Token('CODE',l_curr_locator_id);
3302: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3303: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3304: FND_MSG_PUB.ADD;
3305: x_return_status := FND_API.G_RET_STS_ERROR;
3306: END IF;
3307: ELSE

Line 3309: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');

3305: x_return_status := FND_API.G_RET_STS_ERROR;
3306: END IF;
3307: ELSE
3308: -- serial number not found.
3309: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
3310: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3311: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3312: FND_MSG_PUB.ADD;
3313: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3310: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

3306: END IF;
3307: ELSE
3308: -- serial number not found.
3309: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
3310: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3311: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3312: FND_MSG_PUB.ADD;
3313: x_return_status := FND_API.G_RET_STS_ERROR;
3314: END IF;

Line 3311: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);

3307: ELSE
3308: -- serial number not found.
3309: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
3310: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
3311: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtltxn_rec.Serial_Number);
3312: FND_MSG_PUB.ADD;
3313: x_return_status := FND_API.G_RET_STS_ERROR;
3314: END IF;
3315:

Line 3340: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_DATE');

3336:
3337: IF G_DEBUG='Y' THEN
3338: AHL_DEBUG_PUB.debug('Error in txn date');
3339: END IF;
3340: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_DATE');
3341: FND_MESSAGE.Set_Token('DATE',p_x_ahl_mtltxn_rec.transaction_date);
3342: FND_MSG_PUB.ADD;
3343: x_return_status := FND_API.G_RET_STS_ERROR;
3344: END IF;

Line 3341: FND_MESSAGE.Set_Token('DATE',p_x_ahl_mtltxn_rec.transaction_date);

3337: IF G_DEBUG='Y' THEN
3338: AHL_DEBUG_PUB.debug('Error in txn date');
3339: END IF;
3340: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_DATE');
3341: FND_MESSAGE.Set_Token('DATE',p_x_ahl_mtltxn_rec.transaction_date);
3342: FND_MSG_PUB.ADD;
3343: x_return_status := FND_API.G_RET_STS_ERROR;
3344: END IF;
3345:

Line 3353: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');

3349: */
3350: OPEN workorder_released_date_csr(p_x_ahl_mtltxn_rec.Wip_Entity_Id);
3351: FETCH workorder_released_date_csr INTO l_workorder_released_date;
3352: IF(workorder_released_date_csr%NOTFOUND)THEN
3353: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
3354: IF(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
3355: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;
3356: END IF;
3357: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);

Line 3357: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);

3353: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
3354: IF(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
3355: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;
3356: END IF;
3357: FND_MESSAGE.Set_Token('WIP_ENTITY',p_x_ahl_mtltxn_rec.Wip_Entity_Id);
3358: FND_MSG_PUB.ADD;
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: ELSE
3361: IF G_DEBUG='Y' THEN

Line 3369: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');

3365: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
3366: IF G_DEBUG='Y' THEN
3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');
3368: END IF;
3369: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');
3370: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));
3371: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));
3372: FND_MSG_PUB.ADD;
3373: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3370: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));

3366: IF G_DEBUG='Y' THEN
3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');
3368: END IF;
3369: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');
3370: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));
3371: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));
3372: FND_MSG_PUB.ADD;
3373: x_return_status := FND_API.G_RET_STS_ERROR;
3374: END IF;

Line 3371: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));

3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');
3368: END IF;
3369: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');
3370: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));
3371: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));
3372: FND_MSG_PUB.ADD;
3373: x_return_status := FND_API.G_RET_STS_ERROR;
3374: END IF;
3375: END IF;

Line 3402: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_DISP_INVALID');

3398: p_x_ahl_mtltxn_rec.Revision,
3399: p_x_ahl_mtltxn_rec.Lot_Number);
3400: FETCH disposition_cur INTO l_disposition_id, l_qa_collection_id, l_condition_code, l_condition_id;
3401: IF (disposition_cur%NOTFOUND) THEN
3402: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_DISP_INVALID');
3403: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);
3404: FND_MSG_PUB.ADD;
3405: x_return_status := FND_API.G_RET_STS_ERROR;
3406: END IF;

Line 3403: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);

3399: p_x_ahl_mtltxn_rec.Lot_Number);
3400: FETCH disposition_cur INTO l_disposition_id, l_qa_collection_id, l_condition_code, l_condition_id;
3401: IF (disposition_cur%NOTFOUND) THEN
3402: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_DISP_INVALID');
3403: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);
3404: FND_MSG_PUB.ADD;
3405: x_return_status := FND_API.G_RET_STS_ERROR;
3406: END IF;
3407: CLOSE disposition_cur;

Line 3410: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_NULL');

3406: END IF;
3407: CLOSE disposition_cur;
3408: IF (l_qa_collection_id IS NOT NULL) THEN
3409: IF (p_x_ahl_mtltxn_rec.qa_collection_id IS NULL) THEN
3410: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_NULL');
3411: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);
3412: FND_MSG_PUB.ADD;
3413: x_return_status := FND_API.G_RET_STS_ERROR;
3414: ELSIF (p_x_ahl_mtltxn_rec.qa_collection_id <> l_qa_collection_id) THEN

Line 3411: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);

3407: CLOSE disposition_cur;
3408: IF (l_qa_collection_id IS NOT NULL) THEN
3409: IF (p_x_ahl_mtltxn_rec.qa_collection_id IS NULL) THEN
3410: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_NULL');
3411: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);
3412: FND_MSG_PUB.ADD;
3413: x_return_status := FND_API.G_RET_STS_ERROR;
3414: ELSIF (p_x_ahl_mtltxn_rec.qa_collection_id <> l_qa_collection_id) THEN
3415: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_INVALID');

Line 3415: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_INVALID');

3411: FND_MESSAGE.Set_Token('DISP_ID',p_x_ahl_mtltxn_rec.disposition_id);
3412: FND_MSG_PUB.ADD;
3413: x_return_status := FND_API.G_RET_STS_ERROR;
3414: ELSIF (p_x_ahl_mtltxn_rec.qa_collection_id <> l_qa_collection_id) THEN
3415: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_INVALID');
3416: FND_MESSAGE.Set_Token('QA_I',p_x_ahl_mtltxn_rec.qa_collection_id);
3417: FND_MESSAGE.Set_Token('QA_D',l_qa_collection_id);
3418: FND_MSG_PUB.ADD;
3419: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3416: FND_MESSAGE.Set_Token('QA_I',p_x_ahl_mtltxn_rec.qa_collection_id);

3412: FND_MSG_PUB.ADD;
3413: x_return_status := FND_API.G_RET_STS_ERROR;
3414: ELSIF (p_x_ahl_mtltxn_rec.qa_collection_id <> l_qa_collection_id) THEN
3415: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_INVALID');
3416: FND_MESSAGE.Set_Token('QA_I',p_x_ahl_mtltxn_rec.qa_collection_id);
3417: FND_MESSAGE.Set_Token('QA_D',l_qa_collection_id);
3418: FND_MSG_PUB.ADD;
3419: x_return_status := FND_API.G_RET_STS_ERROR;
3420: END IF;

Line 3417: FND_MESSAGE.Set_Token('QA_D',l_qa_collection_id);

3413: x_return_status := FND_API.G_RET_STS_ERROR;
3414: ELSIF (p_x_ahl_mtltxn_rec.qa_collection_id <> l_qa_collection_id) THEN
3415: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_QAID_INVALID');
3416: FND_MESSAGE.Set_Token('QA_I',p_x_ahl_mtltxn_rec.qa_collection_id);
3417: FND_MESSAGE.Set_Token('QA_D',l_qa_collection_id);
3418: FND_MSG_PUB.ADD;
3419: x_return_status := FND_API.G_RET_STS_ERROR;
3420: END IF;
3421: END IF;

Line 3424: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_COND_INVALID');

3420: END IF;
3421: END IF;
3422: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
3423: AND (l_condition_id <> p_x_ahl_mtltxn_rec.condition) THEN
3424: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_COND_INVALID');
3425: FND_MESSAGE.Set_Token('COND_I',p_x_ahl_mtltxn_rec.condition_desc);
3426: FND_MESSAGE.Set_Token('COND_D',l_condition_code);
3427: FND_MSG_PUB.ADD;
3428: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3425: FND_MESSAGE.Set_Token('COND_I',p_x_ahl_mtltxn_rec.condition_desc);

3421: END IF;
3422: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
3423: AND (l_condition_id <> p_x_ahl_mtltxn_rec.condition) THEN
3424: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_COND_INVALID');
3425: FND_MESSAGE.Set_Token('COND_I',p_x_ahl_mtltxn_rec.condition_desc);
3426: FND_MESSAGE.Set_Token('COND_D',l_condition_code);
3427: FND_MSG_PUB.ADD;
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;

Line 3426: FND_MESSAGE.Set_Token('COND_D',l_condition_code);

3422: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
3423: AND (l_condition_id <> p_x_ahl_mtltxn_rec.condition) THEN
3424: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_COND_INVALID');
3425: FND_MESSAGE.Set_Token('COND_I',p_x_ahl_mtltxn_rec.condition_desc);
3426: FND_MESSAGE.Set_Token('COND_D',l_condition_code);
3427: FND_MSG_PUB.ADD;
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;
3430: END IF; -- -- p_x_ahl_mtltxn_rec.disposition_id

Line 3662: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

3658: IF G_DEBUG='Y' THEN
3659: AHL_DEBUG_PUB.debug('inserted in mmtt..ret_status['||x_return_status||']');
3660: END IF;
3661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3662: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3663: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3664: FND_MSG_PUB.ADD;
3665: RAISE FND_API.G_EXC_ERROR;
3666: END IF;

Line 3663: FND_MESSAGE.Set_Token('MSG',x_msg_data);

3659: AHL_DEBUG_PUB.debug('inserted in mmtt..ret_status['||x_return_status||']');
3660: END IF;
3661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3662: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3663: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3664: FND_MSG_PUB.ADD;
3665: RAISE FND_API.G_EXC_ERROR;
3666: END IF;
3667:

Line 3719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

3715: IF G_DEBUG='Y' THEN
3716: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3717: END IF;
3718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3720: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3721: FND_MSG_PUB.ADD;
3722: RAISE FND_API.G_EXC_ERROR;
3723: END IF;

Line 3720: FND_MESSAGE.Set_Token('MSG',x_msg_data);

3716: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3717: END IF;
3718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3720: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3721: FND_MSG_PUB.ADD;
3722: RAISE FND_API.G_EXC_ERROR;
3723: END IF;
3724: IF G_DEBUG='Y' THEN

Line 3740: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

3736:
3737: END IF;
3738:
3739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3740: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3741: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3742: FND_MSG_PUB.ADD;
3743: RAISE FND_API.G_EXC_ERROR;
3744: END IF;

Line 3741: FND_MESSAGE.Set_Token('MSG',x_msg_data);

3737: END IF;
3738:
3739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3740: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3741: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3742: FND_MSG_PUB.ADD;
3743: RAISE FND_API.G_EXC_ERROR;
3744: END IF;
3745:

Line 3774: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

3770: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3771:
3772: END IF;
3773: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3774: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3775: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;

Line 3775: FND_MESSAGE.Set_Token('MSG',x_msg_data);

3771:
3772: END IF;
3773: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3774: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3775: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;
3779:

Line 3808: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

3804:
3805: END IF;
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3808: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3809: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3810: FND_MSG_PUB.ADD;
3811: RAISE FND_API.G_EXC_ERROR;
3812: END IF;

Line 3809: FND_MESSAGE.Set_Token('MSG',x_msg_data);

3805: END IF;
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3808: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3809: FND_MESSAGE.Set_Token('MSG',x_msg_data);
3810: FND_MSG_PUB.ADD;
3811: RAISE FND_API.G_EXC_ERROR;
3812: END IF;
3813: END IF;

Line 3900: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');

3896: END IF;
3897: OPEN Workop_Det_Cur( p_mtl_txn_Rec.Workorder_Id);
3898: FETCH Workop_Det_Cur INTO l_Visit_Id,l_visit_task_Id,l_project_id,l_project_Task_id;
3899: IF(Workop_Det_Cur%NOTFOUND) THEN
3900: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WO_OP');
3901: FND_MSG_PUB.ADD;
3902: CLOSE Workop_Det_Cur;
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;

Line 3921: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');

3917: /*
3918: OPEN Item_Desc_Cur( p_mtl_txn_Rec.Organization_id, p_mtl_txn_Rec.Inventory_Item_Id);
3919: FETCH Item_Desc_Cur INTO l_Item_Desc;
3920: IF(Item_Desc_Cur%NOTFOUND) THEN
3921: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
3922: FND_MESSAGE.Set_Token('FIELD',p_mtl_txn_Rec.Inventory_Item_Id);
3923: FND_MSG_PUB.ADD;
3924: CLOSE Item_Desc_Cur;
3925: RAISE FND_API.G_EXC_ERROR;

Line 3922: FND_MESSAGE.Set_Token('FIELD',p_mtl_txn_Rec.Inventory_Item_Id);

3918: OPEN Item_Desc_Cur( p_mtl_txn_Rec.Organization_id, p_mtl_txn_Rec.Inventory_Item_Id);
3919: FETCH Item_Desc_Cur INTO l_Item_Desc;
3920: IF(Item_Desc_Cur%NOTFOUND) THEN
3921: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
3922: FND_MESSAGE.Set_Token('FIELD',p_mtl_txn_Rec.Inventory_Item_Id);
3923: FND_MSG_PUB.ADD;
3924: CLOSE Item_Desc_Cur;
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;

Line 4007: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');

4003: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');
4004:
4005: END IF;
4006: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4007: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');
4008: FND_MESSAGE.Set_Token('MSG',x_msg_data);
4009: FND_MSG_PUB.ADD;
4010: RAISE FND_API.G_EXC_ERROR;
4011: END IF;

Line 4008: FND_MESSAGE.Set_Token('MSG',x_msg_data);

4004:
4005: END IF;
4006: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4007: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');
4008: FND_MESSAGE.Set_Token('MSG',x_msg_data);
4009: FND_MSG_PUB.ADD;
4010: RAISE FND_API.G_EXC_ERROR;
4011: END IF;
4012:

Line 4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

4592: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
4593: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
4594:
4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);
4598: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtl_txn_rec.Inventory_Item_Id);
4599: FND_MESSAGE.Set_Token('WO_NAME',p_x_ahl_mtl_txn_rec.workorder_id);
4600: FND_MSG_PUB.ADD;

Line 4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);

4593: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
4594:
4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);
4598: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtl_txn_rec.Inventory_Item_Id);
4599: FND_MESSAGE.Set_Token('WO_NAME',p_x_ahl_mtl_txn_rec.workorder_id);
4600: FND_MSG_PUB.ADD;
4601: RAISE FND_API.G_EXC_ERROR;

Line 4598: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtl_txn_rec.Inventory_Item_Id);

4594:
4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);
4598: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtl_txn_rec.Inventory_Item_Id);
4599: FND_MESSAGE.Set_Token('WO_NAME',p_x_ahl_mtl_txn_rec.workorder_id);
4600: FND_MSG_PUB.ADD;
4601: RAISE FND_API.G_EXC_ERROR;
4602:

Line 4599: FND_MESSAGE.Set_Token('WO_NAME',p_x_ahl_mtl_txn_rec.workorder_id);

4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);
4598: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtl_txn_rec.Inventory_Item_Id);
4599: FND_MESSAGE.Set_Token('WO_NAME',p_x_ahl_mtl_txn_rec.workorder_id);
4600: FND_MSG_PUB.ADD;
4601: RAISE FND_API.G_EXC_ERROR;
4602:
4603: END INSERT_MTL_TXN_INTF;

Line 7223: FND_MESSAGE.Set_Name('AHL','AHL_COM_GENERIC_ERROR');

7219: FOR CLREC IN CL
7220: LOOP
7221: IF CLREC.error_code IS NOT NULL
7222: THEN
7223: FND_MESSAGE.Set_Name('AHL','AHL_COM_GENERIC_ERROR');
7224: FND_MESSAGE.Set_Token('MESSAGE',CLREC.error_code);
7225: FND_MSG_PUB.ADD;
7226: END IF;
7227: END LOOP;

Line 7224: FND_MESSAGE.Set_Token('MESSAGE',CLREC.error_code);

7220: LOOP
7221: IF CLREC.error_code IS NOT NULL
7222: THEN
7223: FND_MESSAGE.Set_Name('AHL','AHL_COM_GENERIC_ERROR');
7224: FND_MESSAGE.Set_Token('MESSAGE',CLREC.error_code);
7225: FND_MSG_PUB.ADD;
7226: END IF;
7227: END LOOP;
7228: end;

Line 7598: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');

7594: , data_set => p_organization_id
7595: );
7596:
7597: IF NOT(l_valid_flag) THEN
7598: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7599: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7600: FND_MSG_PUB.ADD;
7601: x_return_status := FND_API.G_RET_STS_ERROR;
7602: RETURN;

Line 7599: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);

7595: );
7596:
7597: IF NOT(l_valid_flag) THEN
7598: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7599: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7600: FND_MSG_PUB.ADD;
7601: x_return_status := FND_API.G_RET_STS_ERROR;
7602: RETURN;
7603: END IF;

Line 7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');

7616: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);
7617: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
7618: END IF;
7619:
7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7621: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);
7622: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7623: FND_MSG_PUB.ADD;
7624: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7621: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);

7617: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
7618: END IF;
7619:
7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7621: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);
7622: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7623: FND_MSG_PUB.ADD;
7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: RETURN;

Line 7622: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);

7618: END IF;
7619:
7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7621: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);
7622: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7623: FND_MSG_PUB.ADD;
7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: RETURN;
7626: END IF;