DBA Data[Home] [Help]

APPS.XNP_TIMER_CORE dependencies on FND_MESSAGE

Line 354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');

350: FETCH c_timer_status into x_timer_id, x_status;
351: IF c_timer_status%NOTFOUND
352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;

Line 355: fnd_message.set_token('REFERENCE_ID',p_reference_id);

351: IF c_timer_status%NOTFOUND
352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;

Line 356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);

352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;
360: EXCEPTION

Line 357: x_error_message := fnd_message.get;

353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;
360: EXCEPTION
361: WHEN OTHERS THEN

Line 455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;

451: FETCH c_update_timer_status INTO v_Timer_Registry;
452:
453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry

Line 456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;

452:
453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry
460: SET status = p_status

Line 457: x_error_message:= FND_MESSAGE.get ;

453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry
460: SET status = p_status
461: WHERE CURRENT OF c_update_timer_status;

Line 513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;

509:
510: EXCEPTION
511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;

Line 514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;

510: EXCEPTION
511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;
518:

Line 515: x_error_message := FND_MESSAGE.get ;

511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;
518:
519: -----------------------------------------------------------------------------

Line 624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;

620: ,x_error_message => x_error_message
621: );
622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:

Line 625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;

621: );
622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:
629: EXCEPTION

Line 626: x_error_message:= FND_MESSAGE.get ;

622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:
629: EXCEPTION
630: WHEN ex_timer_not_found THEN

Line 642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;

638:
639:
640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN

Line 643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;

639:
640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN
647: THEN

Line 644: x_error_message:= FND_MESSAGE.get ;

640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN
647: THEN
648: CLOSE c_timer_status_id;

Line 1105: fnd_message.set_name('XNP','STD_ERROR');

1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: -- Grab the error message and error no.
1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;

Line 1106: fnd_message.set_token('ERROR_LOCN'

1102: WHEN OTHERS THEN
1103: -- Grab the error message and error no.
1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;

Line 1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;
1111:
1112: END FIRE;

Line 1109: x_error_message := fnd_message.get;

1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;
1111:
1112: END FIRE;
1113: