457: 'OEBSCO',
458: TO_CHAR(delivery_id),
459: TO_CHAR(departure_id),
460: so_reservations,
461: FND_PROFILE.VALUE('USER_ID'),
462: FND_PROFILE.VALUE('LOGIN_ID'),
463: TO_CHAR(0),
464: NULL);
465:
458: TO_CHAR(delivery_id),
459: TO_CHAR(departure_id),
460: so_reservations,
461: FND_PROFILE.VALUE('USER_ID'),
462: FND_PROFILE.VALUE('LOGIN_ID'),
463: TO_CHAR(0),
464: NULL);
465:
466: IF (x_return_val = 2) THEN
517:
518: BEGIN
519:
520: IF initialized = 'N' THEN
521: request_id := to_number(FND_PROFILE.VALUE('CONC_REQUEST_ID'));
522: IF request_id IS NULL THEN
523: source := 'u';
524: request_id := -1;
525: ELSE
524: request_id := -1;
525: ELSE
526: source := 'c';
527: END IF;
528: debug_flag := FND_PROFILE.VALUE('SO_DEBUG');
529: IF debug_flag = 'Y' THEN
530: debug_level := to_number(FND_PROFILE.VALUE('OE_DEBUG_LEVEL'));
531: END IF;
532: initialized := 'Y';
526: source := 'c';
527: END IF;
528: debug_flag := FND_PROFILE.VALUE('SO_DEBUG');
529: IF debug_flag = 'Y' THEN
530: debug_level := to_number(FND_PROFILE.VALUE('OE_DEBUG_LEVEL'));
531: END IF;
532: initialized := 'Y';
533: END IF;
534: